I am struggling to create a list from a bundle in Google sheets. I’m creating a financial model in Google sheets and I am trying to extract rows of yearly values and the combine them into text separated by a comma. Once that’s done, I want to send the data to Bubble IO to update a data field as a list of numbers.
I can easily get the rows and columns from google sheets. The data is in the Bundle (example Bundle 4).
No - i want to take a bundle of yearly values which will vary depending on the row I choose to call. For example I want the row with the years - 2024, 2025, 2026, etc.
I want that bundle and turn it into a list of numbers which I can send to Bubble io using the create/update a data thing module. I want to use these values in graphs in Bubble. One example is showing a financial portfolio value over time in a graph.
I need to extract the bundle and concatenate all the values together by a comma which forms the list.
OK, I’m still unclear on what you’re tring to do. Can you give an example of the data you want to send to Bubble based on the information you have above? Explain which row you are sending and what you’re expecting to send.
Thanks for this. However, the length of the bundle that I want to aggregate will change based on individual’s life expectancy. The number of cells to aggregate needs to be dynamic or purely based on whats in a bundle.
For example, one person could live to 85 (85 cells of data) another could live to 100 (100 cells of data).
So I doesn’t work if I have to manually input the number of cells to aggregate in the module.
