Forum Discussion
MarkShnier__You
Qrew Legend
Do you have a relationship where one Health Region has many communities?
If so, you could create a text field on the community record which contained the name of the community and that count value.
Then use a Combined Text Summary field to roll those up to the Health Region.
Then use a formula to get rid of the Bubble appearance and change to a vertical list.
SerachAndReplace(ToText([My Combined Text Summary field]), " ; ", "\n")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
If so, you could create a text field on the community record which contained the name of the community and that count value.
Then use a Combined Text Summary field to roll those up to the Health Region.
Then use a formula to get rid of the Bubble appearance and change to a vertical list.
SerachAndReplace(ToText([My Combined Text Summary field]), " ; ", "\n")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
JenniferJuhasz
3 years agoQrew Cadet
Hi Mark,
Thank you so much for this! I do have a relationship where one Health Region has many communities.
It took me a bit of thinking to figure it out - but I have everything here, except where to put in the formula you suggest:
SerachAndReplace(ToText([My Combined Text Summary field], " ; ", "\n")
The Summary Field defaults to a 'multi-select' text field, with no option to change to a formula-multi-select text field... at least so far as I can see. Where do you input the formula?
Thank you again! I appreciate your help so much,
Jen
------------------------------
Jennifer Juhasz
------------------------------
Thank you so much for this! I do have a relationship where one Health Region has many communities.
It took me a bit of thinking to figure it out - but I have everything here, except where to put in the formula you suggest:
SerachAndReplace(ToText([My Combined Text Summary field], " ; ", "\n")
The Summary Field defaults to a 'multi-select' text field, with no option to change to a formula-multi-select text field... at least so far as I can see. Where do you input the formula?
Thank you again! I appreciate your help so much,
Jen
------------------------------
Jennifer Juhasz
------------------------------