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
Thank you for quick answer,

actually I want that B-d = .4 than to considered  3 points to multiply A
if  B-D= .5 then to considered 5 points multiply by A
if B-D= .35 then to considered only points 2 multiply By A 
if B-D= .6 then to considered points 7 multiply By A 

.35=1 
.4= 3
.5= 5
.6= 7

I want to make a relation between result and the points. I want to autofilled