Summary of Summaries
I have an application that has a work group intake table [Parent]. From that workflow intake, it can be assigned to multiple work groups [Child]. And then can be assigned to multiple individuals [Ch...
Forum Discussion
Hey Mark, so you can see that I have multiple Current Status Summary fields. What I want to do is create a field that summarizes all this into one. But, i want it to appear where it would look like:
"POS Summary:" (This would be text) - [Current Status Summary POS]
"NTW Infrastructure Current Status Summary" - [Current Status Summary - NTW Infrastructure]
the problem i'm having it errors out when I try to create a multi-line approach. Would i need a list function or how do I accomplish this?
------------------------------
MICHAEL SARGENT
------------------------------
"POS Summary:" (This would be text) - [Current Status Summary POS]
"NTW Infrastructure Current Status Summary" - [Current Status Summary - NTW Infrastructure]
the problem i'm having it errors out when I try to create a multi-line approach. Would i need a list function or how do I accomplish this?
------------------------------
MICHAEL SARGENT
------------------------------
You could use something like this:
List("\n", "Summary Text 1: " & [Field 1], "Summary Text 2: " & [Field 2], ...)
and if you only want fields that have a value:
List("\n", If([Field 1] != "", "Summary Text 1: " & [Field 1]), If([Field 2 != "", "Summary Text 2: " & [Field 2]), ...)
------------------------------
Paul Peterson
------------------------------
List("\n", "Summary Text 1: " & [Field 1], "Summary Text 2: " & [Field 2], ...)
and if you only want fields that have a value:
List("\n", If([Field 1] != "", "Summary Text 1: " & [Field 1]), If([Field 2 != "", "Summary Text 2: " & [Field 2]), ...)
------------------------------
Paul Peterson
------------------------------