I have 25k outlets/customers in my main table and another 25k in another. I don’t use the second table as the outlets are in counties that we aren’t interested in at the moment. I found that removing the unused ones greatly inproved speed and stopped the app “snapping” so much.
I would like to make the app evan more efficient. Can I split the outlets into tables by county and use data partitioning to direct the app to the ones in use?
Each user on the app can assign them selves counties in a User Assign Table at the moment.
|Unique Id||User Id||Outlet Rating||Counties To Include|
|Call List 1||Bob@email.com||Special Attention , Prospect , Inactive , Inactive But Revisit , Active HQ , Active , Prospect with contact made , HQ , Barred||Aberdeenshire , Avon , Berkshire , Dorset , East Sussex , Essex , Hampshire , Kent , Middlesex , Surrey , West Sussex , Wiltshire|
This is used to create a slice that creates a call list at the moment so the user can customise call lists by county, outlet rating etc.
Can data partioning be used to stop the app searching counties that are not allocated to the user?
I can create a button/user input on the app that would allow the user to maually switch between tables that the app is pointing to for instance - if user input cell contains “Kent” then use patition/worksheet “Kent”.
But can appsheet point at more than one table/tab on my googlesheet as though it is one and can the combination and number of tabs be determined by an expression.
For instance I would like the app to only use partitions that match the counties in the list by user id in the above table.
So Bob@email.com is using an app that is only searching data in these counties - Aberdeenshire , Avon , Berkshire , Dorset , East Sussex , Essex , Hampshire , Kent , Middlesex , Surrey , West Sussex , Wiltshire.
Can I just split the main table (with the exact same columns) into another worksheet/table and set up the data partitioning? Will all my expressions work exactly the same as though the moved data is still sitting in the main table?
Otherwise have I misunderstood using data partitioning?
Total number of outlets I have is 71K so it would be a pretty big table/worksheet to have them all on there.