Dropdown to Filter Events by All Events, Past Events, Upcoming Events

I have a dropdown where I manually input the following values
All Events
Past Events
Upcoming Events

I’m having a hard time figuring out how to filter my repeating group accordingly (when “Past Events” is selected only show all past events. When “Upcoming Events” is selected only show all upcoming events). How would I do this?

2 Options:

  1. When creating events, you could schedule an API workflow for the time of the event. That workflow would change the status of the event from Upcoming Events to Past Events. Then all you’d need to do when filtering the repeating group is “Status = Dropdown’s value”

  2. Use conditional statements on the repeating group:

(Initial Data Source) - Show all events.

  • When Dropdown’s value is “Past Events”, only show events that are less than the current time
  • When Dropdown’s value is “Upcoming Events”, only show events that are greater than the current time
  • When Dropdown’s value is “All Events”, show all events

Got it?
Daniel

Took me a little time. But I figured it out. Thanks for your help.

1 Like

Glad to hear it! Lmk if you ever need any more help on this subject.

This topic was automatically closed after 70 days. New replies are no longer allowed.