In Fusion 2.0, how do I convert a number to text?

[skyehansen]

is it the same as it is for a calculation in workfront? (https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FRe... ) -- as in, can you do anything with this? I checked the functions in fusion and couldn't find anything there. You might submit a ticket and see if that was an oversight on workfront's part.

[JohnGr3]

If if is, it's not obvious. I tried (string({{3.NewItemID}}) but that didn't use it as a function, it just set the variable to the literal "string({{3.NewItemID}})"

[skyehansen]

you might submit a ticket then. Seems weird that they would have a formatNumber but no formatString function.

[skyehansen · Accepted solution]

John, I found it! https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FWo...

(it's toString)

[JohnGr3]

WooHoo! That worked!!!!!

Thanks, Skye 😀

[Doug_Den_Hoed__AtAppStore]

Hi John,

Untested, but one common approach is to "coerce" the data type by concatenating it with an empty string (e.g. CONCAT(myNumber,""))

Regards,

Doug

[JohnGr3]

Thanks, Doug. That was going to be my Plan B.