Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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


  • #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

  • #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...
X