Popup reminder 2 workdays before a set date

[caman]

I have a field in my DB that contains the shipdate for a shipment.

Is there a way to set up a popup reminder, let's say two workdays before the actual shipdate?

If the actual shipdate is on a thursday, the popup will show itself on a tuesday.

If the shipdate is on a tuesday, the popup will show on friday.

If the shipdate is on monday, the popup will show on thursday.

Thanks for all help!

Chris

[T-Square]

Figuring out how to determine the delay is a matter of creating the right calculation fields. There are a number of threads in the Forums that cover the issue. As for how to trigger the routine, you have different options depending on your circumstances.

If you have a standalone system that gets started each day, you could have a startup script that presents these entries when you start Filemaker in the morning.

If the system is hosted in some way, and therefore runs continuously from day to day, you would have to purchase a plugin that would allow you to schedule the script to run at a certain time each day.

HTH,

David