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?
by row do you mean cell of a repeating group or are you just adding five separate groups onto the page?
Just adding five separate groups, whats what i have.
You will use a dynamic expression to reference each of the dropdowns values using a plus operator between each dropdown, assuming the dropdown values are numbers
One dropdown has a product, and the other product has a number. User choose a product and number of items, then gets a total on that row/group in a text. My issue is having a grand total for all five group based on the texts value
So use the dropdown that has the number…but now it seems like you are saying the total is the total cost of the product price multiplied by the dropdown quantity selection.
In that case, don’t use a text to display the cost of the product x quantity selections and use an input element and have the same dynamic expression you use for the text as the initial content of the input…style the input to look like text…then to total everything, do as I stated earlier but instead of referencing the dropdown reference the inputs that have the total for each product.
Ok, ive done that. Inputs work, i added the totals and in on my grand total i added the values of 3 inputs, just to see if it works but i get nothing. all of my groups’s type of content is set to number
Make sure the inputs are of type integer. If you are pulling it from DB text field then convert it to number
1 Like
They are all on integers, but it still doesn’t show up.
