Concatenating

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.

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.