Sum'ing non-DB values from a Repeating Group

dalerankine · 2024-07-29T02:48:46.971Z

Hey everyone - still fresh Bubbler here. I have a RepeatingGroup displaying a list of Tickets and their prices from the DB. Each row of the RG then also has a “Quantity” input.

Screenshot 2024-07-29 at 11.56.13 AM

I would like to be able to determine a “total sum price” calculated from each row’s ticketprice * each row’s input QTY value, preferably without having to store anything new in the DB.

I’ve been playing around with States, lists and backend workflows, etc. but haven’t quite cracked the right mixture to make this seemingly simple calculation work. I’ve also seen an example that seems to work, but all the content is just pulled from local lists and not a combo of database+local.

Any help would be appreciated!

DjackLowCode · 2024-07-29T03:32:13.327Z

Hey @dalerankine, you’ll need to use a combination of calculations/variables based on what’s in the rows. This should be able to be updated whenever the input changes.

One way you can do this is set up a custom object that is list of text that is updated based on the activity within the RG, and then splitting this back out to calculate the values.

This may get you started in the right direction:

Dynamic row addition in Repeating Group and bulk CRUD of Things using vanilla Bubble Tips

0. Intro In this tip I’ll show you how to dynamically add new rows to a form (Repeating Group), fill inputs in them and bulk create multiple things with a single button click avoiding: any plug-in or JS (while using JS will be much easier - I try to avoid it until I have no choice ) creating empty things and using auto-binding As an example we will be creating new Tasks. Data type Task has 2 fields - task name and task description (both are “text” fields). Here is what we will get …

system · 2024-10-07T02:49:44.244Z

This topic was automatically closed after 70 days. New replies are no longer allowed.