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:
Best answer by kuovonne
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.
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:
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: .
+17It 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
