Scriptable Popup Calendar / Date Picker

Document created by Malcolm on Feb 11, 2018Last modified by Malcolm on Feb 12, 2018
Version 3Show Document
  • View in full screen mode

Calendars or date pickers are commonly required to assist user data entry.


There are a lot of calendars available already, so why add another one? Because many of the calendars are more complex than they need to be and that means that they are difficult to use. This calendar is designed to have minimal requirements, be responsive, stable and very easy to integrate.




Example Usage

Perform Script [ “Cal Select” ]
# Calendar is displayed in a new window.

# The user clicks on the calendar and the selected date is now available for use.

# Clicking on a calendar day will place the date into the global field gSelectedDay so the value can be retrieved from any context.

Set Variable [ $selectedDate; Value:Calendar::gSelectedDay ]




Why Use this Calendar instead of the built in pop-up calendar?

The built in calendar pop-up is designed to do exactly the same job as this calendar. It's built-in and always available, so it's a great first choice for date inputs. Even so, there are still good reasons to use a custom built date-picker.


Ease of Use and Accuracy for Users

The larger calendar size increases accuracy for all users. As it is presented this calendar is fairly compact but it is still much larger than the built in calendar. If a different size is wanted it only takes moments to resize the fields.


Customisable Interface

The calendar can be themed to match your solution.

Use conditional formatting to control the display of days. Data sources can be linked via relationships. Colour coding days which have events makes the calendar visually interactive.

TIP: select all six fields and modify conditional formatting for all at the same time



The basic usage is a date picker, returning a date via gSelectedDay. This simplicity is also its power. You can call the calendar from anywhere and immediately start using the selected date for date entry, searches, reporting, etc.


Internationalisation / Localisation

The file uses a value list that contains stored month names. You can simply overwrite the month names. You can also convert the file so that the value lists are in your language. Do this by cloning the file. On opening the clone you can choose to use your current system settings. As it opens, the file will initialise itself, creating new records for months and the month names will use the language settings for your system.


Malcolm Fitzgerald

3 people found this helpful