New Participant

Solved

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

Forum|Forum|4 years ago
November 16, 2021
7 replies
1223 views

No text available

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by skyehansen

John, I found it! https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FWorkfront_Fusion%2FFunctions%2Fstring-functions.htm&_LANG=enus

(it's toString)

Doug_Den_Hoed__AtAppStore

New Participant

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

New Participant

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

New Participant

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%2FReports_and_Dashboards%2FReports%2FCalc_Cstm_Data-Reports%2Fcalculated-data-expressions.html&_LANG=enus ) -- 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.

New Participant

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}})"

New Participant

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