I’m asking the community, but let me know if I should put this in the feature request category.
I would like to be able to set a default value for a filter in a list view. The options I have in the filter are numbers and I would like to default to the largest number. Is this possible?
I would like to limit the filter options to only the options that are in the records. For example if my filter has the options 1, 2, 3, 4 ,5 and the data returned in the list only has 1, 2, 3 then only show the options 1, 2, 3 in the filter.
Right now, at least in the Airtable connection, I can only set select lists and linked records. It would be awesome if there was another option that just limited it to the available values (before filtering).
What I’m really trying to accomplish
I have detail pages that are software. Each software has versions. There exists a version number field, date field, and a notes field in versions.
I would like the user to be able to choose a version and then they can see the notes and the date field corresponding to that version. I want the default visible version to be the latest version.
Lists with a filter has gotten me close, except the issues I mentioned above.