I’d like to combine the sum of a specific item in multiple lists. I have an item type called “goals” and under that item type, there is a list of values for those goals as a type called “year by year”
This may look like this:
Goal 1 year by year: 1, 2, 3, 4
Goal 2 year by year: 3,6,8,19
Is there anyway to combine the numbers in lists, so that I get (4, 8, 11, 23) rather than (1,2,3,4,3,6,8,19)?
Create a repeating group with the list of the first table then do the inside as
Current item’s number + do a search for “your 2nd table” each number item#current number row
Thanks! do you know if there’s a way to do it with an indefinite number of lists? Like, if I wanted to combine all lists that were created by the current user? In my example I used two lists, but one of the hard parts has been that its not a clearly defined number, since I want the user to be able to create as many lists as they want.
Now that’s good question, I might need to test on it myself when I have the time.
Btw there is an alternative other than my solution for the two list you can check this out : Summing two list of numbers to output a single list of number - Need help / Database - Bubble Forum
Idk if this a solution of your newly made question :
Sumproduct with two different lists - Questions - Bubble Forum
Here you go
Sum Lists by Index Plugin | Bubble
thanks! I’m on the free plan right now, so I can’t use the plugin- but I was able to find a sort of work around (figuring out some bugs with it). I made a number of repeating groups that are only visible depending on how many lists there are, and then made a group add the values of those groups- so if there are two lists: it adds two, if three: it adds three. Its a little buggy and it has a cap, but I think its mostly working. Thank you so much for the help!
Even on free plan it will let you install free plugins ![]()
whoops! I had misread something. Thanks! I’ll check it out when I get a chance. Thanks!