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

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
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           400
Field "D" comission paid      0%

2.-
Field "A" quintitie assure 100,000
Field "B" % charge              .6%
Field "C" total charged           600
Field "D" commision paid    .1%

So field E I needed to be
  
Field "A" times  x points (If  in field B-D .4%= 3 points, If  .5%=5 point. If .6%= 7 points , all with commission considered) 

1.- 100,000 X  3 (.4%- .0%= .4%) = 300,000
2.- 100,000 x   5 (.6%-.1% = .5%) = 500,000


Photo of Manolo

Manolo

  • 214 Points 100 badge 2x thumb
  • frustraded

Posted 3 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
Perhaps you mean this for the formula for [Field E]

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

[Field A] * $X




Photo of Manolo

Manolo

  • 214 Points 100 badge 2x thumb
Hi again Coach,

Is it posible to have a range instead of a number? I tried this formula but think wrote it wrong. If between .001 and .00348 then have 1

 If([Cuota]>=0.001,[Cuota]<=0.00348),1


Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
 If([Cuota]>=0.001 and [Cuota]<=0.00348),1,
.....
Photo of Manolo

Manolo

  • 214 Points 100 badge 2x thumb
Soeey is not working, I get this massage!

Formula syntax error

There are extra characters beyond the end of the formula.

If([Cuota]>=0.001and[Cuota]<=0.00348),1

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
I was just giving you a part of a formula and showing how to use the "and".

I don't know what you want the whole formula to do.  If you just want it to do that one thing, then just close the bracket.

If([Cuota]>=0.001 and [Cuota]<=0.00348),1)




Photo of Manolo

Manolo

  • 214 Points 100 badge 2x thumb
great thank you