...
Time Ago Formatter calculates the duration between two input dates from (the same List) with different methods to be chosen from.
Plugin Information
Plugins Available in the Bundle:
Time Ago Datalist Formatter
This plugin bundle is compatible with Joget DX 7 and onwards.
Expected Outcome
The user is able to calculate duration between two dates in the same list.
Figure 1: Time Ago Datalist Formatter in List
Get Started
Steps
1. You can get the plugin jar file from Joget Marketplace.
2. Upload the plugin jar file in Joget by going to Settings → Manage Plugins.
3. You can choose to import the demo app or create the app from scratch.
Steps for importing demo app
1. Download the demo app from Download Demo App.
2. Go to Joget Home or All Apps and click on Import App to import the downloaded demo app.
Steps for creating app from scratch
1. Create a form with a Date Picker field.
Figure 2: Create Form with Date Picker
2. Go to right up corner, click on Generate App > Generate CRUD
Figure 3: Generate CRUD for form
3. Now go to the datalist. Play around with the plugin by duplicating the column and applying the Time Ago Datalist Formatter. For plugin configuration details, please refer to Time Ago Formatter Properties.
Figure 4: Modify list and apply Time Ago Datalist Formatter
4. Publish and run the UI. You can see the difference of the dates that you configured.
Figure 5: Time Ago Datalist Formatter in UI List
5. (Optional) Specify the Date Format configuration "yyyy/MM/dd" to be able to pick up the manual date format when processing.
Figure 6: Time Ago Datalist Formatter in List (Date Format config)
6. Now the plugin is able to pick up manual dtae format and process the value.
Figure 7: Date Format config processing
Time Ago Formatter Properties
Configure Time Ago Formatter
...
Figure 8: Time Ago Datalist Formatter Configuration
| Name | Description |
|---|---|
| Duration | Different methods of taking in two dates. Available options:
|
| Target Date | A different column date taken in as one of the input dates to be compared with the existing Column Date. Only appears when Duration is selected as the From Column Date to Another Date option.
Figure 9: Time Ago Datalist Formatter (From Column Date to Another Date) |
| From Date | A different column date taken in as one of the input dates to be compared with To Date. Only appears when Duration is selected as the Between Two Dates option.
Figure 10: Time Ago Datalist Formatter (Between Two Dates) |
| To Date | A different column date taken in as one of the input dates to be compared with From Date. Only appears when Duration is selected as the Between Two Dates option.
|
| Date Output Format | Multi select box for date output formats for specific units. Available options:
|
| Include Format in Output | Checkbox field to determine whether to include format when date output format is chosen. |
| Extra Date Time Format Processing | Heading. For this section, date time default formats will be applied automatically, only specify if there are any extra formats. Formats should be separated by comma, e.g: yyyy-MM-dd, dd-MM-yyyy |
| Date Time Format | Default format: "yyyy-MM-dd hh:mm a", "yyyy-MM-dd HH:mm", "yyyy-MM-dd HH:mma", "yyyy-MM-dd'T'HH:mm:ss.SSSSSS", "yyyy-MM-dd'T'HH:mm:ss", "dd-MM-yyyy hh:mm a", "dd-MM-yyyy hh:mma", "dd-MM-yyyy HH:mma", "dd-MM-yyyy HH:mm" |
| Date Format | Default format: "yyyy-MM-dd", "MMMMMMMMM dd, yyyy", "dd-MM-yyyy" |
| Time Format | Default format: "hh:mm a", "hh:mma", "h:mm a", "h:mma" |
