How to create a temporary template table

[Steve_Chambers]

Hi all,

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:

1. Link to filtered view
2. 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:

1. Copies the entered values across to their corresponding OrderDetails table
2. 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?