Copying a data from one cell in one table to another cell in another table uses a simple formula. Take note that there is no single formula that automatically copies all into another table.
We also can't replicate the entire data from a Default table, only the first row. Therefore this case is only applicable for copying data from a Prefilled table.
To start, navigate your cursor to the left tab and choose 'Prefilled' table under 'Table'. Set your required number of columns and rows that suit your type of form.
Drag another Prefilled table as your display field and set the display cells are 'Formula' fields.
To copy the exact data from a specific cell, use the formula:
=Source_Table!Source_Cell
Note: It is necessary to cross-reference the source table because you're using another table as the display table
where:
Source_Table - your data source
Source_Cell - the specific cell you want to copy
For example:
Given that,
Table 1 contains the names of employees in charge of the project. (Prefilled table)
Cell A1 - Project Manager: Juan dela Cruz
Cell B1 - Civil Engineer: Jose Mercado
Cell C1 - Architect: Mary Ann de los Santos
You want to autopopulate to Table 2 the the data from Table 1 as they are required. Use
Table 2 (Prefilled table)
Project In-Charge | Civil works in-charge | Architect in-charge |
A1 | B1 | C1 |
Use the formula,
For Table 2 cell A1,
=Table1!A1
For Table 2 cell B1,
=Table1!B1
For Table 2 cell C1,
=Table1!C1