Changing CMS options based on dates

Design help CMS
1

Hi everyone,

I have a CMS collection of events categorized as upcoming or on-demand. Upcoming events are future events, while on-demand events are past events available for re-watching.

Is there a way to automatically change an event’s category from “upcoming” to “on-demand” once its scheduled date has passed? Thank you.

2

If you’re trying to change a field in your CMS item, you could do that with an automation platform like Make or Zapier.

In most cases when I’m working with events I just filter the collection list, e.g. this would show only currently running events;

  • where end date >= today, and
  • where start date <= today

Then each collection list, you’d expose the functions you want.

Past events would be;

  • where end date < today
1 Like
3

Thank you! I considered filtering by end date, but “Upcoming” events have additional filters (location, RSVP, links, etc.) that I want to hide for “On-Demand” events. Both categories are in the same “Events” collection.

That;s why I thought the ideal thing would be to change the CMS field “Status” from “Upcoming” to “On-Demand” automatically after the event’s end date so it would sync with the category filer. So I wanted to know if there is a native Webflow solution, or would I need a third-party automation?

Here is a read-only link from the page that’s still in development Webflow - BTS Website 2024

4

I’d still use the filtering approach personally, it avoids external dependencies and costs- but if you can find an automation platform that will run a scheduled job frequently, you can keep your flags relatively current.

It could get expensive though- e.g. a scheduled cron automation running every 5 minutes would mean 288 executions per day.

Logic can update the CMS but does not have any date-comparison functionality I can recall and no cron capability. You’d also exceed the forms submissions quickly and pay $0.01 thereafter, which works out to about $80/mo at the 5-minute cron frequency.

If you’re committed to managing that externally, I’d be interested to know if any of the automated Airtable-to-CMS-sync platforms handle calculated fields. Then you could manage your events easily in Airtable and your event-categorization flag would be auto-updated without any special programming.