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 record which will list all names of the subscribers.

It will look something like this: John, Sam, etc

Thanks
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])
    • EOMDevelepors's avatar
      EOMDevelepors
      Qrew Captain
      7 years ago
      Thanks for the reply. I did that but it only shows the first record and not 25.

      Thanks again
    • 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.
    • EOMDevelepors's avatar
      EOMDevelepors
      Qrew Captain
      7 years ago
      That is correct. I did that and its not showing all records only the first one.
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    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
    • EOMDevelepors's avatar
      EOMDevelepors
      Qrew Captain
      7 years ago
      Please specify where I need to replace with my field IDs also I see you put in a " after the > which is causing an error.

      Thanks
    • EOMDevelepors's avatar
      EOMDevelepors
      Qrew Captain
      7 years ago
      No. Dan put together a formula using the 3Q&S Technique as seen in this thread.

      I need to know where to put my field IDs in order to get it to work.