How can I calculate the total price of selected services in Glide Apps and send that total to a user responses table?

[Darius_Elijah]

I have a table with services and prices column and then on user form I have a choice component with all services I need to total the prices of selected services and display in table.

[Darren_Murphy]

Create a Query column that targets your Services table and filters by the selected Service, and then do a Rollup → Sum through that query.

Query Column

Rollup Column

[Darius_Elijah]

Sum an Array

[Screenshot 2023-09-07 at 19.54.46 (2)] Need to sum items in Car Services Array. Tried rollup column, the sum option is not available. tried js solutions available on the forum doesnt seem to work Perhaps i am missing something var n = p1, remainder, sumOfDigits = 0; while(n) { remainder = n % 10; sumOfDigits = sumOfDigits + remainder; n = Math.floor(n/10); } return (sumOfDigits)