Sum'ing non-DB values from a Repeating Group

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!

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:

1 Like

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