5 Replies Latest reply on May 25, 2011 4:27 PM by Malibux14x

    Reminders/ alarms to check a contact at a later date

    EirRaider

      Title

      Reminders/ alarms to check a contact at a later date

      Post

      I am wondering if there is a way to set up an alarm or reminder to check a contact at a later date.

       

      For example, I spoke with a person today and they said call back in a week. Is there a way to set something in filemaker so that when I open filemaker in a week that person's contact page (or some alarm or reminder of some sorts) will tell me to look at that contact?

       

      Any help will be appreciated.  

       

       

        • 1. Re: Reminders/ alarms to check a contact at a later date
          philmodjunk
            

          In File | File Options... you can select a script that will automatically perform each time the file is opened.

           

          Define a Date Due date field.

           

          In your script:

          Go To Layout [layoutname (table that has your due date field)]

          Enter Find Mode[]

          Set Field [table:: Date Due, "> " & getastext(get(CurrentDate))

          Set error capture [on]

          Perform find []

          Set Error capture [off]

          If [get(foundcount) > 0]

           

          #do whatever you want to show the user their records...

           

          End If

           

          • 2. Re: Reminders/ alarms to check a contact at a later date
            becky_1
              

            Hi PhilModJunk,

             

            I am also interested in this function.  I have tried your suggested script, but I also get past dates and empty field as well.

             

            Is it possible to have the script list records say 2 months (or any specific date) before the due date?  Also capture any empty due date fields?

             

            Thanks in advance for any suggestions!

            • 3. Re: Reminders/ alarms to check a contact at a later date
              philmodjunk
                

              "Is it possible to have the script list records say 2 months (or any specific date) before the due date?  Also capture any empty due date fields?"

              Of course you can, you just need to modify the find request accordingly.

               

              #Find all records 2 months before they are due and all records with an empty due date field

              Go To Layout [layoutname (table that has your due date field)]

              Enter Find Mode[]

              Set Field [table:: Date Due, "> " & Date( Month(get(CurrentDate)) - 2 ; Day(get(CurrentDate)) ; Year(get(CurrentDate)))]

              New Record/Request

              Set Field [table:: Date Due, "="]

              Set error capture [on]

              Perform find []

              Set Error capture [off]

              If [get(foundcount) > 0]

              Sort[Restore]

               

              #do whatever you want to show the user their records...

               

              End If

               

              Change the 2 to a different number or replace it with a global field where you can enter the number of months you want to pull up for different "month ahead" values. I'd also set up a sort that sorts the records by date so that all the "missing due date" records are in a single group.

              • 4. Re: Reminders/ alarms to check a contact at a later date
                becky_1
                   Many thanks PhilModJunk.  Will try it out!
                • 5. Re: Reminders/ alarms to check a contact at a later date
                  Malibux14x

                  how is it going.  im pretty new to this whole thing.  i saw your post and i followed hte steps, however when i get to this step:

                  Set Field [table:: Date Due, "> " & getastext(get(CurrentDate))

                  a pop up message box comes up saying "An operatore (e.g. +,-,*,...) is expected here."

                  any thoughts on where to go from there?

                  thanks