how to store dynamic value in varchar by mannual text + field attributes

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sapyantuk
    Senior Member
    • Oct 2020
    • 265

    how to store dynamic value in varchar by mannual text + field attributes

    Hello

    i have one name field where i want to store new text which will be the mixture of mannual text + value called through attributes


    for example

    i have two field

    status = approved
    company name : abc company

    now i want to set name varchar field = abc company approved

    Please Help

    Thanks in Advance

  • Vadym
    Super Moderator
    • Jun 2021
    • 345

    #2
    Hi yubrajkafle,

    You can concatenate two or more strings using Formula "string\concatenate(STRING_1, STRING_2)":
    https://docs.espocrm.com/administrat...ingconcatenate

    Comment


    • sapyantuk
      sapyantuk commented
      Editing a comment
      Thank you problem solved
  • esforim
    Active Community Member
    • Jan 2020
    • 2204

    #3
    Just to clarify since if you new to formula like I was, yours formula probably be something like this

    varcharFieldname = string\concatenate(status, accountname)

    But wait there more! It probably come out like this: abc companyapproved

    So you would need to do something like this instead;
    varcharFieldname = string\concatenate(status, " ", accountname)

    Comment


    • sapyantuk
      sapyantuk commented
      Editing a comment
      Thank you problem solved
Working...