Forum Discussion

KateTheriault's avatar
KateTheriault
Qrew Cadet
7 years ago

Is there a way to create a recursive query in QuickBase to return all items from a table with relationships that may be several layers deep?

I know there isn't a way to to do recursion natively in Quickbase.  I have a bunch of recipes that nest 5 levels deep. I want to create a query to flatten the structure. Is there a dirty way to do ...
APIs and custom code
Ask about Quickbase functionality
Data import and export
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
In sleeping on this, it is actually a fascinating problem to tackle natively.  I think that what I have so far is a partial solution.

I think that the other part of the solution will be the concept of a User Focus to set a "Focus" on a Recipe and then "light up" the relationships below to be able to print a summary report of ingredients groups by the 4 levels of the Recipe.

It will take more thinking to completion this concept.