I have been trying to create a function whereby I give my user the ability to view a pivoted table.
Obviously this is not supported within appsheet so my idea is to create a workaround that uses a spreadsheet that has the data structured into a transposed manner, such as below
and then setup a series of actions/workflows to use this table as a template that the user activates from a row whilst in an Order Details view.
So for my particular app i have a parent child relationship of Order/Order Details, and i would like to marry this pivot table, lets call it - CostingSheet, to the Child (Order Details) so that the user can easily fill out fields in a quick edit table view such as below
So im guessing in order to enter the quick edit table view, i would need to create a grouped action that has:
- Link to filtered view
- Set the values of some columns in this row
The second action would populate a column in the CostingSheet table with the OrderDetails key, such as in red
Thereby allowing a form save action on the quick edit table to trigger a grouped action that:
- Copies the entered values across to their corresponding OrderDetails table
- Clears the fields
Is this idea worth pursuing or does one of the more advanced users here have a different solution to edit pivoted data?