Skip to main content

I'm trying to set up an automated email to send clients after their first booking with my business. What formula can I use to identify if the record (booking) is the first one for that client (linked record from another table)?

I don't want to manually check a box to trigger the automation, as that means first manually checking if it is their first booking, and that defeats the purpose.

All I can think of is something like;

IF Booking Count = 0 at time of Record Created, then = YES

Any ideas on how this can be done? Let me know if you need more information.

you can have something like this

this is your BOOKINGS table

This is your CLIENTS table

here you have a "Counter" number field and Calculation formula field with this formula

{Counter}+1
 
then you have this automation that trigger as soon as new record is created in the "BOOKINGS" table
then find the RECORD ID of the clients
and lastly update the COUNTER field of the client
ONLY if the counter contains 0 it will send the email to the client
 
 
 
update of the Counter field of CLIENTS table
 
 
this is the logical condition for sending email
 

 

Similarly, I use views to accomplish a very similar process. When a record is created, it does not have the "checkbox" checked. I have a view that is filtered by all records that do not have the "checkbox" checked. An automation is then triggered when records enter that view. Once the email is sent, the automation checks the box, and poof, the record leaves that view. If working correctly, when I look at that view, it should be empty since the automation is doing its job and clearing it. If I see records in there, I know my automation is turned off or broken. Views and automations can be pretty powerful if used in combination with filters.

I'm assuming you have a "Clients" table and a "Bookings" table and they're linked?

If so, try creating a "Count" field in the "Clients" table to see how many booking records are linked.  Then make an automation that'll trigger when said "Count" field's value is 1, and make its action to send the email?  Don't think you need a formula field

Reply


Terms & Conditions