Simple Recursive Formula
Hello! Please see diagram attached. This is a setup where a recipe is comprised of recipe items (ingredients) and sub-recipes (nested recipes). The structure has no set limit on how many levels of...
Forum Discussion
Stephanie,
I did get that concept working once for an app with Bill of materials for parts assemblies where an assembly could use a subassembly from the same table, and there was no limit as I recall to the number of loops. The trick is to somehow not have it be seen by Quick Base as a circular reference.
Unlike excel, QuickBase does not tell you that is has a circular reference, but it does behave weirdly.
When I get a chance I will see if i can locate that app to remind myself how I solved that obstacle.
I did get that concept working once for an app with Bill of materials for parts assemblies where an assembly could use a subassembly from the same table, and there was no limit as I recall to the number of loops. The trick is to somehow not have it be seen by Quick Base as a circular reference.
Unlike excel, QuickBase does not tell you that is has a circular reference, but it does behave weirdly.
When I get a chance I will see if i can locate that app to remind myself how I solved that obstacle.
My QB hero!!! Although the webhooks do not come with the exchange application, the description was enough to explain the solution. This worked like a charm and was a very clever of you! I ended up using 10 automations since we have that luxury now :)
Can't thank you enough rock star.
Can't thank you enough rock star.