Trying to get a value from a comment and assign it to a custom field

Rosana Casilli

Hi All!

 

I need to write an automation rule where after adding a comment, if this comment has the value "Valor bruto:" or "Valor inicial:" or "Valor:", the value after the ":" is added to the customfield "Valor inicial".

can you please help me with this?

 

Thanks in advance,

Ro

Deivid Araujo

Hi Rosana!

For that exact scenario, you will have to use regex to capture the string, but be aware that this approach may lead to various problems. including:

 

• Unexpected matches (false positives): regex may capture unintended text.

• Inconsistent formatting: extra spaces, line breaks, different ways of writing “Valor” or the number.

• Multiple occurrences: regex may only grab the first or wrong match if more than one appears.

• Localization issues: decimal/thousand separators (1.200,50 vs 1200.50).

• Automation regex limitations: not all regex features (like lookbehinds) are supported.

• Field type mismatch: target number fields may reject values like R$ 1.200,50.

• Complexity/maintenance: regex rules can become too hard to read or adjust later.

 

That said, here's an article showing how to extract text using regex:

https://support.atlassian.com/jira/kb/extract-content-out-of-description-and-summary-with-regex-and-automation/

 

A regex tester:

https://regexr.com/39jba

 

As for the regex itself. it will depend on yout text patter (if any), so your best bet is to use any LLM to generate the regex string