Skip to main content
1-Visitor
August 25, 2016
Question

How to use concat function for concatenates string and field?

  • August 25, 2016
  • 1 reply
  • 1372 views

I am getting syntax error in computation express?

1. Concat(ToText("Major Version"),., ToText("Minor Version"),., ToText("Build Number"))

2. Concat(ToText("Major Version"),".", ToText("Minor Version"),".", ToText("Build Number"))


where

Major Version, Minor Version, Build Number are Integer fields

    1 reply

    1-Visitor
    August 26, 2016

     

    You need to use the Text() function around strings. Strings by themselves are interpreted as field names and you don't have a field called "."

     

    For example:

    concat(text("Copyright "),ToText(getYear(now())),text(" My Company Ltd.."))