SeedCode Support Forum

I am new to designing FileMaker databases, however I have a basic database for keeping track of clients and I need to contact them on certain dates. Is there a function or plugin that will have the record make itself available on a certain date, sort of as a reminder that this task has to be done, without me searching for it?

Thanks for your help.

Hi Rick,

The simplest thing is probably to create a calc field on your main menu (or somewhere else in the system you frequently visit) that would display the number of items due that day. This would be based on a relationship between a calculated field (set to be unstored and equal to "get ( current date )") and the Due date in your database. You can the use the Count ( ) function to count some always-there field in that database to display the number of items due. Making this display field a button which uses GoToRelatedRecord could the take you to the items due when you click on it.

If you want something that actually reaches out and touches you when things are due, checkout the Events plugin from Waves in Motion. This would let you run a script every x hours that could email you about upcoming items.

John