Hallo,
How to create a dropdown list as filter for Year and Month
From Period = This will display Year & Month
To Period = This will display Year & Month
The selection will retrieve those within the selected year and month from the table.
Please advice
Thank you in advance
Best answer by NickJ
Hi Jheng,
You could create a helper table which stores all dates in a separate table. One of the columns in this table could be in format "YYYY-MM”.
You can create a reference from this date table to your relevant table.
Via Subjects > Columns > <your_date_column> you can configure a lookup which shows for example the "YYYY-MM” field from the lookup table you just made. This will become a dropdown list in a filter form / popup.
Having a helper table for dates is super helpful in many other situations as well!
Does this help your case?
Best regards,
Nick Janssen
Hi Jheng,
You could create a helper table which stores all dates in a separate table. One of the columns in this table could be in format "YYYY-MM”.
You can create a reference from this date table to your relevant table.
Via Subjects > Columns > <your_date_column> you can configure a lookup which shows for example the "YYYY-MM” field from the lookup table you just made. This will become a dropdown list in a filter form / popup.
Having a helper table for dates is super helpful in many other situations as well!
Does this help your case?
Best regards,
Nick Janssen
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
