I wish formulas were easier in Bubble. I can do amazing things with excel, and I always have a hard time doing simple calculations simply because they don’t give you the ability to type out a formula.
OK, I’ve broken the longer formula out into multiple sections, and recording the data in separate date fields since that was the only way I could figure out how to do it.
Now I’m left with one formula I can’t figure out.
I’ve saved the (H6/C6) part as a field called “Score_acceptance_year_form”, but it does not seem to let me write 1 followed by a minus sign(unless it would understand text?).
I want to write 1-Score_acceptance_year_form*100, but it does not seem to let me do that.
Here is the early steps where I had to do everything as separate fields and save them to add them all together at the end. There has to be a simpler way to do this.
do Arbitrary Text, type 1 in there, then close out of the window and do :converted to number, then your math.
Also in the experimental section does it let you enable parentheses anymore? If so I would so you can confirm it’s doing the order of operations you want it to do
Thank you. I’ll have to look into the parentheses. I see I can turn it on, but will have to figure out how it works. The test I did the results were not as I expected and I suspect it has to do with the parentheses and the order of operations.
Yea it’s a little weird at first, you basically make your expression then pick which “More” you want to click to insert another expression. The other options is the new expression composer experimental feature, that is supposed to be fancier and also includes parenthesis-like functionality
Bubble reads the expression from left to right, but I don’t trust it to know what I’m actually trying to do
In addition (pardon the pun) to @tylerboodman’s Arbitrary Text workaround, you can rearrange the calculation to better suit Bubble, for example an equivalent is
