Quick Question about Field Validation (I think)

[Protour Travel]

My driver's get bonus income when they reach a certain plateau during a trip. These bonus levels change with increased mileage. Because of this, the bonus levels are entered manually by the driver.

 

On my Driver Pay layout I have a calculation field (TotalMileage) that states the number of total miles on that trip. Basically "EndingMileage" - "StartingMileage" = "TotalMileage"

 

I want to trigger a script upon exiting the TotalMileage field that will look at the data and popup up a reminder for the driver to enter a bonus level IF the total mileage is above the first bonus level.

 

My question is; what function step will handle this for me.

 

IE; your total mileage is over 450 miles for this trip. Don't forget to add your bonus level.

 

Thanks...

[comment]

My driver's get bonus income when they reach a certain plateau during a trip. These bonus levels change with increased mileage. Because of this, the bonus levels are entered manually by the driver.

 

Putting your question aside for the moment: if the driver can figure out the bonus levels, why can't a computer?

[Protour Travel]

Putting your question aside for the moment: if the driver can figure out the bonus levels, why can't a computer?

It can. This is a temporary fix until I can delve further into this.

 

But since you asked, I have up to 10 bonus levels with a Low mileage number and a High mileage number for each level. The computer will be able to compare the final mileage to the bonus low and high levels and auto enter the appropriate bonus level.

 

I have the fields in place but honestly haven't had time to look into that function. Please, please feel free to do that if you'd like.

[comment]

It's only a matter of lookup (and it needs to be a lookup, since bonus levels can change).

 

 

---

BTW, you don't need a "High mileage number" for each level, only a low limit, e.g.

 

after 450 miles: 10 points;

after 900 miles: 22 points;

after 1300 miles: 35 points;

etc.

 

then just select 'copy next lower...' in the lookup setup.

Edited November 19, 2013 by comment

[Lee Smith]

Have you read the FileMaker Help About Lookups or Updating Lookup values?