Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 01, 2021 10:09 AM
Dear community.
I need to set up an automation, which should be simple, but i’m new with automations in Airtable.
How can i create this automation?
Thanks in advance for your help,
Javier
Apr 01, 2021 08:59 PM
Do you have a separate Table for Clients, and are you linking each Client to an Order?
Apr 02, 2021 01:50 AM
Hi Kamille, thanks for replying.
I am not linking this information to a clients table at the moment. This information comes directly from an automation through which i get some orders made in another software (Acuity scheduling).
If it’s necessary, i can build that relation. But i don’t want to send a daily email to all my clients. I want to execute the automation daily, but it will only send that email when new orders are made (but including all orders that have an upcoming due date).
Do you think it is mandatory to create that new relation? Can’t automations “aggregate” records by a field to send them all later to the email in that field?
Thanks Kamile!
Apr 02, 2021 07:39 AM
Automations are designed to run one of two ways:
That means with your current setup, your Automation will either:
If you had your records linked to a client, as they most likely should be to begin with, then you could set an Automation to check a few Rollup/Formula fields to send each client a list of their upcoming due dates only once per day (if necessary).
Apr 06, 2021 10:07 AM
Hi! Thanks for your advice Kamille.
I’ve created that relation and created an automation that successfully sends an email when a record is updated in that clients table. The thing is airtable sometimes is going to receive 2 new rows for a client, so this automation will send two new emails, which i believe will bother clients. Any idea?
Besides, i am not sure on which plan allows me to send these emails (it doesn’t seem very clear in the pricing plans page), but airtable is suggesting me that i would have to think of another plan, otherwise i will only be able to send emails to collaborators.
Thanks for your help!
Apr 06, 2021 11:12 AM
First things first, if you don’t have a Pro (or greater) plan for that workspace, you are limited to only sending emails to base collaborators. If you are unable to upgrade your plan, try another service like Integromat or Zapier to handle sending out emails. You’ll likely have more flexibility with this option at the end of the day. I believe @ScottWorld is an Airtable/Integromat expert if you want further guidance on that sort of integration.
If you do want to stick with Airtable, you could trigger the Automation once per Client per day. The exact way to set that up will depend on a few things, likely doing something along the lines of “Trigger an automation when a Client record’s {Date Last Email Sent}
is before today”.
Apr 06, 2021 11:28 AM
Thanks, @Kamille_Parks! :grinning_face_with_big_eyes:
Yes, as Kamille mentioned, I am an Airtable/Integromat expert, and you can definitely “aggregate” records by a field in Integromat, such as aggregating records by their email address and then sending a bunch of aggregated information to each email address.
It’s a little bit tricky to setup, but you would typically use a combination of Integromat’s Aggregator & Data Store modules:
p.s. The Integromat links contain my personal referral code. If you have a budget for your project and you’d like to hire an expert consultant to help, please feel free to contact me through my website at ScottWorld.com.
Apr 07, 2021 12:00 AM
Hi! thank you both for your help, i appreciate that!
Yes, in fact, i had this scenario built with integromat, but i preferred to use just Airtable, but with these limitations, i will stick with integromat.
In the near future, if the volume of records make the client pay for a pro subscription in Airtable, i will then migrate the whole logic to Airtable, which seems much easier.
@kamille, @scott, Thanks again, have a great week!