Calculated field value on backend workflow DB insert

Need help
1

Hi,

I’m stuck on how to deal with Bubble on this matter that seems to be simple indeed.
I fetch data from api call and i want to insert things into the DB with a calculated field value based on data field retreived by using a simple formula as you can see on the screen below. I got all the maths operators

screen-bubble
screen-bubble1002×816 48.7 KB

But nothing that allow me to deal with a simple formula like this Total profit = (profit)/(balance-profit) with parenthesis.
Any help would be appreciated as i’m not able to find the way to deal with this matter.
Thanks

2

Have you tried using math operators in the expression?

3

To use math expression, you need to use parenthesis. A+B*C is not the same as (A+B)*C. Maths is not the problem as there are lots of expression, the issue is Parenthesis in the backend worflow that is not possible which is a complete mess.

4

Bubble is quite limited in the calculations it can do natively - you’ll need to find a server-side calculator plugin. Something like this:

5

Have you tried the Toolbox plugin by @mishav ?

6

This topic was automatically closed after 70 days. New replies are no longer allowed.