I am creating a theatrical production database so we can link things like productions to volunteers and current season workflows. Since I’m putting in records from our past, I would like the new production record automatically linked to whatever season that production is in based on when the opening date is.
Is there any way to create an automation that updates records conditionally?
i.e. Trigger- a record with an filled “Opening Date” field and an empty “Season” field; Action- update linked “Season” field based on “Opening Date” being within the season start and end dates.
Sorry for the delay. Long story short, Airtable formulas don’t currently have the power to do what you want, but a script can do it quite easily. I can picture this working via an automation that runs a script on each new record (after certain conditions are met) to link a production to its associated season record. If you’d like to discuss options for setting this up, message me directly.