I have a fairly basic question maybe someone can help me with: How do I get a calculation to happen automatically in the data base after I make manual modifications?
In my example, I’ve manually entered a number for “amount” ($894) and want it to be multiplied by the “rate” (10%) to automatically populate the “rebate value” field with the result ($89.40). Thanks
You don’t do it “in the database”. You do it in the workflow when you create the new thing (transaction).
Ahh…okay very helpful. I can now see that this math is done in the workflow by making a change to the thing that was just created. The calculated “rebate value” is now showing up correctly in the data base.
However, I have a new problem now in that any edits I make to the “value” (which arrived there as a default number) do not automatically update the “rebate value”. The math equation seems to have been a one-time thing…
Any ideas?
I believe you need to click on “add another field” and then do your math on the value as well. How else does bubble know that you want to update the “value” as well as the “rebate value”.
This topic was automatically closed after 70 days. New replies are no longer allowed.