Value results, syntax help

Good day all I am trying to return a value like this: ‘V041%’
I can get a return like this : V041% from this:

How can I add the quote so it will return ‘V041%’ ?


"'V0" + {this.custom.twnum} + "%'"

1 Like

“Slaps forehead!”

Yep, lol.

I would use a format transform to do this; it’s a little convoluted to set up but:

''V000'%''' is the actual pattern - two '' to escape the initial single quote, the pattern is three 0s to always pad to the appropriate length, then ' around the % to make it literal, then a trailing double-single-quote (:upside_down_face:) to add the last literal.