I would like to use custom formulas to mimic MS Excel functions.
The formula inputs would be provided by the user using Bubble’s input forms.
The calculated outputs will be displayed on Bubble’s text boxes.
A custom formula appears to be the most elegant solution.
I noticed Bubble has two built-in formulas under the “Calculate Formula” option.
I will need to create multiple custom formulas for my own applications.
Please suggest a way (if possible) to create custom formulas without routing each request through Bubble support?
I could integrate Google Sheets (via Blockspring) to read the user inputs in Bubble, calculate the outputs in Google Sheets, and write the outputs back to Bubble.
However, I’m not sure how to achieve this functionality (I’ve installed the Blockspring plugin and Google Sheets has been authenticated)
If you’ve created something similar, would you mind sharing your process?
Any other overlooked solutions would be appreciated.