The Table container makes it easy to build invoices, time sheets and other structures that require a column/row format. Tables can have many columns and many rows. They can be configured to automatically expand the number of rows once you enter data into the last row. You can set column widths and configure the table to pan right and left automatically on smaller screens. You can hide columns, perform calculations, apply if then else logic and capture data in cells like GPS coordinates, images and signatures. You can also print barcode labels automatically based on data in the row.
The invoice example above incorporates a data lookup for selecting products sold and then automatically populates the price for the product once a product is selected. The line amount column is calculated automatically once the user enters a qty. An additional calculation is placed below the table to sum the line amount column. In this example, a layout grid was used for the subtotal to place it under the line amount column and spacing was removed between the table and the grid.
Table label: Use the label to place a caption above your table. This is not a required field. The maximum number of characters is 500, including spaces.
Number of rows: This sets the number of rows in the table. You can enter a number between 1 and 20. Note that, while it may seem a good idea to max out the number of rows, this could unnecessarily impact the size of your form and ultimately its performance. Use the dynamically add rows option if you are not sure how many rows will be needed when a form is being filled out.
Variable row number: This option allows you to dynamically set the number of rows in your table based on the value from another field in your form. The limitation is that you cannot exceed the preset number of rows. Meaning if the number of rows setting is equal to 10 then your variable cannot exceed 10 or the user will get an error. We recommend using the dynamically add rows option and setting the number of rows to a small amount.
- All rows must be answered: This property requires that all of the rows must be entered by the user.
- Display row number: Select this property to add a first column to the table, which will display row numbers for each row.
Required rows: If you set a field in your table to be required the end result is that the system will require the user to have an entry in that column for every row in the table. This could be problematic if the user only needs to use a few rows out of the rows available. The required rows setting in tables is used to make an entire row required if data is placed in even a single column.
Use Checklist: This option is used in combination with the data lookup tool. When you select use checklist and place a data lookup in the first column of your table the system will automatically expand the table and place the data from the lookup field into each row.
Example 1: If you have a data source that includes all of your products and prices and you select product as your lookup field, your table will place each product in a row.
Example 2: Build a questionnaire where the questions are part of a user editable data source. The alternative would be to create each question individually and then having to modify the form if you want to add, edit or delete questions.
- Show duplicate values: Show all values from the Data lookup, even if they are duplicates.
Verify duplicates: This setting when turned on will evaluate each answer in a column and display an error message if a duplicate value is entered. If "Allow Duplicate" is selected it will allow the answer in the table but still show a message notifying the user that they entered a duplicate value. If this the allow duplicate setting is off it will clear the answer until a non duplicate is entered. Can be used in combination with barcode scanning and auto jump to the next row. If a user accidentally scans the same barcode twice the system will catch the duplicate and inform the user.
Fit to screen width: doForms will automatically equally space columns based on the default minimum size of your fields. Each tool has a default minimum size and equally spaced columns will use the largest value to set all columns. Another automatic option is to set columns equal to the caption length. Both of these can be problematic and can cause the table to not fit in the screen. It is recommended that you use the adjust column width setting to insure that your table always fits your screen as desired.
Adjust column width: (The Fit to screen checkbox must be selected in order to use this option.) This option allows you to determine exactly what percentage of the screen each column will have. This gives you the ability to give your product description field more space in the table then lets say the quantity field. Your values must always equal 100 and you must have a value for every field including hidden fields. Use a value of 0 for hidden fields. To set the column widths simply create a string like this one. 40|20|20|20. This gives the first column double the width of the other columns. When the form is on a device or in a PDF or printed the columns will automatically adjust to fill the entire available area using these ratios.
Screen size: Some tables can have many columns. You can set the table to use more then the visible screen size. This will force the table to pan. The alternative is the form will wrap column headings and data to fit in the screen. This could make it difficult to use.
If screen is smaller than: If your screen size is set to 100 your form will always try to fit your table on the screen. In some cases a user might open a form on a small device. This option allows the form to automatically pan on smaller devices. This will give the user on a small device a better experience. We recommend always using this option unless you absolutely know how users will access the form.
Text Size: Changes the size of the text for each cell in the table. Medium is the default but the text size can be lowered to small or increased to large.
Shaded Rows: You can configure the table to shade every other row.
- Print Label
- Choose One
- Lookup Data
- Select Multiple