0

Concatenating

How do I concatenate the values from two alphanumeric fields and automatically apply conditional formating to the result?

2 replies

null
    • Fred
    • 3 yrs ago
    • Reported - view

    To concate two fields, you would create a new formula field and put this in the formula:

     

    concat(field1 + "," + field2)

     

    You can put anything inbetween the quotes to separate the two fields, or leave it out if you want the two fields combined.

    • Fred
    • 3 yrs ago
    • Reported - view

    for the conditional formatting, what is it based on? another field? the concatenated text?

     

    An easy example is if we use already created third field. So we start with our new field, formCon. We now modify it to look like:

     

    let xCon := concat(field1 + "," + field2) <- first we have to put the concat into a variable you can call it whatever you want

    if field3 > 5 then<- here we look at field3 and see if it meets our criteria. this is just made up so substitute your own

    styled(xCon,"","red","")<-here we style the text as red, the first empty quotes is background color and the last is icon number

    else

    styled(xCon,"","blue","")<-here we say what happens if it is doesn't meet the criteria above.

    end

     

    Let us know if this helps.

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 275Views