#Script airtable how to

NewEventInput) to receive the input, and then create a trigger on record creation in this table to trigger my script. One alternative I'm considering is to create a table (e.g. What is defeating me is getting the input to the script from a form. I have done that last part, the copying script works well. And then pass this input to a script that would copy the Event, copy the associated Tasks, and adjust the dates and status fields. I was hoping to gather input: Event to copy, the year to copy it to, and the date of the new Event. And I want to copy all the Tasks too, (with modified dates, and with status set to 'not yet started' instead of 'done'). So what I want to do is to copy the 'Fall 2022 Conference' Event to create a 'Fall 2023 Conference' Event. These are related one-to-many: a single Event has a number of Tasks (preparatory things that need to be done in order for the Event to be successful).Įvents repeat, from one year to the next.

So let me step back and explain what I'm trying to do.

Maybe this is just not possible in Airtable. I see the automation script as a function, and the variables I want to be set are the function's arguments, and I want to set those arguments using values from a form.

You are absolutely right, I am looking for variables to be set.

#Script airtable how to

The Configuration for running a script is quite different from the one you've included for Update Record, and I still don't see how to do what I need. Is that right?īut in my case, the action is not 'Update Record', it's 'Run a script', and I still need to get inputs there. If PaidInFull is not empty, as a result of an update, then your Update Record action does a further update to set status to Paid.