Search for thing1’s field1 :uniqe items as list
For thing1’s field1 in list:
…do search for thing1’s field2
…create new thing2 having sum of thing1’s field2’s values
I understand Bubble enough to perform the function, just not haw to make it loop. This is a pretty easy lift in python but I don’t know the the bubble workflows well enough to make it happen. Maybe a back-end workflow? (which I only vaguely understand right now) Maybe a plugin could help? (though I’d prefer if I could do in in native bubble if possible)
Yup. You got it! Backend workflows. You create an API endpoint on the backend. Then you run it on a list from the front end. It sends each thing to the back end till it completes the list. Make sure your backend is enabled in Settings > API
Hi J805,
Thanks for the nudge in the direction of the back-end workflow. Below is what I have so far. Still stuck on how to make the API iterate over the list of results.
loops are a real pain in the a** with bubble because they only allow recursion not loops. Too many users with no compsci understanding would crash their apps with infinite loops. If recursion is memory efficient for you go for it, if not, try out the “List Shifter” plugin its great.
I don’t believe you need to do anything on a list. Try setting up the looping BEWF as follows:
Create a new API endpoint called something like “CreateConsol”.
It will have 3 keys: PartNum, countPartNums, thisPartNumCount
Add an action that creates your ScoresConsol for the current PartNum.
Add an action that calls CreateConsol only when thisPartNumCount <= countPartNums.
PartNum would be “Search for ScoreTmp’sPartNum:item#thisPartNumCount”
thisPartNumCount would be thisPartNumCount + 1
countPartNums remains constant throughout the loops.
Then finally add a button or some kind of trigger event that calls CreateConsol initially and sends the 3 parameters.
PartNum would be “Search for ScoreTmp’sPartNum:firstItem”
thisPartNumCount would be 2 (as the first one gets created on the initial loop)
countPartNums would be “Search for ScoreTmp’sPartNum:count”
I have the exact same scenario except I am creating new “kits” for my new users, but the same logic applies:
Hello, I found your plugin very good, but in my use case here, I need to fill in data from a list within another list, I iterate over a list of products, and within each product there is a list of complements, so at the end of product iteration action I call the complement iteration, but it only does the first element and moves on to the next product iteration … can you help me?
