Concatenating multiple values entered in a repeating table for use or display elsewhere in the form can be done with the following procedure.
First create a hidden field inside the table - e.g., {{tally}} - that uses a simple IF statement like this in the Dynamic Value property to determine whether a user input field within the table - e.g., {{userInput}} - contains data:
IF({{userInput}}!='',1,0)
Then in the field outside the table, use the JOIN function, adding a qualification with COUNT to only JOIN if there is more than 1 row in the table:
IF(COUNT({{tally}})>1,JOIN(', ',{{userInput}}),{{userInput}})
This will concatenate all instances of the input for {{userInput}} as long as at there are more than one row in the table, separating them by a comma and space after each one. If the value of {{tally}} is only 1 - i.e., if there was only one row added to the table - then only the one entry from the table will be shown, without any comma and space afterward.
Note that the comma and space used in this example can be substituted for another conjoining element like a hard return - i.e., /n - or otherwise.
For displaying repeating values from a repeating table on an output, please see the following article: Repeating Data
Related Articles
Form Connector – QuickBooks
Our platform lets you easily add and quickly configure a one-way synchronization of form-captured data to QuickBooks. After adding and authenticating a QuickBooks Connection, QuickBooks Form Connectors can be added to Data Entry Forms to push data ...
Making fields in a repeating table required
The following workaround can be used to enforce that a field within a repeating table be required for the user to complete, even if the table is not required. Add a hidden field inside the table field {{tally}} with the following Dynamic Value, with ...
Table Field
The Table field is an advanced field that allows you to capture and display repeating data sets in a tabular format. Rows can be added or prepopulated from a data source and edited by viewing all row column data or directly viewing them on the table ...
Nesting Repeatable Data - Nested Repeating Tables
Capturing repeatable data using a repeating Table field is amazing, However, sometimes, you need to group data within other data, like putting a smaller box inside a bigger box. In the app builder, you can do this by nesting one Table Field inside ...
Viewing Form Entries in a Table
The Data area contains all data collected from app users filling out Form entries in the field. From this page you can export the data to CSV format for use in spreadsheet programs like Microsoft Excel, export Form entries to PDF and print entries ...