Table records "generated" by another table

[Alexander_Rauns]

Hello :slightly_smiling_face:

I’m trying to create table with records based on two fields from another table.

E.g. the combination of “Password” Object and its connection to “Write” and “Restore” Actions should create records with the fields “Write Password” and “Restore Password” in another table.

Any suggestions on how to do this?

Hope it makes sense :grinning_face_with_big_eyes:

[Rose_K]

Hello and welcome to the Community @Alexander_Raunsholt!

What you are looking to do could be accomplished with a couple of workflows. One way to do this would be using Airtable’s Automations functionality.

The workflow would be something like:

1. Trigger: when a new action the Object’s Action’s linked record field is updated.
2. Action: Create a record in the Tasks table with the name of the object and the action.

Let me know if I can help provide any more information on the above, and if this helped answer your question please mark it as the solution :white_check_mark: .

[kuovonne · Accepted solution]

It might be a bit tricky to get the right trigger for an automation without scripting. If you use the “when record is updated” trigger; note that the automation will be triggered by both having a new record inked and when a linked record is removed, but the trigger will not be able to identify which event happened. Also, the automation will not be able to directly identify which is the new linked record. There are workarounds that involve formula fields and additional automation actions, but they can get tricky.

On the other hand, if you want to write a script, or are willing to hire someone to write a script, what you want could be accomplished with a code. The code could be either an automation script or a script that is run from a button, depending on what is best for your workflows.