How to calculate a total from input field items in a repeating group

[fjosiah050]

Is there anyway to calculate items within a repeating group list of user input values, using custom states?

I have a repeating group with a group that holds a price input field, quantity input field, subtotal field (which is the product of the price and quantity input fields from the user), and delete button. How would display the total of all the repeating group cells outside the repeating group, while accounting for when a user changes the pricing and/or quantity fields (i.e., the subtotal) AND if a user deletes a cell, using the delete button?

I’ve been trying to do this with custom states, but I am at a loss. Please help

----Adding a video recording of what’s happening. I thought this would help since what I have doesn’t seem to be super complicated using custom states, I think I’m just missing something.

[salemmo409]

The repeating group displays a list of entries that already exist in the database, and when the user changes the value of an input, the related field will be updated in the related entry, if this is your case, then you can use an expression like this:

[GH5T]

You can easily do this with Energizer. Demo is currently in works, and this used to be called Scoper.

Energizer can do what Element Scoper did plus more now, and it is its own independent plugin called Energizer.

You just put the Energy Pod in your RG, assign and you can track anything that happens from within a cell or send triggers directly to it.

Oh, and it’s free.

[boston85719]

How do i sum different values to show up in a group?

So, i have 2 dropdowns per row, one has a product and other has a number, and for each of them i have a text that has the value of the dropdown. At the end of each row, i have another text that totals everything up. Considering that i have 5 groups as rows, i need to have a grand total based on the values of the total text from each group. How can i do that?

Sum on invoice items based on invoice

Dear community, I have an issue summing up data of invoice lines from an invoice data type I created. I tried to have the same logic as the replies on this question but I end up having a blank number. All my fields are numbers it looks like the “search for” is not working properly. Any ideas ? [image]

How to Assign and Save Quantities to Food Items in a Basket Item Using Custom States

[Screenshot 2024-04-20 194335] Hi there, I am trying to update a data type called ‘basket item’ with a list of sub food items. The list of sub food items coming from the repeating group shown in the image. The repeating group is a list of sub food items with its own quantity. Each of these sub food items is a creation from each restaurant so we want to be making duplicates of these items with the quantity set when saving them to the basket item. How can I save the save the sub food item lis…

Troubles with calculations

[fjosiah050]

Hello! thanks for the input. I added a video recording of what’s happening, to give you an idea of my problem. I’m basically trying to store values in custom states within a repeating group, and get the resulting data outside of the repeating group to display the running total, while accounting for if/when a user deletes a line item. It seems like this can be solved with some math, but I suck at math lol. Anyway, linking the video below.