Hello good people,
I canโt seem to find an answer to my dilemma.
I have a table of โLocationsโ with thousands of rows, and I want to reference this table when I add new โTicketsโ to another table. The problem is that the very large โlocationsโ is slowing down the sync time.
How do I separate these two table into separate apps, but still reference them? That way I donโt have to sync the large โlocationsโ table every time I sync the โticketsโ table.
You could create another sheet by importing just the one column you need and use that for the drop down.
Yes I tried stripping down the table to get rid of as much unnessasary data as possible to reduce file size, but I still need a couple of columns with vital relevant info. For exampleโฆ
I have the following columns
Unique ID , description , Address
The app still takes a while to load because I have close to 25000 rows in this table.
My thinking is to avoid having to sync the entire table since itโs never updated and only used as reference when updating other tables that need location info.
Is there a way to lookup a certain location key and grab that rows related description and address when filling out a form for the โticketsโ table?
Could you please add if there any โlogicโ that the app user uses to select a particular location out of 25000 options. How the app user currently zeroes down to select a specific record?
You may also wish to add if each user needs to access all the 25000 rows? Do users need access to only certain locations based on say usersโ own location?
User | Count |
---|---|
21 | |
15 | |
4 | |
3 | |
3 |