How to add a column to a form

#EN #Excel #Keyword #Validation #Form

Updated over a week ago

In order to create a column (or grid) control, you need to use the 123 method:

Row 1: The field's title

In this row, you can put any title for your field.

Row 2: Keyword

In this row, you will use any keyword from our list in order to decide how the column should be defined.
The available keywords are:

Row 3: Validation Rules

In this row, you will use any validation rule from our list in order to define what might be triggered by the entry.
The available validation rules are:

Different Types of Tables

Static Table

A static table is defined by the information that is already in one or more of its rows.
This will be a grid where the rows are already defined and none will be added during production.
By merging cells on the same row for the amount of columns you have, you will be able to get a row group in your static grid.

Dynamic Table

A dynamic table is defined by an empty row (or "ghost row") right under the column's headers.
This will be a table where you will be able to add rows whenever you need to.
By pressing on the "ghost row", you will be adding an extra row every time and the "ghost row" will move under the newly created row.
You can delete a row by selecting it and taping on the "-" icon next to it.

Additional Information

  • In order for a table to appear, you need to have a minimum of two (2) columns;

  • There cannot be two tables next to each other. They need to be one after the other;

  • A form can contain up to 24 tables;

  • A table can contain a large number of columns;

  • If a column does not appear, check the spelling for the keywords and/or validation rules;

  • Any formatting will not change anything to the form itself.Paperless possess a standard formatting that cannot be changed.However, we suggest you add formatting to your Excel to help you read through it more easily and to customize everything to your liking.

Did this answer your question?