telly Posted July 5, 2019 Report Share Posted July 5, 2019 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. Quote Link to comment Share on other sites More sharing options...
0 SunakoChan Posted July 5, 2019 Report Share Posted July 5, 2019 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. Quote Link to comment Share on other sites More sharing options...
0 Barbie Posted July 5, 2019 Report Share Posted July 5, 2019 Hi @telly, You may also refer to this article to know more about the function reference: https://howto.caspio.com/function-reference/ -Barbie Quote Link to comment Share on other sites More sharing options...
0 NailDyanC Posted July 31, 2021 Report Share Posted July 31, 2021 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 "+". Quote Link to comment Share on other sites More sharing options...
Question
telly
Sample: (User+[@field:UserID])
My field Data Type is Number, thanks in advance.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.