Glide: INFINITE and DYNAMIC Filtering!
ฝัง
- เผยแพร่เมื่อ 7 ต.ค. 2020
- Glide trickery to create your own screen filtering using choice components!
🆓 New to Glide? Start for free! glideapps.com/r/48KjZPDeWQKxW... 🤙 Creating your very own no code app with Glide is easy-get started today: glide.grsm.io/b9xcwl98fvzd
Great one BOB! We need more especially how to prevent conflicts in terms of booking. God bless you
This is one of the most helpful instructional videos yet! Thanks Bob!
Useful trick for using single values... thanks Robert!
this opened up Glide doors for me!
Glad it helped!
This technique can be applied in several manner .... thanks much lord of glide
thank you very much robert as always sharing knowledge
This really helped me. Thank you!
Much needed workaround
Thanks a lot for the help. you saved me!
thank you so much! you really help me alot!
My pleasure!
This is great video and thank you for making it. There appear to some rather simple tasks that cannot be done by Glide. Take a rather simple problem of retrieving images by tags. An image can have any number of tags and a user can search by as many or as few tags to narrow down selection. It seems one would need to fix the number of tags (Tag 1, Tag 2, Tag 3, and so on,) and give a Choice component for each column to filter the inline list. You can see the problem with this is the screen will quickly fill with Choice components. A more fundamental limitation is the number of tags per image (and the number of tags one can search on) will need to be defined upfront by the app's designer. What would be nice is to simply enter tags as a comma-separated list with variable number of items and match against the list of tags for an image. It does not appear that Glide supports the types of operations to enable this, prove me wrong :)
I can’t prove you wrong-you are correct. Glide’s search feature needs enhancing.
awesome! perfect! thx so much!
Thanks a lot ! Really helpful :D
Thank you!
Really great video! Spent hours trying to figure this out. How would you modify this for more than 2 choices e.g. age 13, 14, 15?
Merci pour ce tuto j ai été face a ce problème lors de la selection les donnees change mais avec votre solution tout est parfait maerci beaucoup
Thx Bob some more gems! Cheers
Thank you sir, can this be done in the form ..?
Love to see this done with a SQL data source. I imagine it would be a different?
This method should still work with SQL
Great and very helpful video! Thank you Bob!
One question though: In my case I keep adding property addresses and sorting the display/list by the street address. This creates a problem since the chosen value from the Choice Component will not be in the first row of the "Gender Selection" column anymore (it will show in the row where the street number is the lowest). Therefore "First" will not work for the Single Value column. Any suggestion on a work around? Thanks!
Instead of a single value column, use a join list column with no separator.
Hey Robert, Can I use this method to create dependent dropdown list?
very good solution, but I had problem when I add search to filter after choice does not work, any ideas how to solve
Great and very helpful video! Thank you Bob!
One question though:
For me, the selection always shows also the first entry in the table, although this does not match at all. Reason: The selection changes the entry in this first line so that the original entry is overwritten with the content of the selection ...
Do you have a solution for? Thanks very much
You can always use a Join Text Column instead of a single value column.
It is really helpful trick. However, for some reason, my data editor is not entering the choice on the first row but on the second. So it makes it difficult for me to use single values as it is not picking up the right info. Argh, very unfortunate.
This was an EXCELLENT lesson. Can you suggest a way to sort the choices? I'm adding weekday and month filters to a calendar in line list and want the days and months in the correct order on the pull-down choice list. Thanks!
How are you populating the choices?
@@RobertPetittoWAI've created a calendar using the correctly formatted date fields for start and end. Following your video, I created a tab with detail layout adding an inline list with calendar layout. To populate the choice fields, I have extra columns in my google sheet for each event for weekday and month in addition to the date formatted START column.
Again, following your video, I was able update my google sheet with your 3-step "weekday SELECT" column, "weekday SINGLE" column, "IF weekday" column. Repeated that for month. Then, I created the 2 CHOICE items of Weekday and Month on my details layout and placed them above the calendar item. The filtering works GREAT!!!
Now, my issue... I want the sort choices to be in order of SMTWThFS or JFMAMJJASOND. I've thought about creating a new sheet and columns that identify Sunday = 1, Monday = 2, etc., but not sure how to then tie that back to the choice item sorting.
Thanks for your great videos.
Well...that's exactly what I did. I added an IF THEN column that says If Weekday is Sunday then 1. It's works just like I want. It just feels like a great deal of clutter in my google sheet.
@@monafluitt2443 yeah…sheets might end up getting a bit more of “middle man” columns but that’s the nature of nocode!
Hi, this is a great video! How would you set this up if there are multiple ages or genders?
You'd use a multiple choice component with some slightly different logic. I'll need to create a video on that!
Brilliant job as always, Bob...but: What about GDPR? How do you handle all the personal data? Do you have written T&C forms or sections in your apps where students have to tick "I agree..." "I understand..." etc.? And is it really GDPR compliant then...?
I do typically add a terms and conditions on the sign in screen for my education apps. There’s a nice discussion on the Glode forum regarding GDPR.
Strange i am seeing General and Options no column choices is this because airtibale is my source?
Most likely
Hi bob
I tried this filtering approach but it was buggy and not working for different users. Does it have any limitations
Not to my knowledge. What bugs did you encounter?
Dear Robert,
I have applied this and it works very well. But now that Glide has changed the pricing and controls the amount of updates of updates (modified records), this has a serious impact and every time a user makes a query (search - read) an update is generated, consuming a large number of the amount of updates per month.
How can we solve this?
Eventually, Glide won't count edits made to user specific columns. Make sure to use those as the column that holds the selection.
It is very useful, but i try to follow your but seem it work once then next time the chioce select is not update in first row, but it update in the selection row that match between 2 choice. What i did wrong? I try join list column also the same. but if i am refresh, it all working fine once. i think what i want is chioce put value in only first row of column.
This means that you’re sorting the screen which causes the issue.
Use a join list column with no dilimator instead of a single value column
Thanks Bob.
Hey, Robert, can you make a Twitter like App template, I want to purchase one
Sure thing! Posts, reposts and likes?
If I make a QR Code with this formula "=image("chart.googleapis.com/chart?chs=150x150&cht=qr&chl=" & $B$2:$B&$C$2:$C)" how can I show it as image in the App?
Don't use the =image() function...just leave the raw URL in the cell and then use an image component to display.
@@RobertPetittoWA I got it! thanks a lot BOB!