Tables in Your Forms. Examples of basic tables, tables that include databases and tables that link to other forms (e.g. 1RM results)
Tables are used to capture and plan any type of information from Strength and Conditioning sessions, through to capturing family history of disease or physiological tests. All of the fields that are available on the Add Question Tab on the form Builder can be used as single fields, or as part of a table. Tables allow you to capture and plan for multiple data sets for one variable/field.
Before you start to create a table in your form, it is always import to think about the data you are capturing and plan it on paper first. Once you are happy, then build the table.
Tables are used to capture information that requires multiple values for a single Field. They can ONLY be built in a Column format (if you require a row based table, you might consider building a Matrix). The image in the example here shows an image of an injury assessment table where the field names have been turned into a table columns that captures the date of assessment (date field), subjective, objective, treatment and action information (paragraph of text fields), and also who entered the soap notes (entered by field).
Building a basic table: a hospitalisation table example
To build a table, click on the type of field that is going to be the first column in the table. In that field's Question Settings, change the Entry Mode (circled) from Normal to Table.
For the First field in the table in that field's advanced properties, you can specify the number of table rows that you want to appear on the form during data entry. For this example we are going to limit the table to 3 rows
That field is set up as a table in the event form and multiple dates can be captured. We limited the table rows to 3, but users can always add additional rows using the "Add rows button" (shown here)
To add additional fields to the table, select the type of field that you want and add it to the form. It should automatically be added to the table, but in the field's Question Settings, you can set this to table. Each field that you add will be added to that initial table
The example here shows that a Line Text (Reason for hospitalisation), Yes/No (surgery performed) and Number field (days in hospital) have been added.
We can also add in a Table Calculations underneath the table to Sum the days in hospital or number of surgeries.
Table calculation for Days in Hospital was set up using a Table calculation and performed by selecting the Aggregate "sum" for the field "Days in hospital" (this will sum all numbers in the Days in Hospital column)..
Table with a Database: You can also create tables that include a database where the database fields are also used to fill other columns in your table
The table in the image here shows a resistance training event.
This table includes 10 fields that are set to track and manage strength training data:
Exercise: A Database field that is set to a pre-built database called Exercises
Type: Is a text field that is set up with exactly the same name as the descriptor from the Exercise Database
Equipment: Is a text field that is set up with exactly the same name as the descriptor from the Exercise Database
Sets: Number (Format 0)
Reps: Number (Format 0)
Weight: calculation of 1RM * %1RM
RPE: number with min 1 and max 10
Load: Calculation (Reps * Sets * Weight)
Total Session Load: Sum (Load) is a table calculation
Total Work Time: Sum (Work) is a a table calculation
To build this table, the First table field is a database. Select database from the question options. Set the Question settings to "Table" and tick the group by box which will allow you to search your database list in the athlete history and reports modules
Then set up additional rows for the Type and Equipment (which have been set as summary fields on the actual database template)
Double check the Database names that you want to automatically pull into the form. The Type and Equipment field are exactly the same as the database. The Exercise name is set up as a Group By
Set up the rest of the table column fields such as reps, sets weight and then save the form.
Now in the actual application enter data for that form and check that when you choose a record from the database that the Type and Equipment fields are populated (e.g. when Exercise is selected, the Type and Equipment Field are automatically filled) and that the data flows correctly.
Once data is entered into the event a user will be taken to the athlete history or reports page. In the athlete history and reports, the field rows from the table will appear as separate rows on the reports as shown here
For one record (e.g. one resistance training record) that has 6 exercises entered into it, that will take up 6 rows in the athlete history page and reports pages. If you do not want the table rows to take up separate rows in the athlete history, then each field in the table needs to be set to default show in table =false (in the advanced properties). The example in the image below shows that the table were set not to show and one strength training record only takes up one row on the athlete's history. You can always click through to see the reps and set etc.