Adding a table field to your program's application form is a great way of collecting large amounts of detailed data from applicants in one easy-to-use field.
Create a table field
- In the Manage workspace, go to Applications
- Click Edit form, choosing your desired form if multiple have been configured
- Locate where you'd like to place the table field and click the + icon
- In the configuration tray, select Table from the Field type drop-down
- Provide a label and short title for your field as well as any desired hint or help text
- In the Options section, hover your cursor over Column A and open the drop-down
- Click Configure column
Note: from this area you can also choose to insert a column to the left, insert a column to the right, or delete the column entirely. - In the box that appears, set the column's label
- In the Column type drop-down, choose whether the column is:
- Row label
- Plain text
- Integer (1)
- Decimal (0.1)
- Decimal (0.01)
- Currency; if currency is selected, choose your desired currency
- Select the Display column calculation checkbox if you've selected a numerical column type and wish for the values to be calculated by:
-
- Sum
- Average
- Count
- Min
- Max
-
- If the Require a value in every column cell checkbox is selected, applicants must add a value to every cell in the column
- Save
- If desired, select the User can add additional rows checkbox
- Repeat for additional columns, adding more columns by clicking the + icon
- Save when you're finished
Note:
- The 'Row label' column type does not allow editing by applicants. Choosing this option requires the configuring manager to input a heading.
- When exporting applications from the platform, data collected within a table field will appear in its own 'page' or 'sheet'.
- When using column calculation, totals aren't saved as data on the application meaning that they won't appear in an export.
- The 'Average' calculator will always use the same number format as the column, which can lead to situations where the average of 1 and 2 is 2 (1.5 rounded up).
- If a column is set as required but the field itself is optional for applicants to complete, the column setting will override the field setting making it compulsory to complete before submission.