Date picker

Date picker controls are designed to capture dates with an intuitive user-friendly interface.

Data type: date

Adding a Date picker control

1. Edit your sheet 2. Click on the Qommentary Writeback extension 3. Expand Input Column section 4. Click on Add column

5. Select Date picker from the dropdown menu

6. Add a label to be displayed as a column header

7. Add a field name

If database is selected as data connection, then field name must map to destination table column name.

Field name cannot contain spaces.

8. Click on Done

Date picker input column can now be updated and saved.

Setting a custom date format

If you wish to change the format used to display dates on your table, please follow these steps:

1. Edit your sheet 2. Click on the Qommentary Writeback extension 3. Expand the Input Columns section and Date picker column 4. Click on Date Format text field and update the format. An expression may be used if desired.

Example of date formats: