General Field Settings
This guide will walk you through the process of adding a field to your worksheet. We will cover everything from initiating the field addition to setting mandatory fields and placeholders. Follow these steps to ensure a smooth and efficient workflow.
Add Field
Whenever you create a schema, a default worksheet and a default field will be automatically created. You can ignore these for now. To add a new field, click the plus icon.
Add New Field
After clicking the plus icon, a pop-up will appear, allowing you to add a new field.
Select Data Type
Select the data type for your new field. For now, I am choosing the text type to add a field.
Field Name
The field is mandatory, so enter the name of the field according to your preference.
Default & Placeholder
You can also add a default value and a placeholder for the field. For example, set the Default Value to "Table Sprint" and the Placeholder to "TS.
Required & Bulk
If you want the field to be mandatory, enable the "Required" option. Additionally, enabling the bulk option allows you to update rows in bulk. A more detailed video on bulk updates will be covered in another tutorial.
Save Field
After filling out all the necessary information, click "Save" to create the field in the existing worksheet.
Add fields
To test how the added field works, click "Add." In the pop-up, try entering data and observe that the placeholder text you specified earlier is reflected in the field.
Save Values
After filling in the fields, click "Save." You will see that the entered values are now reflected in the fields.
Default Value
To demonstrate the default value functionality, add another row and leave the field empty. Then click "Save." The default value you set earlier will be automatically reflected in the worksheet.
Edit Field
If you want to edit the field click on "Edit" to modify the settings.
Modify Defaults
You can also change the default value and placeholder fields. If needed, remove the currently set values or update them as desired.
Require Field
To make the field mandatory, enable the respective option and click "Update."
Confirm Update
Confirm your changes by clicking "Update".
Verify Changes
To verify the changes, click "Add" again. A star icon will indicate that the field is mandatory. The row will not save unless the required field is filled in.
Required Warning
If you attempt to save without filling in the required field, a message will appear indicating that the field is mandatory. This message will be displayed directly on the field for which you enabled the "Required" option.
Save Entries
Enter the required information into the field, click "Save." Your entered values will now be reflected in the worksheet.