1 Reply Latest reply on Jul 21, 2015 7:21 AM by SteveMartino

    Script to search for current date



      Script to search for current date


      Hi, I'm new to FileMaker and am trying to set up an alert script and could use some help! I have a field in the form for "service due" which is set via a calendar box. I want to write a script which will check this field in all of my records against the current date and pull up those records. Is this even possible? Paul





        • 1. Re: Script to search for current date

          Sure.  Use OnFirstWindowOpen script trigger.  Have the script perform a find:

          Enter Find Mode [ ] //uncheck pause

          Set Field [YourTable::ServiceField; "<=" & Get(CurrentDate)  // you can use the less then/equal sign instead of both < & =

          Perform find [ ]

          Show Custom Dialog [The following people are due for service...]