Running Scripts I'm a DUMMY

[anne91081]

OK- I just downloaded a free trial of file maker pro for my work. I have used it before at previous jobs, but never was the person that set it up. Right now our situation is this: We have a lot of labor employees that need to have current certificates stating that they are able to work, or we can't work them. So I'm just trying to make a simple database that has all of their different expiration dates. I would like filemaker to tell me when they are expired, or at least let me search current employees. I have found this script that i made in the script manager

if ["ASB Expiration" > Get(CurrentDate)] Run Custom Dialog ["YES"] End If

 

I just want to run this in one specific field so if the date on the certificate is bad, it shows YES in the expired box.

 

Since I made this script i don't know how to run it =/ or if i'm doing this correctly at all. I realize I should probably go buy a filemaker pro for dummys book but since I am just trying to put together this trial for my boss (to try and convince him to buy/use filemaker) i don't want to invest any personal money right now.

 

PLEASE HELP!!! and use small words

[peterc]

Not sure why you want a script for this. You could just create a new calculation field and set the calculation as If(ASB Expiration> Get(CurrentDate),"Expired","Current"). This could just be placed on any layout and you can see it. Maybe just set the field name of the person to change red if ASB Expiration > Get(CurrentDate, via the conditional formatting. The first method gives you an easy search criteria, if you need it. Hope that is simple enough.

[anne91081]

YES this is all i wanted!!! i didn't know what i was doing with the scripts- i had that idea from other posts. smiley-smile THANK YOU!