Hi all, I'm trying to list multiple field values through a workflow formula (the workflow sets a field value). NS_CONCAT({field}) is returning an invalid expression error. Is there another way I could list results? Entering {field} only returns the last result.

Isn't the formula just CONCAT? That being said, I'm not sure that formula is going to do what you're thinking. What it'll do is concatenate the values you specify so for example CONCAT({field1}," --- ",{field2}) is going to produce "{field1value} --- {field2value}". If you're only inputting one value ({field}), adding concat isn't going to pull additional values.

I believe it'd be ns_concat for searches, but you're right i'm looking to pull line level field values into another textbox field. Hmm do you know if this is possible?

NS_CONCAT only works on a grouped search, I believe. You would want to use a Formula (text) and set the formula to {field1}||{field2} etc. You can put a separator by usingsingle quoted text and another set of pipes: {field1}||' ,'{field2}

I'm guessing what I want isn't possible. The field is the same, for example I'm pulling in {item.name} from several lines that meet the criteria. The logs show it's executing on correct lines, but the field box where it's outputting is only retaining the last line executed. Went with a different approach, but appreciate the tip! I'll keep this in mind.

Gotcha. I dealt with that by using a WF field. I set it to its own value and the new value, so it updates on every new line