How can I create a Table over Automations

[Till_Hoffmann]

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.

[kuovonne]

Welcome to the Airtable community!

You can create an automation that creates a new linked record when the single select has the specified value.

[Till_Hoffmann]

What is the name of this Automation ? Can’t find this function.
Thanks for your help :slightly_smiling_face:

[kuovonne · Accepted solution]

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.