My app needs to take a set of numerical inputs from users, then run a set of complex calculations that will differ in nature depending on the inputs (for example, the output could have 10 or 20 outputs depending on a user’s input)
I suspect it will not be possible to do this in Bubble.is in a scalable way. Not only outputs will vary but there will be a need for complex mathematical functions (like logarithms etc.).
So I suspect the best way to achieve this is by using blockspring’s Google Sheets blocks, where I export stuff into a google spreadsheet, run calculations there, and the read the data from the spreadsheet.
I unfortunately am having issues with “Append values to existing Google Spreadsheet” which is what I had intended to use for supplying user’s input numbers to the spreadsheet. (The block doesnt seem to like when you enter as values a comma seperated string like “Alpha, 5, Beta, 10” etc. It expects a “range” input, but not clear how to supply a “range” in the “value” field) I reached out to Blocksrping support as well but no luck so far.
Anyways, long story short:
A - Has anyone had the same problem and tackled it via Blockspring? If so, how? (Python coding would be another way but custom functions are not yet supported in bubble integration apparently)
B - Is there a way of implementing complex/variable calculation logic in Bubble.is without using Blockspring?