Qommentary
Qommentary Writeback
Qommentary Writeback
  • Welcome
  • Getting started
  • Setting up a connection
  • Defining a primary key
  • Adding data to your table
  • WORKING WITH INPUT DATA
    • Adding input columns
      • Text
      • Number
      • Checkbox
      • Dropdown
      • Rating
      • Color picker
      • Date picker
      • Switch
    • Conditional input control
    • Saving and reverting
  • Writeback Actions
    • Refreshing data
    • Clearing data
    • Reloading data
    • Exporting data
  • Bulk updates
    • Single Column
    • Advance Bulk
  • CUSTOMIZATION
    • Table settings
    • Themes
  • Share
    • Sharing data with your team
    • Customizing email template
  • Advanced
    • Audit Trails
      • File audit trailing
      • Database audit trailing
        • SQL Server example
    • Concurrency
  • Support
    • Submit a ticket
Powered by GitBook
On this page
  • Adding a Date picker control
  • Setting a custom date format

Was this helpful?

  1. WORKING WITH INPUT DATA
  2. Adding input columns

Date picker

PreviousColor pickerNextSwitch

Last updated 4 years ago

Was this helpful?

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: