Hello, I have built an interface on top of a table. Within this table I have dates and I have put a column formula to get the week number. I've created a chart in the interface and I'd like a drop-down that filters by the week number but currently only allows me to filter by the date. Please help.
Question
Interface Dropdown for Week Number
+2
+28Hey
This is a fun workaround that you’ll need to build for dropdown filters on interfaces:
1. Go to your “Week” field, and click on “Formtting”
2. Make sure to toggle on the “Output to single select”
3. Type all weeks 1 to 52 (I know, this is a pain)
4. You can now use this field on your interface as a dropdown filter!
+31You’re going to need a single select field to use as a filter for this I’m afraid
I usually output the weeknumber + year to futureproof it and get an automation to paste the value from the formula field into a select field to handle this
Adam, Airtable Consultant - thetimesaving.company
+2Thank
Thank you
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.