How to do calculations with filtering data from Bubble's Database

fbernal6 · 2020-07-25T03:22:15.954Z

Hi!

I need to generate a report calculating the amount needed for each resource used in procedures, based on the number of students in a number of courses where these procedures are performed.

My data structure is similar to this:

image1656×888 14.4 KB

But I’m having a hard time finding a way to multiply the quantity of each resource by the number of students in the respective course and then sum them up to generate the report.

I was trying to solve it by generating nested or a sequence of repeating groups, but I couldn’t access data from higher levels and also couldn’t consolidate multiple items in deeper levels.

Is there a smarter way to solve it?

Thanks guys!

solinz · 2020-07-25T18:00:17.827Z

Tell us more about structure of you data. If you capture them that would help. The number of students is easy. What about procedures can you elaborate more please

fbernal6 · 2020-07-25T19:13:51.965Z

Sure, @solinz!

Like this?

Data Structure1683×384 142 KB

Thanks!

solinz · 2020-07-27T18:28:06.342Z

implement11049×550 24.5 KB

Sorry for late reply i have implemented for you here:
https://onlinecomkw.bubbleapps.io/

fbernal6 · 2020-07-27T19:32:34.294Z

Hi, @solinz!

Thanks for your reply.

Actually I could get to this point, the issue is that I need to consolidate the resouces, aggregating the quantities of each procedure, resulting a single entry for each resource.

Generating a kind of shopping list.

In your example the final result shoud be:

Item 1 ----- Qty: 44
Item 2 ----- Qty: 8

I’m considering using a javascript for that, but there may be a way to do it withoug coding, do you see how?

Thanks again!

Cheers,
Felipe.

solinz · 2020-07-27T21:09:46.973Z

Have you tried… i use it with everything… it does what you want with ease

Bubble

RepeatingGroup Tools (bdk) Plugin for Bubble

RepeatingGroup Tools (bdk) Plugin page on Bubble. Add RepeatingGroup Tools (bdk) in one click to your app. Bubble lets you build web apps without any code.

fbernal6 · 2020-07-27T21:14:00.496Z

Not yet, but I’ll take a look.
Thanks!

fbernal6 · 2020-07-31T13:16:26.453Z

Hi @solinz.

I’ve been trying the RG Extractor/Data, but I can only extract information consolidating by course and not by item in this exemple.

I’m using the nesteg example of the plugin documentation.

Do you have any further advice?

Thanks!

solinz · 2020-07-31T19:46:11.470Z

did you try to use group by item name so you have item names separated and sum quantities then use RG extractor. otherwise you can redo data structure (dealing with lists are difficult by itself so maybe making item1 under one list and item 2 under another) or maybe to capture quantities when you enter them. i will try to do it whenever i have chance to be in front of laptop.

fbernal6 · 2020-08-02T05:15:24.628Z

Yeah, I tried that either.

In the end I acomplished what I needed by using the List Shifter plugin (List Shifter: Reverse, Rotate, Swap and ITERATE (Loop) Over Bubble Lists | Now at v1.4: Adds Numeric Option, GET INDEX Action) to iterate over my filtered list and calculate the value for each type of item.

Seems to be a really powerful Plugin!

Thanks for your support @solinz and hope the discussion will help someone else in the future.

solinz · 2020-08-02T08:26:10.054Z

Perfect i am glad you made it. I will check out the plugin as well

keith · 2020-08-02T21:19:31.108Z

Yep, this is the correct solution to your problem. While “RG Extractor” is a cute trick, it’s (quite frankly) a dumb solution to the problem of iteration in Bubble. Repeating Groups are not computational elements. They are a means to visualize a list.

(Aside: A bunch of interesting new capabilities are coming very soon to List Shifter. Watch the original List Shifter thread for details.)

solinz · 2020-08-03T04:07:17.165Z

@keith have used calendar pro and i will use this plugin. I like that when you do something you provide the complete solution as always. And you apply it for others to see the functionality. Which is great.