How can I populate my custom fields using substringBetween?

Garrison Thomson

I created two custom fields (Category and Practice) that I need to be populated with values from an email request (from the Description field). Everything I've read elsewhere suggests that using the substringBetween function will do this but I can't get it to work for some reason.

Automation rules:

• Trigger: manual (for testing, then I'll change it to when Issue Created)
• Action: Edit Issue
  • Choose fields to set
    • Category: {{issue.description.substringBetween(“:”,”.”)}}
    • Practice:{{issue.description.substringBetween(“-”,”’”)}}

My test Email request/Description contains:

Category:Data Question.
Practice-OSLC Practice'

 

I manually triggered the automation on my request but the custom fields Category and Practice do not populate. Is it obvious what I'm doing wrong?

Thanks for any help!

 

Callum Carlile _Automation Consultants_

Hi @Garrison Thomson , welcome to the community!

This looks like it should work - I've given it a go myself and have been able to successfully set the fields using the smart value:

I copied and pasted both mine and your smart values into notepad to see if there were any small differences, and I did notice one:

For some reason, your speech marks and apostrophes are slightly slanted (no idea if this is just a strange formatting issue between devices/keyboards/languages) but this may be what's causing the problem - I tried copying and pasting yours into my automation rule and it did not work.

Just as a test - try copying and pasting this exact text and see if it works for you

{{issue.description.substringBetween(":",".")}}

{{issue.description.substringBetween("-","'")}}

I'm intruiged to see how you get on with this, hope this helps!