In action! Love it!
In action! Love it!
Very clever! I never looked into them but now I can envision the use cases for the single value column.
I wish I could do filtering like this with maps. Sigh.
Thatās what I love about Glideā¦more than one way to achieve the end result.
Beautiful! The Rollup column makes such a difference!
Sir Bob
Quick question for ya.
Details page - contains two inline lists, both lists contain common data. (Location, age)
The inline lists are from two separate sheets.
Would it be possible to have a filter that would work on both lists?
So filter on location and age when applied both lists would be filtered.
Yep. Create a singlevalue column in Sheet 2 that points to the filter choice in Sheet 1. Then recreate the if/then/else columns in Sheet 2 and add the filters.
Got ya.
Over and out
Thanks
How are you trying to filter maps? It should work the same way.
Bobās method works only with details screens.
I think the best bet for you is to have a details screen, store your choices inside an image that acts as a button. The inline list will take a map view. Would that work?
Specifically about the ābuttonā, I made something like this a while ago using Cloudinary.
So your suggestion sounds interesting but I am not sure what you mean by storing the choices in a button.
I would loose the favorites functionality from the map tab, I guess that would have to be another filter choice.
I have a separate sheet for that. The button links to the screen for that sheet where I store multiple choice components, then I get the choices back to the main sheet using the same method Robert introduced.
Regarding the favorites, you can have a choice component writing to a user-specific column that says āAllā and āFavoritesā. You can have two inline lists, the All one taking all items satisfying the original filter, the favorites one adding a further filter of Is Favorited = True.
Yes right. I am using a second inline list with visibility conditions. I wonder what is more efficient with, for instance, 20k rows. Adding columns and formulas to 20k rows ralentizes the app in my experience. Going to test
Hey @Robert_Petitto
Iāve been trying to apply your witty recipe to an inline list which is previously filtered showing āEventsā after Today.
The filtering value is written not in the first row, but in the āfirst row filtered by dateā so the Single Value Column get the first row in the sheet, which is blankā¦
Any idea?
Personally I donāt try to hold values like this in the same sheet where Iām using those values to filter the same data. I feel that using a separate sheet to hold filter values and use that new sheet as your tab, is a better way to go. Separate the data a little bit instead of trying to shove everything in one sheet.
As far as I understood from Robert recipe, in order to get the data to apply the filter it needs to be in the same sheet.
You can bring that back via a single value column.
Youāre right!
This is because your tab has sorting applied. Remove the sorting (which isnāt needed for a details view) and you should be good to go.
Great tutorial as always.
I was literally completing a tutorial for multifilter tutorial on reale estate demo yesterday