Hello, I am trying to create an automation for assign shifts to contractors.
Here is the current structure:
Look for checkbox = true as triggerFind records in “Scheduling” where Name from record in step one is in “Offered to” linked record field.Add ...
I'm in need of the same functionality myself. So far, this is the best solution that I've seen:https://community.airtable.com/t5/other-questions/mix-synced-records-and-manually-created-records/td-p/92240
Here is the full script I ended up using (in case someone else needs it), put together by a few helpful examples across the community board. let inputData = input.config();
let musicianData = inputData.musicianData;
let presenterData = inputData.pre...
Use the SET_TIMEZONE() function whenever you are using DATETIME_FORMAT(), OR make sure that “Use the same time zone…” is toggled on for any Date: Include Time fields that you have.