Help

Create same record in two tabs

Topic Labels: Automations
Solved
Jump to Solution
215 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Martin952
5 - Automation Enthusiast
5 - Automation Enthusiast


Hi Everyone, 

I have a base with 3 different tabs. Fist Tab is a Project General where I'm adding new projects. The second Tab is for a specific task (Scanning) and we are creating rows by floors, and it is linked with a specific project. The third tab is for the last task (Modeling), it needs to be tracked by floor as well. I would like to have an automation when a new floor is created in the Scanning tab, create a new record in the modeling tab with the same name, and if it is possible with the same project already linked. 

Could someone help me with that? 

Thanks!!!

1 Solution

Accepted Solutions
DisraeliGears01
6 - Interface Innovator
6 - Interface Innovator

Easy enough with Automations.

Create one with a "When record matches conditions" trigger in your Scanning table, set to fire when "Floor" and "Project Name" are not empty. Then make a Create Record action in your Modeling Table, with your field settings as Name= "Name" (from Scanning), Project Name= "Project Name" (from Scanning). You can also link the Scanning and Modeling records together recursively (I'd use the passed through Airtable record ID).

See Solution in Thread

3 Replies 3
DisraeliGears01
6 - Interface Innovator
6 - Interface Innovator

Easy enough with Automations.

Create one with a "When record matches conditions" trigger in your Scanning table, set to fire when "Floor" and "Project Name" are not empty. Then make a Create Record action in your Modeling Table, with your field settings as Name= "Name" (from Scanning), Project Name= "Project Name" (from Scanning). You can also link the Scanning and Modeling records together recursively (I'd use the passed through Airtable record ID).

Martin952
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks @DisraeliGears01 it was easier than I thought!!! Could you explain how to use "You can also link the Scanning and Modeling records together recursively (I'd use the passed through Airtable record ID)." Im lost with the records ID

DisraeliGears01
6 - Interface Innovator
6 - Interface Innovator

It's easiest to understand with previews and test steps being modeled. Recursively also might not have been the best word for what I mean.? Regardless...

Basically you can also make it link the newly created modeling record to the scanning record that triggered it's creation. All records inherently have a RecordID, even if it's not visually expressed in your base. When AT automations run, behind the scenes they use that RecordID, and you can use it to specify records. So in this automation (pic included) after the trigger is launched, it creates the new record by copying the name from the Floor field in Scanning, it creates the same project link as the scan record, and then it link the modelling record to it's scan record by RecordID. It's really just if you want to directly link Scanning-->Modeling