Knowledge base
Child tables
Totals, row IDs, validation, imports and moving rows between tables.
10 answers· 2 tips
Answers
- FixHow do I loop over child table rows in an integration, and why does it repeat the first row or miss rows?Use a trigger that fires after rows exist, add an Iteration over the table, and map fields from the iteration output, not the trigger.
- How-toHow do I sum, count or concatenate a child table column?Add an aggregation field outside the table, turn on single-item context, then pick the table, column and function.
- FixWhy does my CSV import into a child table fail, stall, or import nothing?Turn on Enable table import, save the file as UTF-8 with plain alphanumeric headers, stay within 1,000 rows, and check the table isn't read-only.
- How-toHow do I use a main form field inside a child table?Add a computed column with Parent.Field_ID to bring the value into each row, then use it in table formulas.
- How-toCan each child table row get an automatic, readable row number or ID?Sequential row numbers aren't supported. Build a readable ID from the row's creation time in a computed column.
- How-toHow do I copy data from one child table to another?Use an Update an item action on the same process, set the source table for the target table, and map each column.
- How-toHow do I validate child table rows, such as a column total of 100 or unique values?Sum the column with an aggregation field and validate it on Submit; use Mark as unique for one unique column.
- FixCan a child table start with a default number of rows?Not natively. As a workaround, an integration can add blank rows when a new item is created.
- FixWhy doesn't a child table prefilled by "When an item is created" show until I refresh?The integration writes the rows a few seconds after New item is clicked, and the open form doesn't reload. Refresh the page.
- How-toHow do I run a workflow step only when a child table column has values?Concatenate the column into a hidden aggregation field, then use not(isBlank(...)) as the step condition.
Tips
- TipPrevent duplicate entries across child table rowsUse Mark as unique for one column, or combine an aggregation field with formulas and a lookup filter to block repeats.
- TipTotal a child table column with an aggregation fieldAdd an aggregation field with single-item context turned on to show the sum of a table column, such as a total price.