Hi, I have got a problem and hope someone can help me,
I want to copy a record from one Table to another Table in the same Base when I change the Status of the Projekt via a Single Select Field.
So when I change the Single select it should be shown in the other Table.
Is it possible to get this Work ?
Edit: The Record should be also stay in the first Record
Mit freundlichen Grüßen
T.
Welcome to the Airtable community!
You can create an automation that creates a new linked record when the single select has the specified value.
Welcome to the Airtable community!
You can create an automation that creates a new linked record when the single select has the specified value.
What is the name of this Automation ? Can’t find this function.
Thanks for your help 
Your trigger is When record matches conditions. Pick the [Projekt] table and have the {Status} field be the specific status you want.
Then use a Create Record action to create the linked record.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.