Hello, I have a problem that I cannot solve. I've been looking around the community and I haven't found a solution. I have 2 fields: * Numeric type: "Number Flag" * Date Type: "Due Date" When a issue is created i need to edit the field "Due Date" adding days: * "Due Date" plusdays ( "Number Flag" * 10) Example: * 05/07/2022 + (2 * 10) = 25/07/2022 Any recommendation? Thanks!!!

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; } } }

Automation: Add multiply a custom field and add it like days to a date field

Facundo Castillo

Hello, I have a problem that I cannot solve. I've been looking around the community and I haven't found a solution.

I have 2 fields:

Numeric type: "Number Flag"
Date Type: "Due Date"

When a issue is created i need to edit the field "Due Date" adding days:

"Due Date" plusdays ( "Number Flag" * 10)

Example:

05/07/2022 + (2 * 10) = 25/07/2022

Any recommendation? Thanks!!!

Accepted answers

John Funk

Hi Facundo - Welcome to the Atlassian Community!

You should be able to do this with an automation rule.

When you update the Number Flag or Due Date field, you will use a syntax like this:

{{#triggerissue.duedate}}func=plusDays({{issue."Number Flag" * 10}}){{/}}

Give that a whirl and let's see what happens - hopefully I have the syntax correct.

unknown

Hi Facundo,

Please try the below syntax in Project Automation

{{issue.dueDate.plusDays(Number Flag.multiply(10))}}

Below is a screenshot of the section. I have used "Feature Ranking" a numeric field in my instance.

All comments

Kian Stack Mumo Systems

Try to follow this documentation on math expressions. Have you already tried any of these?

John Funk

Hi Facundo - Welcome to the Atlassian Community!

You should be able to do this with an automation rule.

When you update the Number Flag or Due Date field, you will use a syntax like this:

{{#triggerissue.duedate}}func=plusDays({{issue."Number Flag" * 10}}){{/}}

Give that a whirl and let's see what happens - hopefully I have the syntax correct.

unknown

Hi Facundo,

Please try the below syntax in Project Automation

{{issue.dueDate.plusDays(Number Flag.multiply(10))}}

Below is a screenshot of the section. I have used "Feature Ranking" a numeric field in my instance.

Facundo Castillo

Thanks for the help, i finish the problem with an hybrid with your answer and Aditya, because * doesnt work in this query.

Result:
{{#issue.Payment Date}}func=plusDays({{Number Flag.multiply(10)}}){{/}}

Facundo Castillo

Thanks for the help, i finish the problem with an hybrid with your answer and John,

Result:
{{#issue.Payment Date}}func=plusDays({{Number Flag.multiply(10)}}){{/}}

John Funk

Great!

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud