@cmarchan this does help! First, I’ve never used options sets. Second, this led me down a path which made me think: “this is simple, why didn’t this of this?”. Which is exactly how I should feel.
I built exactly what you laid out and called it “easy mode”. I then built a “hard mode” which uses more complex formulas with math.js external API. The “hard mode” still uses your same principle.
Under “hard mode” you have to click the calculate button to trigger a WF to run the math.js calculation. I built a new step in the WF for each user, and set a condition to run that step only if the users formula is XYZ.
Here’s the editor: https://bubble.io/page?type=page&name=dynamic_formula&id=dynamicformula&tab=tabs-2
Here’s the actual page: https://dynamicformula.bubbleapps.io/version-test/dynamic_formula?debug_mode=true
This will work for now. But it’s not completely scalable. I could have a workflow with 40 steps and only 1 of the 40 steps would actually run on each workflow. It seems clunky but it will work.