Adding a Number Field
This Document provides step-by-step instructions on how to add a number field to your worksheet. Follow the steps carefully to ensure successful implementation.
Step 1
In this document, I will guide you on how to add the number datatype field. First, click on the plus icon to add the field.
Step 2
Once the pop-up opens, select "Number" from the type drop-down menu. Provide the field name according to your preference.
Step 3
Set the data type to number. If you want to keep it as an integer, choose "Integer." If you prefer a decimal, select the appropriate option. For now, I am selecting "Decimal." When you choose "Decimal," an additional field will appear, allowing you to specify the number of digits after the decimal point. You can adjust this setting in the "Decimal Pointer" field.
Step 4
Specify the number of digits after the decimal by selecting from the dropdown menu. For example, I am choosing the second option to display two digits after the decimal.
Step 5
You can also set the default value as well as place holder for this field. If you want to make this field mandatory, enable the required option. For bulk updating rows, enable the corresponding option. Once you have filled in all the details, click on "Save."
Step 6
The number type field will be added to your existing worksheet. To test it, click on the plus button. Enter the name and provide the number value as desired.
Step 7
Remember that we set the two digits after decimal while adding the field. This setting allows you to add only two digits after the decimal point once you have entered all the details, click on the "Save" button.
Step 8
Your changes will be reflected in the worksheet. To change a decimal type to an integer for a 'Number' field, click on the dropdown menu and select the "Edit" option. A pop-up will open; in the "Number Type" field, change it from 'Decimal' to 'Integer.' After making the changes, click "Update."
Step 9
To verify, click on "Add." Enter the name and number field accordingly and click "Save."
