Example: Increment a field or set to 1 if it's not set
I want to increment a number field, but the issue I have with the function Mathematical and date-time expression calculator in that when the field has a number it increments correctly, but for the very first increment the Number field is empty, so the function requests that it be initialised and fails.
I then tried the Copy a parsed text to a field to see if this expression would work: %{11002} = Null ? 1 : (sum({11002},1))
You should use Mathematical and date-time expression calculator with the following expression:
{11002} = null ? 1 : {11002} + 1
Just for fun, this is an alternative expression:
{11002} = null ? 1 : sum(toNumberList(%{11002} + ", 1", ","))
Another alternative expression
sum([{11002}]) + 1
Other examples of that function
- Automatic work log with start and stop work transitions
- Automatically log work time when the user uses a "Stop Progress" transition
- Calculate the time elapsed between 2 transition executions
- Getting the number of selected values in a custom field of type Multi Select
- Implement a form with a series of questions and calculate a numeric value based on the answers
- Increment a field or set to 1 if it's not set
- Set "Date-Time Picker" custom field with current date-time
- Set "Due date" 6 natural days (or work days) earlier than a "Date Picker" custom field
- Set "Due date" to a specific day of next week no matter of date of creation this week
- Set "Due date" with certain time offset from current date
- Set "Total time spent" to "Current date and time - date and time of last update"
- Set a custom field "Urgency" depending on a combined value of issue's priority and "Impact" custom field
- Sum "Time Spent" in all sub-tasks of issues linked with issue link types "LinkA", "LinkB", "LinkC"
- Triage Jira Service Desk email requests (Move issues)
- Using project properties to calculate custom sequence numbers
