Example: Set a date based on current date
In this example a date will be set based on the value of a select list custom field and the current date.
Based on a single select with the options "monthly" and "quarterly" another custom date field "Time limit" should be set.
Case 1: Selecting "monthly"
- "Time limit" will be set to the last day of the next month.
Case 2: Selecting "quarterly"
- "Time limit" will be set to the last day of the quarter, e.g.
Creating an issue on 22/Feb, "Time limit" will be updated to 31/Mar.
Note: For this example, two custom fields are needed:
- Select list (single choice) "Frequency" with two options: monthly and quarterly
- Date picker "Time limit"
This can be done using the Set a field as a function of other fields post function.
Text to be parsed is:
(Monthly)lastDayOfTheMonth(addMonths({00057}, 1, LOCAL), LOCAL)[month({00057}, LOCAL) in [{JANUARY}, {FEBRUARY}, {MARCH}]]dateTime(year({00057}, LOCAL), 3, 31, 0, 0, LOCAL)[month({00057}, LOCAL) in [{APRIL}, {MAY}, {JUNE}]]dateTime(year({00057}, LOCAL), 6, 30, 0, 0, LOCAL)[month({00057}, LOCAL) in [{JULY}, {AUGUST}, {SEPTEMBER}]]dateTime(year({00057}, LOCAL), 9, 30, 0, 0, LOCAL)[month({00057}, LOCAL) in [{OCTOBER}, {NOVEMBER}, {DECEMBER}]]dateTime(year({00057}, LOCAL), 12, 31, 0, 0, LOCAL)
Note that:
- {00057} is field code for field "Current date and time"
Once configured, the transition will look like this:
Other examples of that function
- Add watcher depending on security level
- Add watchers based on issue type
- Add watchers depending on the value of a custom field
- Assign issue based on the value of a Cascading Select custom field
- Assign issue to a specific user based on a specific custom field value
- Assign issue to current user if assignee is empty
- Assign issue to current user if the user is not member of a certain project role
- Change assignee based on a custom field
- Change parent's status depending on sub-task's summary
- Changing issue priority depending on issue description
- Compose dynamic text by inserting field values in a text template
- Copy "Due date" into a date type custom field in a linked issue if it's greater than current issue's "Due date"
- Limit the number of hours a user can log per day
- Make parent issue progress through its workflow
- Rise priority if due date is less than 3 weeks away
- Set "Due date" depending on the value of other fields, in case it's uninitialized
- Set "Due date" to a specific day of next week no matter of date of creation this week
- Set "Due date" to current date at issue creation if not initialized
- Set a custom field "Urgency" depending on a combined value of issue's priority and "Impact" custom field
- Set a date based on current date
- Set a field based on reporter's email
- Set a watcher at ticket creation depending on custom field's value
- Set assignee depending on issue type
- Set security level based on groups and project roles the reporter or creator are in
- Set security level depending on reporter or creator
- Set the assignee based on a condition
- Set the value of a field of type "User Picker" depending on other field's value
- Set watchers depending on the value of a custom field
- Setting a custom field (User Picker) based on the value of another custom field (Text Field)
- Setting a field's default value depending on another field
- Setting the priority depending on the multiplication of custom fields
- Transition an issue automatically depending on the value of a field
- Unassign an issue when assigned to project leader
- Update checkboxes custom field if a file has been attached during a transition
- Using project properties to calculate custom sequence numbers
