Skip to main content
Question

'ToText' equivalent in Jinja


Forum|alt.badge.img+20
I have a multiple choice field with the options '1,2,3,4'. Since Multiple choice is seen as text, for QB, these aren't actually numbers.

I have a numerical field, [NumberField].

In a pipeline I want to set [Multiple Choice] to [NumberField]. I am trying to set a text multiple choice to a number, and QB doesn't like that. My solution for now is just to create a formula text field with my calculation, ToText the result and use that formula field.

Is there a shortcut to do this all in pipelines? I know below isn't right, but it paints the picture of what I want.

Set [Multiple Choice] to: ToText{{a.NumberField}}

------------------------------
Mike Tamoush
------------------------------

Forum|alt.badge.img+11
Can you try

{{a.NumberField|string}}

------------------------------
Prashant Maheshwari
------------------------------