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:
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?
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.
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.
Here are the sheets with scripts written. The scripts were done quite quickly so they could use some tuning to make them cleaner.
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.
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.
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.
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
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
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
