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?
try to do this - RepeatiningGroupX’sListOfRows:EachItem’sTotal:Sum
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
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.
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.
here is editor link for the steps-
Hello @divypratap73 ,
Thank you so much. This was very helpful & your knowledge is applaudable.
1 Like