Install OnTimer Script Help Please

[schnook]

hello all,

this is my first post and would just like to say g'day to all first.

I really need help in writing a script in dummy terms please, i believe it will need to be a Install On Timer Script and i have no idea how to do this.

e.g. Vessel logs on at 10:00Hrs and states he will return back home at 16:00Hrs, I need a reminder to be given just after 16:00Hrs and be taken to that entry in our radio log for us to follow up on his where-abouts.

The field that the script will need to be linked to is the ETR field (estimated time of return).

Am using FMP 11 Advanced on Win XP service pk3 PC.

Regards

schnook

[bcooney]

Hello, "schnook," and welcome.

If you create a field that let's you know that the vessel is late, then you can Find on that field.

I'm not sure of your table structure. But in the table that you enter the ETR (which needs to be a timestamp), create a calc,

flag_OverDue = If (get (currenttimestamp)>ETR; 1; "")

and make sure that this flag is unstored.

Now, you can find for all the flag_OverDue = 1. You can even hilite using condt'l formatting all records where flag_OverDue =1 (perhaps bright yellow or red).

It's a start.