IU-DATA

DatePicker v1.0.0

1 - Presentation & features

This add-on allows you to select a date in a widget and to easily navigate between months / years / decades / centuries and to retrieve the date in the FileMaker format chosen directly in a FileMaker solution.

Simply made with a web viewer, it is possible to configure the web viewer completely independently with a simple copy and paste. Responsive, the size is determined by the size of the web viewer.

Features :

This add-on uses the JavaScript libraries jQuery, bootstrap-datepicker.js and the style sheet bootstrap.min.css.

2 - Installation / Configuration / Parameters

2.1 Installation

  1. Close FileMaker Pro

  2. Copy the folder IUD_DatePicker_v1_AddOn to the following directory :

     - macOs : ~/Library/Application Support/FileMaker/Extensions/AddonModules/
 - Windows : AppData\Local\FileMaker\Extensions\AddonModules\

  3. In FileMaker Pro, open the solution on which you want to add the Add-On

  4. In layout mode, open the left side panel on the Add-ons tab, click on the button add  

  5. Under the IU-DATA category, select DatePicker then click on Choose  

  6. Drag and drop the DatePicker add-on on the layout where you want to add-it.

2.1 Configuration

The add-on can work without any context thanks by using the global field IUD_DatePicker::gct_WV_FinalCode.

  1. Copy and paste the web viewer containing the add-on calculation formula on the desired model.

  2. Modify the _fieldName parameter in the web viewer calculation, to specify the field that will receive the color code.

  3. Modify the other parameters.

Example of code associated with the web viewer :

Let ( 
[
_fieldName = GetFieldName ( Table1::Field1 ) ;
_language = IUD_DatePicker::language ;
_format = IUD_DatePicker::format ;
_multidate = IUD_DatePicker::multidate ;

_weekStart = IUD_DatePicker::weekStart ;
_calendarWeeks = IUD_DatePicker::calendarWeeks ;
_todayHighlight = IUD_DatePicker::todayHighlight ;

_startView = IUD_DatePicker::startView ;
_minViewMode = IUD_DatePicker::minViewMode ;
_maxViewMode = IUD_DatePicker::maxViewMode ;

_startDate = IUD_DatePicker::startDate ;
_endDate = IUD_DatePicker::endDate ;

_daysOfWeekDisabled = IUD_DatePicker::daysOfWeekDisabled ;
_daysOfWeekHighlighted = IUD_DatePicker::daysOfWeekHighlighted ;
_datesDisabled = IUD_DatePicker::datesDisabled ;

_activeDateColor = IUD_DatePicker::activeDateColor ;
_todayDateColor = IUD_DatePicker::todayDateColor ;
_borderRadius = IUD_DatePicker::borderRadius ;
_background_Color = IUD_DatePicker::background_Color ;


_nbCol = Case ( _calendarWeeks = "true" ; 8 ; 7 ) ; 

_Code = IUD_DatePicker::gct_WV_FinalCode ;

_FinalCode = Substitute (
               _Code ; 

               [ "{{fieldName}}" ; _fieldName ] ;
               [ "{{language}}" ; _language ] ;
               [ "{{format}}" ; _format ] ;
               [ "{{multidate}}" ; _multidate ] ;

               [ "{{weekStart}}" ; _weekStart ] ;
               [ "{{startDate}}" ; _startDate ] ;
               [ "{{endDate}}" ; _endDate ] ;

               [ "{{daysOfWeekDisabled}}" ; _daysOfWeekDisabled ] ;
               [ "{{daysOfWeekHighlighted}}" ; _daysOfWeekHighlighted ] ;
               [ "{{datesDisabled}}" ; _datesDisabled ] ;

               [ "{{calendarWeeks}}" ; _calendarWeeks ] ;
               [ "{{todayHighlight}}" ; _todayHighlight ] ;

               [ "{{startView}}" ; _startView ] ;
               [ "{{minViewMode}}" ; _minViewMode ] ;
               [ "{{maxViewMode}}" ; _maxViewMode ] ;

               [ "{{nb_Col}}" ; _nbCol ];
               [ "{{activeDateColor}}" ; _activeDateColor ];
               [ "{{todayDateColor}}" ; _todayDateColor ];
               [ "{{borderRadius}}" ; _borderRadius ];
               [ "{{background_Color}}" ; _background_Color ]

            )
]
;
"data:text/html;charset=utf-8,¶" & _FinalCode
)

Please note : If your database on which you want to install the add-on is hosted with FileMaker Server. You might need to refresh the globale calculation field IUD_DatePicker::gct_WV_FinalCode. Otherwise the webviewer that contains the add-on will remain empty. To refresh this field, you can set the field IUD_DatePicker::WV_HTML by it's own value inside a script that is launch at the start of your application.

2.2 Parameters

Editable parameter values :

⚠️   if you modify the names of the parameters, you will have to report your modifications to _finalCode if necessary

⚠️   Parameters not to be modified :

3 - Tables / Scripts / Custom functions / Value lists

3.1 - Tables

3.2 - Scripts

3.3 - Custom functions

No Custom Functions in this add-on.

3.4 - Value lists

jQuery v3.5.1 ( Licence MIT )

https://code.jquery.com/jquery-3.5.1.slim.min.js

Bootstrap DatePicker v1.9.1 ( Licence MIT )

https://bootstrap-datepicker.readthedocs.io/en/latest/

Bootstrap v3.2.0 ( Licence MIT )

https://getbootstrap.com

5 - Compatibilities

Operating systems :

Plateforms :

Please note that on FileMaker Go 19 the DatePicker activation inside the web viewer require a double tap.

6 - End User Licence Agreement

Important Note: Please read this EULA carefully. Downloading, installing, using or modifying this add-on signifies that the end user and their organization accept this EULA.

Definitions :

Contract terms :
IU-DATA authorizes the end user and his organization or household to use, modify, copy the add-on at their convenience. IU-DATA authorizes the end user and his organization to use for commercial purposes the add-on, when the add-on is an integral part of a solution whose spectrum of use is much wider than that defined by the functionalities of the add-on alone. On the other hand, IU-DATA does not authorize the end user and his organization to use for commercial or distribution purposes the add-on, modified or not as a final product.

The end user and his organization / household have free assistance for a period of 2 months from the date of purchase of this add-on, for any questions related to the use and configuration of this add-on.
Full access to FileMaker sources as well as to the source code used in the web viewer gives to the end user and his organization / household full control over modifying this add-on. It is therefore natural that we cannot intervene free of charge on the add-on whose code has been altered compared to the original version that IU-DATA delivered. Likewise, IU-DATA cannot be held responsible for any malfunction of any libraries mentioned in paragraph 4 - Dependencies, as well as malfunctions of the add-on following use on an operating system or a FileMaker platform other than those mentioned in paragraph 5 - Compatibilities.

Contact :
For any questions, please contact us to this address: product@iu-data.com

7 - Realization

Creation and development :

Icon design :

8 - Change Log

16/02/2021 - DatePicker v1.0.0 - 1st release


© IU-DATA 2021