Columns are fields that structure your table and allow you to enter the relevant information for your activity.
Each column allows you to create a special field that determines the type of information you can enter, such as text, a date, a URL, a formula, attachments, etc.
By selecting the right types of fields, you can create a base adapted to your unique needs!
Create a New Column
1. Click on the column option
2. Insert to the right or left of the initial column
4️⃣ 3. Choose the type of column and name it
5️⃣ 4. Configure the column options
Each type of column has a specific configuration related to its type. However, some common options are available for all column types, such as advanced options.
6️⃣ Advanced Options
Label
Enter text to replace the title of the column.
ℹ️ This option is available for all types of columns and applies to both external or blank forms and the detailed view.
Description
By entering a description here, your teams will benefit from a tooltip on the table and in the detailed view, explaining the need, input method, or any other beneficial information for correctly entering the data.
Required*
Data loss is a risk for any company. This option allows you to force data entry by preventing the detailed view from being saved unless the field is completed.
Group By
Structure and organize your data according to a workflow. Group your data under the same group to make it easier to read and enter data in the detailed view.
Sync Code
Need to automate certain tasks? Use this option if you want to use Excel automation by entering the sync codes for input or output.
Field Code
Once your column is created, this field will take the first given title as its code and will no longer be editable. It will be your main ally when building templates for your autodocs.
A field code is unique in a table. If you have two columns with the same title during creation, don't worry, an automatic numbering system will ensure the field code is unique.
Part of the Unique Key*
Sometimes it can be useful to block the generation of duplicates. By checking this box, it will be impossible to create another record with an identical value in this column.
Regular Expression
Use a regular expression to validate the format of a field.
Default Value
You can set a default value so that when a new row is created, your TimeTonic ID or the workspace code is automatically entered into the field.
This is very useful for filtering the rows you have created.
Options
Formatting
You can choose the text line formatting:
- No Formatting
- ALL UPPERCASE
- Capitalize Each Word
Enable Scanning
You can enable barcode reading, allowing a smartphone to scan and automatically enter a value into the field.
Numeric Keyboard
You can force the numeric keypad to appear on mobile devices, allowing number-only entry.