6 Replies Latest reply on Jul 27, 2011 11:20 AM by sly_1

    POPUP Reminder



      POPUP Reminder


      Once again im stumped, so here is what im trying to do.

      I have a date feild with a calendar drop down.

      what i would like it to do is the following.

      date = today

      now every 3 days from today i would like a popup to apear saying reminder please follow up.

      how would i go about doing this



        • 1. Re: POPUP Reminder

          In File Options, you can designate a script to be performed every time you open the file.

          This script can perform a find for the records that are 3 days or more older than today. If any are found, it can display a message in a custom dialog and also present you with a list of the records found.

          You'll likely want to add another field where you can check off the records where you've followed up so that you can include this field in your find. That way, you won't keep getting the same record popping up after you've finished the follow up task.

          • 2. Re: POPUP Reminder

            How would i do this. im really clueless with dates and all that stuff

            • 3. Re: POPUP Reminder

              I'm assuming you know how to use File Options to perform this script.

              Your script might look like this:

              Go To Layout [select a layout based on the table where you have this date field defined]
              Enter Find Mode [] // clear the pause check box
              Set Field [YourTable::YourDateField ; "≤ " & Get ( CurrentDate ) - 3 ]
              Set Field [YourTable::DoneStatus ; "="] // a lone "=" like this specifies records where this field is empty
              Set Error capture [on] //keeps "no records found" dialog from interrupting script if no records are found
              Perform Find [] // do not specify criteria in this step.
              If [Get ( FoundCount ) ]
                 Show Custom Dialog ["These records still have not been followed up."]
                 Go To Layout [select the layout you want users to see if there are no follow up records to deal with]
              End If

              • 4. Re: POPUP Reminder

                following your script to a T and it says im missing an operator get current date

                • 5. Re: POPUP Reminder

                  Do you see an extra set of [] not shown in my script example?

                  If so....

                  When Setting up Set Field, there are two Specify buttons that must be clicked. To get Set Field [Table::Field ; Expression], add set field to your script and click the first button (specify target field). Select Table::Field from the list of fields. Click OK. Now click the lower specify button (calculated result) and create the expression to the right of the semicolon (;). Do not try to type in the semicolon.

                  If not, please post exactly what you have and I'll take a closer look at it.

                  • 6. Re: POPUP Reminder

                    Thanks alot phil once again greatly appreciated.