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?
+21Hello,
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
Status is a single select field
Table Formation 2
Status is a single select field
Formation is a text field taking the information from table "Formation 1"
Automation
Trigger set on Status = "Refused" on table "Formation 1"
Action create record in table "Formation 2":
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":
Regards,
Pascal
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.