Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Automtion problem

Topic Labels: Automations Sync
189 1
cancel
Showing results for 
Search instead for 
Did you mean: 
farah
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a table Formation 1 in Airtable that contains various information, including a field named Status with values such as "refused", "accepted", and "pack". I also have another table, Formation 2, which contains different information and is synchronized with the first table. I would like to set up an automation such that if an email in Formation 1 has a status of "refused", it should be added to Formation 2 with the status set to "pack solo". How can I achieve this?

1 Reply 1

Hello,

It is quite difficult to answer without a better understanding of these tables' structure, but here is what I have done to give you a hint.

Table Formation 1

Pascal_Gallais_0-1726679289321.png

Status is a single select field

Table Formation 2

Pascal_Gallais_1-1726679359651.png

Status is a single select field

Formation is a text field taking the information from table "Formation 1"

Automation

Pascal_Gallais_2-1726679455244.png

Trigger set on Status = "Refused" on table "Formation 1"

Action create record in table "Formation 2":

Pascal_Gallais_3-1726679542328.png

Status is set to "Pack solo" (make sure that this option has been set on the field Status in table "Formation 2")

Field formation is fed from table "Formation 1":

Pascal_Gallais_4-1726679689032.pngPascal_Gallais_5-1726679755168.png

Regards,

Pascal