I've been looking into data partitioning as a possible solution to bridging a pretty large collection of sheets together within our current appsheet app. We need to keep some information separated into different sheets between items within the same work book, and ideally when viewing item data, we need to be able to display just the information for that specific item.
The idea was to include an action button in the item details view that would bring us to another view displaying data from their individual partition. To accomplish this I tried making the partition expression to be reliant on the item ID value of the current row we were viewing within the item details table. However it seems the switch statement in the partition expression doesn't allow for non static values, which makes sense. The alternative I was thinking of coming up with was to have a form view set up where a user could choose from a list of items and this would set the correct partitioned sheet. However there is an issue with this, as the end goal is to release this feature in a public app, with an unknown number of users. I imagine it would cause problems when users attempt to view, add new, or edit existing records on each item's sheet if 5 other people are changing the current set partition value at the same time. I was thinking of trying to use a virtual column to maybe hold some local value on a user's device, but virtual columns also aren't editable by user's and require an explicit function to define them.
Has anyone ever encounter a way to implement something like this in app sheet while using google sheets as a background? Any help or thoughts would be greatly appreciated.
LinkedIn
Twitter
