Spreadsheet element: date type behaviour
Confluence User - 05 Sep, 2018
Hi team,
I noticed a couple of things in the Spreadsheet element when working with dates.
- The format entered in the Spreadsheet configuration is the way the value is stored in the database
- Instead, I would expect the format to be for visualisation only and the Joget default setting of the date format should be used
- Otherwise, if a datetime needs to be stored, the datetime format needs to be configured in the Spreadsheet and will be shown to the user
- Instead, I would expect the format to be for visualisation only and the Joget default setting of the date format should be used
- When using Multirow Binder all date settings of the date field are ignored (minimum date, range, etc.)
- Would it be possible to improve this to enter the reference to the form id containing the date field which will then apply the date picker settings
- Would it be possible to improve this to enter the reference to the form id containing the date field which will then apply the date picker settings
Cheers,
Eric
spreadsheet;forms;datepicker;date