formula problem

[farah]

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?

[Pascal_Gallais-]

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