Hello! Our event has earlybird, regular, and late pricing. I would like to create logic to assign the correct price based on the current date.
When we get a data export (Google Sheets), the information contains a date field, but I suspect this is only generated on submission. I have tried to do an integration with Google Calendar, but it looks like that only lets you create or reference an event.
Is there an integration or other strategy that would allow logic fields that reference the current date? My vision is to have something along the lines of:
If [today’s date] is LESS THAN [established date A], add @early_ticket to @price.
If [today’s date] is GREATER THAN [established date B], add @late_ticket to @price.
If [today’s date] is GREATER THAN [established date A] and LESS THAN [established date B], add @regular_ticket to @price.
I know there may be logic nuance there, but the main question here is whether it is possible to pull and reference a current date field for the purposes of the logic.
Thank you!
~~Jennifer