Help

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

When updating status, create an entry in one of several other tables, according to status

Topic Labels: Automations
Solved
Jump to Solution
994 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Moises_Campos
4 - Data Explorer
4 - Data Explorer

Hey all.
I am trying to use Airtable to manage farming schedules.
I’m trying to figure out an automation that would create an entry in one of four other tables, whenever I update a status on a primary table.
Specifically, I have a primary table with all the seeds I am using, and one of the field types is a single-select with labels [Seeded, Transplant, Finish, Harvest].
I also have several scheduling tables that correspond to each of those labels.
The idea then, is that when I set a seed status to “Seeded”, an entry for that seed would be created in the Seeded table, and so on for the other tables.
Would a REGEX_MATCH formula work for this? I have zero experience writing up complicated formulas.

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

If you want a no-code solution, you will use the “when record meets conditions” trigger, with one automation for each single-select value. Then use the “create record” action to create a new linked record, passing in the value of the triggering record.

If you are nearing the 25 automation limit, you can use a scripting automation with the “when updated” trigger watching the single-select field. Code is necessary in this situation in order to include branching logic.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

If you want a no-code solution, you will use the “when record meets conditions” trigger, with one automation for each single-select value. Then use the “create record” action to create a new linked record, passing in the value of the triggering record.

If you are nearing the 25 automation limit, you can use a scripting automation with the “when updated” trigger watching the single-select field. Code is necessary in this situation in order to include branching logic.

Moises_Campos
4 - Data Explorer
4 - Data Explorer

That is an excellent answer, thank you! I completely ignored the “when record meets condition” trigger. I’ll experiment some more with it.