# Trying to make a filter through a displayed inline list **URL:** \ **Category:** Ask for Help\ **Created:** [November 28, 2020, 4:58pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071 "2020-11-28T16:58:13Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [November 28, 2020, 4:58pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/1 "2020-11-28T16:58:13Z")
I have a sheet with the informations of the activity on one single row, with contact number and address, then other rows in other sheets have other informations about the same activity and I’d like to have a menu like this: ![lista menù](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/8/48e1c3dfd1c79f4bc9b7fa50cfc742cf808b7965.png) where the menu is the same for all the activities but the data is different, so when I click to a voice of the list menu item, it takes the relative data in the activity row, I need a correlation between row and column, and not row between row, is it possible? I managed to make it work, but I have to create a relation to the word of the menu and a lookup for every voice in the menu which uses too many columns. Is there a simpler, more automatic way of doin it that I’m missing? Thx to whoever will answer ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 28, 2020, 11:50pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/2 "2020-11-28T23:50:28Z")
You want an inline list with independent configuration, is that correct? ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 29, 2020, 12:01am UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/3 "2020-11-29T00:01:38Z")
A simpler way…I really don’t think so…A different way that’s just as fast, and uses Zero rows…yes. To do this you create another workbook in that workbook it uses IMPORTRANGE and does all of your lookup and return values there. That other workbook can have as many rows as you’d like. In your Glide workbook it does the same thing, it uses IMPORTRANGE to get the resulting values of your search. Now I know what your thinking and this may sound like it would take longer but it is actually instantaneous and allows for your glide app to have infinite rows at no cost to you. This also works with user input data. You have the other sheet import the range as to which the data is entered daily. A script runs at 1am in your glide sheets that clears the data and the other sheet has a script that runs at midnight that copies the imported range to its permanent location. This does work and its extremely reliabe and you would never notice that it occurs. I use this method on all apps I build prior to moving them to PRO. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 29, 2020, 12:05am UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/4 "2020-11-29T00:05:23Z")
Thinh, you should try out this method and close both workbooks and just see how fast it works. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [November 29, 2020, 7:04pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/5 "2020-11-29T19:04:09Z")
Very interesting, thanks, do you have any example I can have a look at? I will dig into it, but I can’t write scripts atm, any suggestion? ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 29, 2020, 7:29pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/6 "2020-11-29T19:29:45Z")
I created a scripts page here in Glide to help people with scripts. I’m sure we got one on there. Here’s the link > [@Scripts, scripts, scripts!](https://community.glideapps.com/t/scripts-scripts-scripts/18965/26): > > Here is another one that I use all the time as an alternative to ARRAYFORMULA. The neat thing about this is that it works with any formulas, whereas ARRAYFORMULA has some limitations. Again, I didn’t write this one myself, and I can’t recall where I got it from (probably Stackoverflow), so I can’t take any credit for it. But I’ve been using it for 3 or 4 years and it’s never failed me. What it does and how it works is described in the comments. > > > **Summary** > > > > /\*\* \* Copy Formulas Down \* This script… ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 29, 2020, 7:30pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/7 "2020-11-29T19:30:54Z")
I will make 2 google sheets real fast with the criteria and the lookups and importranges with scripts for you to give you an idea. You could actually use them for your project if you arent too far along. Give me a little bit though. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 29, 2020, 7:59pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/8 "2020-11-29T19:59:24Z")
Here are the sheets with scripts written. The scripts were done quite quickly so they could use some tuning to make them cleaner. > **[Glide Home Sheet](https://docs.google.com/spreadsheets/d/15-IGXi66AvDl1M_GP4F-HFbMWFo0GqLkmFUg9nqVWH8/edit?usp=sharing)** > > USERS > > USERNAME,EMAIL,AGE,GENDER,LOCATION > BOB,BOB@HOTMAIL.COM,35,MALE,USA > JAMES,JJABRAMS1981@GOOGLE.COM,48,MALE,USA > JENNY,JENNYS1234@OUTLOOK.COM,25,FEMALE,CANADA > THIS SHEET IS WHERE USER INFO IS ENTERED INTO DAILY AND IS REMOVED AT THE END OF THE DAY > **[Glide Storage Workbook](https://docs.google.com/spreadsheets/d/1YxQ6NQHQR5eRiyQuGprjxoOEkCWaZn69m29RubtULFc/edit?usp=sharing)** > > TEMP SHEET FOR STORAGE > > BOB,BOB@HOTMAIL.COM,35,MALE,USA > JAMES,JJABRAMS1981@GOOGLE.COM,48,MALE,USA > JENNY,JENNYS1234@OUTLOOK.COM,25,FEMALE,CANADA > THIS SHEET IS WHERE USER INFO IS ENTERED INTO DAILY AND IS REMOVED AT THE END OF THE DAY The first sheet would be the Glide sheet. The second is the sheet that stores the lookup and data. I used users for the example but in reality I would use a much larger database but the idea is just proof of concept so you can make it your own. The Glide sheet removes its data from 1 to 2 am every morning and the storage sheet pulls the data from 12am to 1am every morning. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [November 30, 2020, 10:40am UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/9 "2020-11-30T10:40:17Z")
I’m not sure how I can use this to make the list menu and besides, how it: > [@Drearystate](#): > > allows for your glide app to have infinite rows at no cost to you I mean: even if I import from another sheet, glide will still count those rows and I will still be subject to the app’s limits, no? ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 30, 2020, 11:07pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/10 "2020-11-30T23:07:00Z")
No, You have Glide only import the resulting data your looking for. You determine what your looking for. and build that search in the other sheet. The result gets returned to you and nothing else. Here’s a better example of this: I have a sheet for a customer database with 96,000 names, addresses,emails,etc. Glide would run too slow to support this and they don’t support this. So when a customer enters their name and phone number into glide the other sheet imports that data, it looks it up in the 96,000 people and displays the email, address, vehicle type, etc. That data it finds is setup to import back to the Glide sheet. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 30, 2020, 11:07pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/11 "2020-11-30T23:07:55Z")
So it takes up 2 rows instead of 96,002 rows… 1 row to search and 1 row to retrieve ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [November 30, 2020, 11:30pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/12 "2020-11-30T23:30:08Z")
I assume you can’t use the in app search though, right? The 25k rows limit is probably gonna be a big limit for my app, but I also use the in app search to display results in real time. Can I ask you maybe some other examples or maybe a link to the app if possible? Cause from the importrange ‘demo’ I couldn’t really understand how to use it not to use up valuable rows. Thx ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [December 1, 2020, 11:55am UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/13 "2020-12-01T11:55:33Z")
Ok,I have to make my apologies as it was late and I didn’t see the other sheets with the formulas, I am studying them now, but I’m new to sheets formulas and I’m trying to understand thelogic behind it ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 3, 2020, 7:06am UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/14 "2020-12-03T07:06:42Z")
[jciondeck.com](http://jciondeck.com) ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [December 3, 2020, 3:18pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/15 "2020-12-03T15:18:51Z")
> [@Drearystate](#): > > [jciondeck.com](http://jciondeck.com) 404 ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 3, 2020, 7:28pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/17 "2020-12-03T19:28:56Z")
> **[JCI Kiosk](https://www.jciondeck.com/)** > > Automotive Service Kiosk srry didnt have the www in front of it ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [December 3, 2020, 9:14pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/18 "2020-12-03T21:14:57Z")
Nice app, well done, so if I don’t have an appointment I can ask for a price quotation of the services I need, right? How do you manage that part wheere you send the info to the mechanic I suppose? I will surely be interested in managing many thousands of rows with your system, but right now I first need to solve the bigger problems of my app, like I need to have analytics in it (I still even need to buy pro and connect it to the domain), hoping that I can show the statistics of the different pages, links and buttons to the clients ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [December 3, 2020, 9:20pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/19 "2020-12-03T21:20:27Z")
I’m not sure if this is a problem on my end but this is all I see ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/9428f7eba8f288942eb25201fdf4fecc2bc490c3.jpeg) ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [December 3, 2020, 9:22pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/20 "2020-12-03T21:22:41Z")
Same happened to me, I thought he was fooling me XD It’s just heavy pictures and take a lot to load, give it some time and eventually a red hal9000 button will appear. I might in fact suggest @Drearystate to consider uploading smaller file size pictures in that part of the app, if the big size is the problem ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 3, 2020, 9:39pm UTC](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071/21 "2020-12-03T21:39:59Z")
Its been updated. Give it a try again. [Next page](https://community.glideapps.com/t/trying-to-make-a-filter-through-a-displayed-inline-list/19071.md?page=2)