Skip to main content

Hi,


I want to create a new record in another table whenever a field in another record = X.


I.e. If we add a record to table A, and within that record, one of the fields is marked as #1, then, a particular record should be added to another table.


How is this possible using Airtable?


Cheers!

Hi Marcus, you could make an automation that triggers whenever a record in Table A has one of the fields marked as #1, and then use a “Create Record” action to create the record in the other table

Thanks very much Adam - I’ve been trying to configure this without success. Would you per chance be open to some paid tuition for elements I’m needing to figure out over a video chat? If yes would love to talk! www.bit.ly/meetingmarcus

Thanks very much Adam - I’ve been trying to configure this without success. Would you per chance be open to some paid tuition for elements I’m needing to figure out over a video chat? If yes would love to talk! www.bit.ly/meetingmarcus


Hey Marcus, sure, I’ve scheduled a meeting with you. I do free half hour calls, and I’m pretty sure we’ll be able to cover this bit within a half hour so there won’t be a paid element I believe

One way to do it (here’s a video: Airtable: Create new record in new table when value is X - YouTube)




  1. Create a new View in the Table where one of the possible values is X. Filter the view so it only contains values of X. Actually populate with some values, including X. You will need this later. If you don’t have the example data you will be stuck.





  1. In that same Table, add Record ID with formula value RECORD_ID()



Make sure you close the () or it won’t work.



  1. In the Table where you want X created, add the column where you want X to be added as a new record. In my example it’s “Value of X From Table with Input”.




  1. Create an Automation with the Trigger When record enters view, then select Only X as the view.

    Test the step. Make sure you have a record with the value X, e.g. that is in your view.




  1. Add Action Create Record.



Configure to run Always with Table “Table where X is created”. Add two fields: a) Field choose Name with Airtable Record ID -which is generated when you create the formula column with RECORD_ID() - and b) Value of X From Table with Input with Example Field When X as the value.



Full view

One way to do it (here’s a video: Airtable: Create new record in new table when value is X - YouTube)




  1. Create a new View in the Table where one of the possible values is X. Filter the view so it only contains values of X. Actually populate with some values, including X. You will need this later. If you don’t have the example data you will be stuck.





  1. In that same Table, add Record ID with formula value RECORD_ID()



Make sure you close the () or it won’t work.



  1. In the Table where you want X created, add the column where you want X to be added as a new record. In my example it’s “Value of X From Table with Input”.




  1. Create an Automation with the Trigger When record enters view, then select Only X as the view.

    Test the step. Make sure you have a record with the value X, e.g. that is in your view.




  1. Add Action Create Record.



Configure to run Always with Table “Table where X is created”. Add two fields: a) Field choose Name with Airtable Record ID -which is generated when you create the formula column with RECORD_ID() - and b) Value of X From Table with Input with Example Field When X as the value.



Full view


Thanks a ton for the detailed description/ answer here Jacque!

Reply


Terms & Conditions