May I check if the following is possible with Airtable and in-built Automation.
Trying to use a Main table input to create a new record into a new table. However it will be created in a “selected” existing table base on Input field condition. E.g. IF “Group1” THEN Create at Table1, IF “Group2” THEN Create at Table2
I asked the same question to support and they suggested Script approach as below.
If this is true, was wondering what Script resource is needed to accomplish this.
Hi @Zahir_A - you could just set up multiple automations:
If field = Group 1, create record in Table 1
If field = Group 2, create record in Table 2
Would this work? You could something with scripts, so that when field = “something”, then, based on the value, create it in the appropriate table, but unless you’re creating lots of records and running over your automation allowance, then multiple simple automations might be a good way to go.