Date Picker control

A date time control to capture dates

A Date Picker control is used to accept dates into a microapp by selecting a date from a calendar widget. You can set User Device’s date as a default date or can keep the Date picker empty when the date control is displayed to the user. Date picker saves the Date in the Unix epoch time format. For example, it can be used for various purposes like setting due dates for tasks or Start and End dates for an event.

date picker control

Properties

UI Properties

  • Label : Label is the text that is displayed above the Date Picker and helps the user to understand what they are supposed to do with the date picker.

  • Properties : These properties help you customize the Label by changing the text size, weight ( Light, Normal, Bold, Extra Bold, X Extra Bold), alignment (Left, Center, Right, Justified) and color of the label.

  • Type : The Type field is automatically generated depending upon the type of control used. In this case, it is a “datepicker” type.

  • Unique Name : A Unique Name is used to uniquely identify a control in your App. Every control that is added on the screen gets an auto-generated Unique Name based on the Label name given to the control.

  • Tooltip: This allows you to add the Tooltip text that would provide a hint to the user for providing input. The Tooltip icon would be visible if you switch on the Show tooltip icon toggle property available below.

  • Description: Is the description that you can add for your controls. The Description would only be visible if you switch on the Show Description toggle property available below.

  • External CSS: With this property, one can imply exclusive CSS on controls. You can customize your control with CSS by selecting the correct class or id of the control. You can read more here.

  • Submit Data : This field lets you determine whether to send the value of the control or not in the Workflow based on various control states. There are three conditions that could be set for this field.

    1. Always : If this condition is selected, the data in the Date Picker will be submitted irrespective of the state of the Date Picker.

    2. Never : If this condition is selected, the data in the Date Picker will never be submitted irrespective of the state of the Date Picker.

    3. No When Hidden : If this condition is selected, the data in the Date Picker will be submitted if the Date Picker is visible and not submitted when the Date Picker is hidden .

  • Required : When you select the required option, the field becomes a mandatory field and the user can not submit the form without updating the field.

  • Read Only : If you select this option, the user will no longer be able to edit the field.

  • Hidden : The hidden option helps you to hide the field from the user. This might help to perform the actions that you do not want the user to see. It can also be show certain fields only when a specific condition is met/not met.

  • Caching : When the caching option is selected and if a LOOKUP formula is applied to this control, the value that the LOOKUP returns will be cached and the user will be able to see this value in the Date Picker even when he accesses the microapp later with no connectivity. This option is required when you want your app to be accessible in offline mode as well and getting the latest data from the sheets always is not critical.

  • Hide Label : This option hides the label of the Date Picker from the view.

  • Trigger dependents: When you Disable Trigger Dependents, it helps you to reduce or optimize the unnecessary evaluation of the dependent control’s formula. For a detailed explanation refer to this article here ..By default Trigger dependents is enabled. However, in complex apps by switching it off, you would limit the evaluation in the dependent control and in turn ensure quicker response times.

  • Hide on desktop: This option hides the selected control in the desktop view.

  • Hide on Mobile : This option hides the selected control in the mobile view.

  • Dynamic Height : This option dynamically increases /decreases the height of the text control based on the given content.

  • Maintain space when hidden : This option maintains the specified space between controls when a particular control is hidden. When a control is hidden the space is maintained in the preceeding control depending on the space the previous control has occupied.

Note: Dynamic height, Hide on Mobile, Hide on Desktop, Maintain space when hidden properties are used in Freeflow Editor only.

Properties

date_properties

  • Clear Option : This option when it is enabled allows you to clear the date and set the date.

  • Theme : This lets you choose the color of the Container box. You can either enter a custom hex code value or use one from the available themes in the builder.

  • Datepicker Theme : This lets you set the color of the Datepicker widget.

  • Date Format: You can the date format as UTC or Local time.

  • Display format: This lets you choose the format you want the date to be selected in. There are 3 formats available:

    1. Friendly format - Month DD YYYY
    2. European format - DD/MM/YYYY
    3. US format - MM/DD/YYYY

Disable Dates

  • Future Dates:

    • Disable All: On toggle OFF all the future dates will not be disabled. On toggle ON, all
      the future days will be disabled to select from.

    • Disable days: (Visible when Disable All toggle is OFF) Select the number of days you want to disable in the future from the day after.
      selected

    • Enable days: (Visible when Disable All toggle is ON) Select the number of days you want to enable to select from in the future, from the day after.

      selected

  • Past Dates:

    • Disable All: On toggle OFF all the past dates will not be disabled. On toggle ON, all the past days will be disabled to select from.

    • Disable days: (Visible when Disable All toggle is OFF) Select the number of days in past you want to disable from the day before.

      image

    • Enable days: (Visible when Disable All toggle is ON) Select the number of days you want to enable to select from, in the past from the day before.

      selected

  • Including Disabled Week Days: Toggle switch ON to include the disabled week days.

  • Including Today: On toggle ON, all the date functionalities to enable and disable dates will include the present date, on the count of dates.

How to Use a Date Picker?

Start with selecting the Date Picker from the Date & Time section of the Controls Menu.

The Date Picker will then appear on the screen in the builder, you can then set all the above properties as per your requirements.

You can use the Data option to bind data to the Date Picker.

There are different ways in which you can bind data to the Date Picker.

Bind Data

  1. Static Data: This is the data that does not change over the period of time. Such data is used to assign default values in fields in your application. The static data can be based on the data type i.e. Numeric, Text, and List type data.

  2. Sheets : This allows you to fetch data from a sheet and display it in the fields. Select your sheet from the list and then select the columns to be used. You can also add filters and sort data.

  3. Controls: This allows you to get data from one of the App controls.

  4. Variables: This assigns the value of the variables defined in the app.

  5. LoggedIn User: You can display the properties related to the LoggedIn User like username, usermail, Admin, status, and so on. You can select a single property only . Select column and click Save .

  6. API: This allows you to add an API and select the values returned by the respective API. You can select multiple keys to display values.

  7. Custom Formula: This can be used to apply formulas and store the output of those formulas. You can learn more about formulas here.

Preview

Date picker with today’s date

image

Calendar widget to select date