Adding a Date Field

This guide provides a comprehensive step-by-step process to help you add and configure a date field in your worksheet. Follow each step carefully to ensure proper implementation and customization.

Step 1

To add a date field to the existing worksheet, click on the plus icon to begin the process.

Step 2

After clicking the plus icon, a pop-up will appear. From the type drop-down menu, Select "Date" as we are adding a date format.

Step 3

Set the field name according to your preference.

Step 4

Choose your desired date format option from the date format drop-down menu. If you want to include the time format, enable the corresponding option.

Step 5

You can set a default value and placeholder for the field. If you want to make the field mandatory, enable the 'Required' option. To allow bulk updates of the rows, enable the corresponding option. After filling in the necessary details, click 'Save'.

Step 6

The added field will now appear in the existing worksheet. To test it, click 'Add' and fill in the necessary details.

Step 7

When you click on the date field, a pop-up will appear, allowing you to select the date.

Step 8

Once you select the date, it will be displayed in the format specified when the field was added. After entering the necessary details, click 'Save'.

Step 9

The added details will be visible in their respective fields. To modify the field settings, click on the drop-down menu for that field.

Step 10

Click on 'Edit' to modify the field settings, and enable the 'Include the format' option.

Step 11

Fill the 'Hour Type' field as it is mandatory once after enabling the 'Include the format' and choose between the 12-hour or 24-hour format according to your needs.

Step 12

Select the options from the drop-down menu. Once you have made your selections, click on Update.

Step 13

So changes gets reflected to existing worksheet details/rows also. And to verify the time format, which we set, simply click on 'Add'.

Step 14

Fill in the necessary details and click on the date field. Select the desired date from the calendar. You can now clearly see the selected date. After enabling the Include Time Format option, you can also set the time. Once all details are entered, click on OK.

Step 15

Finally, click on Save to store all the entered details. You will now see the time format included for all the rows. You can clearly see the applied changes.