Formula to lookup field in all children records

Well aren�t you lucky. If you read the release notes from the very recent December 16th release you will see that there is a new type of summary field called combine text. You can now summarize any text field in children up to the Parent to get a list of up to 25 Unique children.

The field will appear in a bubble format, but can be turned into a more text like appearance using a formula field ToText([my summary combine text field])

Please update with the outcome. Thanks

This can be done with one Rich Text Formula Field using the 3Q&S Technique without any limitation on the number of child records and using any adornment of the summarized child records with HTML and CSS. Here is a quick demo of me emulating the the style of the native "combine text" summary fields:



Get My Meds ~ Medications List All
https://haversineconsulting.quickbase.com/db/bn96mgts4?a=td

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=716

Notes:

(1) Concatenating fields from all child records is also a catamorphism (aka fold, reduce, collect, summarize, aggregate etc). Not only can you use this technique to implement any of the numeric catamorphisms listed in the below post, you can apply catamorphisms to text entities.

Catamorphism Fields
https://community.quickbase.com/quickbase/topics/catamorphism-fields