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
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.
In that same Table, add Record ID with formula value RECORD_ID()
Make sure you close the () or it won’t work.
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”.
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.
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.