I have two tables in my Airtable database: "Interfaces" and "Participants Backend V1". In the "Interfaces" table, I have columns like "int_Email", "int_Name", "int_Dance Course", and "int_Today's Date" (Ceckbox). The "Participants Backend V1" table contains columns like "bac_Email", "bac_01.01.2024", "bac_02.01.2024", etc... "bac_31.12.2024"
I am looking for a script that does the following:
- Look through every row in the table "Interfaces"
- When a row in the "Interfaces" table has the "int_Today's Date" checkbox checked, the value in the "int_Tanzkurs" column of that row should be read.
- This read value should then be entered into the "Participants Backend V1" table in the row with the same email and the columne of today's date (for today it would be the column "bac_01.05.2024").
- If there is already a value in that cell, the new dance courses should be added with commas separated.
Does anybody have a recommendation? Is this possible with a scipt? Or is it even possible to automate this with the given Airtable Automation Blocks?
I tried to make a script with the help of ChatGPT but no luck so far.
Thanks for your support!