Hi All,
What I would like to do:
- use jira automation to extract a value out of text
- use that value to populate another smart field specifically next business date to auto set a due date through.
Workflow:
- send an email to jira - working
- use AID# as the subject the # = to a numerical value 1-9 - working
- {{issue.summary.charAt(3)}} = 1-9 - working
- {{now.plusBusinessDays({{issue.summary.charAt(3)}})}} to set the due date value- NOT working
does this have to be converted to a numerical value (if so how?)
Question:
how can I take the numerical value
Hello @Gavin
When you extract a portion of a string you are extracting "text", even if the text itself is actually a number.
I think you need to convert the extracted text to a number.
Additionally you don't need the curly braces within the parentheses.
{{now.plusBusinessDays(issue.summary.charAt(3).asNumber)}}
A debugging tip for Automation Rules is to use the Log action to write information into the rule Audit Log. You can use it to write out any smart value or calculation to see what value is actually being used by the Automation Rule.
Hi @Gavin
Have you tried {{now.plusBusinessDays({{issue.summary.charAt(3).toDate}})}} ?
You might need to change it into a date before adding 3 days, but I think that's the issue. You are trying to add days to a string and not a date
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.