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.