nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Set the custom field value based on custom field date Range

Venkatesh Pettem

Hi Team,

There are two custom fields Start date and Star quarter.

Start Quarter values are Q1 24, Q2 24, Q3 24, Q4 24.

whenever user select a date in Start date and if it falls under first quarter of the year (Consider January to March) then Start quarter field value to be set to Q1 24.

if it falls under second quarter of the year (Consider April to June) then Start quarter field value to be set to Q2 24.

Similarly for July to Sep then Q3 24, Oct to Dec then Q4 24

Please help with Behavior script

Thanks,

Venkatesh

Accepted answers

All comments

Jeroen Poismans

Hi and welcome to the Community!

If you want to make this flexible, try using a lookup table in automation. What the rule will do:

Extract the month form a date field
Lookup the month's corresponding Quarter
Combine the quarter with the date

The rule ( i have used manual trigger and due date field, but you can change to fit your needs):

Screenshot 2024-07-15 at 10.22.44.png

The lookup table in the first action:

Screenshot 2024-07-15 at 10.22.57.png

The extract the quarter and put in a variable together with the year:

Screenshot 2024-07-15 at 10.26.01.png

Several things happening here:

We create a variable quarter
First part is extracting the quarter form your quarters table using the month (M) of the date field.
Second part is extracting the year (YY) from the date and append it to the first part.

Now all you have to do is add an action step, editing the issue and setting the select field with the quarter variable.

Good luck!

Venkatesh Pettem

HI @Jeroen Poismans , I have tried to create lookup table in automation, but the suggested lookup table is not available in Automation. we are using 9.10.1 Jira version. Please help.

Regards,

Venkatesh

Jeroen Poismans

Ok, so I modified the rule so you it should work in your version:]

Screenshot 2024-07-16 at 09.25.59.png

First I create a variable that extracts the month
```
{{issue.duedate.format("M")}}
```
Then I create IF-ELSE blocks using the Advanced compare condition

You can see I use a regex compare there, stating in the first IF that the month variable should be 1,2 or 3
Then I log the value that you want in the select list
```
Q1 {{issue.duedate.format("YY")}}
```
You should change this to the Edit issue action, to edit and set your select list.
Repeat for the other possible ranges, quarters (see screenshot).

Jeroen

Venkatesh Pettem

Hi @Jeroen Poismans , There is no "Create variable" Action in my version 9.10.1.

Please suggest an alternative way.

Thanks

Venkatesh Pettem

Venkatesh Pettem

document.addEventListener("DOMContentLoaded", function() {
const dateInput = document.getElementById('date');
const selectList = document.getElementById('selectList');

dateInput.addEventListener('change', function() {
const selectedDate = new Date(dateInput.value);

// Define your date range conditions
const startDate1 = new Date('2024-07-01');
const endDate1 = new Date('2024-07-10');

const startDate2 = new Date('2024-07-11');
const endDate2 = new Date('2024-07-20');

const startDate3 = new Date('2024-07-21');
const endDate3 = new Date('2024-07-31');

// Example condition: if selected date is within the range
if (selectedDate >= startDate1 && selectedDate <= endDate1) {
selectList.value = "option1"; // Set your desired option value for this range
} else if (selectedDate >= startDate2 && selectedDate <= endDate2) {
selectList.value = "option2"; // Set your desired option value for this range
} else if (selectedDate >= startDate3 && selectedDate <= endDate3) {
selectList.value = "option3"; // Set your desired option value for this range
} else {
selectList.value = "default"; // Default option value if date is outside all ranges
}
});
});

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-data-center

data-center