Multiple Logic Tests with Dialog Box

[goomba441]

Hello:

I am trying to get something accomplished in a field calculation that I am not sure is possible. Basically I have some logic that tests other fields and if they add to more than 352, do one thing, less than 352, do another, and if the current field doing the calculating goes below '0' pop up a dialog box that says you cant do that. Not sure if this makes sense, but here is a butchered snipit of code that hopefully someone can follow my logic on and possibly make suggestions as to making it work:

Also you will notice that I simply said "[This field]" in the code toward the end because I don't know how to reference the current field that is doing the calculation.

Any help is much appreciated!

Case(

Annual Leave Previous Balances - Annual Leave Total Hours - Annual Leave Donated Hours + Annual Leave Hours Earned <  352, Annual Leave Previous Balances - Annual Leave Total Hours - Annual Leave Donated Hours + Annual Leave Hours Earned; 



Annual Leave Previous Balances - Annual Leave Total Hours - Annual Leave Donated Hours + Annual Leave Hours Earned >  352; 352;



[This field] < 0; Show Custom Dialog [Error; You can not use hours you have not earned!; ]; "" )

[comment]

Are you really using version 6?

[goomba441]

Unfortunately, its what I was provided with at work...

I'm sure I could find an updated version if I asked but for now is this possible?

Thanks

[comment]

I believe so, but there are two separate issues here. Calculations calculate, they do not "do". To show a custom dialog, try validating one or more of the input fields using a similar calculation.

[goomba441]

I am fairly illiterate when it comes to Filemaker as I am more used to Excel. Would you happen to have an example with correct syntax I could see?

Thanks

[comment]

See if this helps.

BTW, if you're just now starting with Filemaker, I'd suggest you start with at least version 7 - otherwise you will have a lot of unlearning to do later.

Example.zip

[Vaughan]

I completely agree with Comment, however I'd recommend FMP 8.5 as the minimum.

[comment]

I agree with you, too - but now we're talking performance, not (only) paradigm.

[Vaughan]

I couldn't recommend FMP 7 with a clear conscience even when it was NEW. LOL