How to scale a value as specified by the user
I have a recipe management app that has recipes with subrecipes and ingredients. One of the pieces of functionality I need is to be able to scale the recipes at the discretion of the user. For exa...
Forum Discussion
If you have a set of data-entry fields, a set of formula-calculation fields and a set of "update" fields; you could achieve this.
User would enter an "Update" amount, which would update the formula-calculation.
On save a form rule would update the Data-entry fields to match the formula calculation
On save a second form rule (after the first one) would change all of the "update" fields to empty values
Here's an app to demonstrate: https://laurahillier.quickbase.com/db/bnqtp9dbw (you will have admin access to the formula fields and form rules)
User would enter an "Update" amount, which would update the formula-calculation.
On save a form rule would update the Data-entry fields to match the formula calculation
On save a second form rule (after the first one) would change all of the "update" fields to empty values
Here's an app to demonstrate: https://laurahillier.quickbase.com/db/bnqtp9dbw (you will have admin access to the formula fields and form rules)