Sep 27, 2022 04:53 AM
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?
Sep 27, 2022 06:51 AM
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
Sep 27, 2022 07:27 AM
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
Sep 27, 2022 08:41 PM
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
Sep 27, 2022 09:06 PM
One way to do it (here’s a video: Airtable: Create new record in new table when value is X - YouTube)
Make sure you close the () or it won’t work.
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.
Sep 28, 2022 03:48 AM
Thanks a ton for the detailed description/ answer here Jacque!