Forum Discussion

EOMDevelepors's avatar
EOMDevelepors
Qrew Captain
6 years ago

Formula to lookup field in all children records

Is there any formula to lookup field in all children records. I have subscribers that are children from an event which is the parent table. I want to have a formula text field in the event recor...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
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])
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
Well, in my testing, even when displayed on a form, I only get 25.  Should I put in a support Ticket?

I even make a text formula field

ToText([my combine text summary field])

to see the semi colon delimited "real" contents and I still only get 25.