Copying data from one table to another in Dashpivot uses a simple cross-reference formula. This method applies to Prefilled tables only. It is not possible to automatically copy all rows from a Default table, and there is no single formula that replicates an entire table. Each cell must be referenced individually.
Prerequisites
Before you begin make sure you have the following:
Plan: All Plan Types
Permission: Home Folder (Template Library) – Org Controller (or higher); Team Folder – Project Controller (or higher)
Skills Required: Dashpivot
Device Type: computer
Subscription: Dashpivot
Step-by-Step Instructions
In the Template Editor, add a Prefilled table as your source table.
Set the required number of columns and rows for your form.
Add another Prefilled table to act as your display table.
In the display table, change the relevant cells to Formula fields.
Enter the following formula in each display cell:
=Source_Table!Source_Cell
Replace:
Source_Table with the name of your source table.
Source_Cell with the specific cell reference you want to copy.
Example
If your source table is named Table1 and contains:
A1 – Project Manager: Juan dela Cruz
A2 – Civil Engineer: Jose Mercado
A3 – Architect: Mary Ann de los Santos
To copy these values into Table2:
For Table2 cell A1:
=Table1!A1
For Table2 cell A2:
=Table1!A2
For Table2 cell A3:
=Table1!A3