Date script

[defectivo]

Hello,

I've used FileMaker a bit but have something which I am hoping is a basic question. I am working with a scheduling database that organizes appointments for a school guidance office. Each day of the school week gets a new record in the 4-digit year format -- DD/MM/YYYY. I am familiar with startup scripts and wish to use one to enter find mode when the database starts up, auto-enter the current date and search the system for that date's schedule so that counselor's the correct schedule when they open the database each morning.

Any help is appreciated

[Kent Searight]

Basically you'll want this in your startup script:

Go To Layout (layout to search)

Enter Find Mode

Set Field [dateField ; Get (CurrentDate)]

Perform Find

Also, you may want to Set Error Capture [On] for the sake of a nicer user interface.

Edited October 7, 2005 by Guest

[defectivo]

Thanks a million :)