Help with formula with text

[telly]

What formula can I use to merge the letters with the field?

Sample: (User+[@field:UserID])

My field Data Type is Number, thanks in advance.

[SunakoChan]

 Hi - please try this formula: 'USER' + CAST([@field:UserID] as VARCHAR).

Since the we need to add a text we need to add "" then convert/cast the field number to varchar.

[Barbie]

Hi @telly, 

You may also refer to this article to know more about the function reference: https://howto.caspio.com/function-reference/

-Barbie

[NailDyanC]

On 7/5/2019 at 4:16 PM, SunakoChan said:

 Hi - please try this formula: 'USER' + CAST([@field:UserID] as VARCHAR).

Since the we need to add a text we need to add "" then convert/cast the field number to varchar.

Hi, just to add in this comment, you may also consider using CONVERT function. 

'USER' + CONVERT(VARCHAR, [@field:UserID]). If you would  like to put spaces between the two, you may  use this function: + ' ' + instead of using the "+".