Forum Discussion

EOMDevelepors's avatar
EOMDevelepors
Qrew Captain
7 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
7 years ago
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
7 years ago
That does not seem possible. I have already used that new feature many times and it works.

Can you confirm that you set up a Summary field on the relationship between Events and Subscribers and that you have not applied any filters to the summary field setup.