Using a dropdown of months to filter repeating group

Hi all

i am making a web based software for our company and would like to filter the sales repeating group with a dropdown of months.
can someone help me to set this up from start? i am still new so struggling to get this right.

Create a new datatype called “Months” and populate it with number 1 - 12 and January - December. Use this in your dropdown. Show the “name” to the user and we can use the number in the search filter.

Then use an advanced filter on your search and extract the month part of the date of the thing you want to filter.

image

6 Likes

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