Page History
Section | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Example:
Setting Calculated Text Field depending on custom fieldsShow timeliness of an issue based on two date pickers
In this example, the value timeliness of an issue is displayed using a calculated text field get's set by evaluating 2 other that is set based on two additional date picker custom fields.For this example the following custom fields are needed:
- Date Picker custom field "Date closed"
- Date Picker custom field "Expected Due Date"
The Calculated Text Field The display value should be set on with the following conditions:
- if (Date closed = null && Current Day <= Expected Due Date) { "" }
- if (Date closed <= Expected Due Date) { "Yes" }
- if (Date closed > Expected Due Date || (Date closed = null && Current Day > Expected Due Date)) { "No" }
The configuration will look like this:
Text to be parsed is: {10423} != null ? ({10423} <= {10424} ? "Yes" : "No") : (datePart({000057}, LOCAL) > {10424} ? "No" : null)
Note that:
- {10423} is the field code for custom date picker "Date closed" (your this field code might be differentdiffer on your instance)
- {10424} is the field code for custom date picker "Expected Due Date" (your this field code might be differentdiffer on your instance)
Other examples of that function
Incoming Links | ||||
---|---|---|---|---|
| ||||
Related Usage Examples
Content by Label | ||||
---|---|---|---|---|
|