Calculate the total from a UI element "Table"

pl.kasee · 2025-03-02T17:59:25.474Z

SCR-20250302-loqw2342×1462 303 KB

I have a (Total) column in UI Element (Table) that calculates a value using formulae. I would like to seek advice on how to add all the values of the rows in the Total Column?

divypratap73 · 2025-03-02T18:10:10.858Z

try to do this - RepeatiningGroupX’sListOfRows:EachItem’sTotal:Sum

pl.kasee · 2025-03-03T01:19:02.720Z

Thank you for the reply. However the “Total” does not show up as it is not part of the database table. Is there something that we can workaround

divypratap73 · 2025-03-03T11:37:00.102Z

Well, if you want things to be simpler, just add a total field in your data type or you can achieve it with the free orchestra plugin.

Add a musician (which will be added in each row of the repeating group).

Create a custom state on the page or group level (total value).

When the musician runs through each row, it adds each row’s total value to the custom state total.

image1114×670 41.6 KB

And the important thing is when to trigger the workflow for the addition of all columns. Since Bubble workflows are asynchronous, we can’t trigger the workflow on page load or after a delay. You need to add a trigger inside the musician revealed action with the condition when count == current cell index to make sure it triggers at the last row in the repeating group.

image1111×662 50.2 KB

here is editor link for the steps-

Bubble

Bubble Editor - test app divy

Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications.

pl.kasee · 2025-03-03T15:39:41.207Z

Hello @divypratap73 ,
Thank you so much. This was very helpful & your knowledge is applaudable.