- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 18, 2024 09:42 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 18, 2024 10:18 AM
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
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
