What is Table mapping?
Table mapping automates the flow of data between structured tables. This method allows you to conveniently move information from upstream structured tables into other tables, without having to copy and paste.
Configuring Table Mapping
Table mapping can be added to any structured table in either Entries or Entry Templates by navigating to the dropdown option on the column header and selecting “Add table mapping.”
You will need to select which source columns to pull data from. Multiple source columns can be selected, however only one column per table may be mapped.
After saving the mapping, a blue “Table Mapping” icon is added to the destination column to remind you that this column will be populated automatically. The submit button on Source tables will also have this icon added to remind you that data will be mapped from the table when it is clicked.
Users can edit the mapping or remove the mapping via the dropdown option on the column header.
You will be able to use Table Mapping in the following structured tables:
- Box Creation
- Plate Creation
- Workflow Task (source only)
- Workflow Output (destination only)
- Lookup (destination only)
Mapping Data After Submitting Structured Tables
After clicking “Submit” on a structured table, the previously designated data will appear in the destination table.
Note: Existing data in the downstream, mapped tables will not update if the data in the source table is edited. However, if new rows are added to the source table, the newly added data will be mapped to the appropriate sources.