How to import/reference data from another app to improve sync

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.

0 4 419
4 REPLIES 4

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?

Top Labels in this Space