Forum Discussion

ManuelAlvarez's avatar
ManuelAlvarez
Qrew Trainee
7 years ago

make an autofill based on the number that shows another field.

I need to make an autofill based on the number obtain from the substrack of 2 fields. Ex. 1.- Field "A" quintitie assure 100,000 Field "B" % charge              .4% Field "C" total charged     ...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Perhaps you mean this for the formula for [Field E]

var number X = ([Field B] - [Field D]) * 1000;

[Field A] * $X




ManuelAlvarez's avatar
ManuelAlvarez
Qrew Trainee
7 years ago
It worked but I want to give like a preset value for the points, perhaps I need to work to steps. 
Field E  which convert result from B-d. When ever I get .4% I want 3, when ever I get .6% I get 7 and so on. 
And then another field lets say F, which multply Field A times Field E