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.
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.
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.