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
_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
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Huh? Was that a response to a different thread?
  • 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.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Oh, so you need to handle more than 25 unique children?
  • EOMDevelepors's avatar
    EOMDevelepors
    Qrew Captain
    7 years ago
    Yes. But based on tech support you should be able to view more than 25. Waiting to hear the outcome of your support ticket. In the mean time I was playing with Dans script.

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    My initial response from support was he thought was a limit of 25, but he needed to hear back from the actual developers and that would not be until later this week when everyone is back in action after the holidays.
  • EOMDevelepors's avatar
    EOMDevelepors
    Qrew Captain
    7 years ago
    Dan! Can you pls answer this question? Thanks

    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.
  • EOMDevelepors's avatar
    EOMDevelepors
    Qrew Captain
    7 years ago
    Dan. I am still trying to implement this and I am getting an error.

    Here is my code:

    "<img src" &
    " data-rid='" & [Record ID#] & "'" &
    " onerror='\n\n(async () => {\n  var dbid = 'bpazt8r8v';\n  var dbidPatients = 'bpazt8saj';\n  var dbidMedications = 'bpazt8sb6';\n  var apptoken = '(myapptokan)';\n  $.ajaxSetup({data: {apptoken}});\n\n  var rid = this.dataset.rid;\n\n  var medsString = await Promise.resolve(\n    $.get(dbidMedications, {\n      a: 'q',\n      clist: '6',\n      query: '{7.EX.${rid}}',\n      opts: 'csv'\n    })\n  );\n  var medsArray = medsString.split(/r?\\n/);\n  medsArray.shift();\n\n  var markup = '<a href=&quot;${dbidMedications}?a=s&query={7.TV.${rid}}&opts=disprec&isDDR=1">';\n  medsArray.forEach(function(med) {\n    markup += '<span class=&quot;wrapper slk&quot; style=&quot;display:inline-block;&quot;>${med}</span>'\n  });\n  markup += '</a>'\n\n  this.outerHTML = markup;\n\n})();\n\n'>" 

    I updated the table ID's and the dbid. after this {7.TV.${rid}}&opts=disprec&isDDR=1">' I am getting an error.

    Any suggestion?

    Thanks