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
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 A2 - Civil Engineer: Jose Mercado
Cell A3 - 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)
In Charge (Formula field) | Role (Text field) | Equipment to be used (Drop down list) |
| In charge of project |
|
| Head of civil works |
|
| Consultant for exterior and interior design |
|
Use the formula,
For Table 2 cell A1,
=Table1!A1
For Table 2 cell A2,
=Table1!A2
For Table 2 cell A3,
=Table1!A3