Page History
Section | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Example: Setting Calculated Text Field depending on custom fields
In this example the value of a calculated text field get's set by evaluating 2 other 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 should be set on 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 field code for custom date picker "Date closed" (your code might be different)
- {10424} is field code for custom date picker "Expected Due Date" (your code might be different)
Other examples of that function
Incoming Links | ||||
---|---|---|---|---|
| ||||
Related Usage Examples
Content by Label | ||||
---|---|---|---|---|
|