Copying a row 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 replicate all rows from a Default table, and there is no single formula that copies an entire table at once. Each cell in the row 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.
Change the relevant cells in the display table to Formula fields.
Enter the following formula in each corresponding 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 Table1 contains the following in Row 1:
A1 – Project Manager: Juan dela Cruz
B1 – Civil Engineer: Jose Mercado
C1 – Architect: Mary Ann de los Santos
To copy this row into Table2:
For Table2 cell A1:
=Table1!A1
For Table2 cell B1:
=Table1!B1
For Table2 cell C1:
=Table1!C1