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
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.