Hey all, I need an apple script to reset the serial value back to "1" on a field called SequenceNumber when the script is ran. I am going to use it on Filemaker server and I am going to schedule the script to run through the scheduler program in filemaker server. I would set it up as a filemaker script but I only want it to reset once a day and not everytime a user quits out of the database. Any help or suggestions would be great. The filemaker script I used for this is:

Set Next Serial Value["SequenceNumber", "1"]

The script works great in filemaker but had it doing it on a restart and everytime a user quit out of the filemaker database it would reset it and i only want it to reset a midnight every day. Thanks again

Sounds like you could just set an Applescript...

Tell application "FileMaker Pro"

do script "reset serial"

end tell

and set the script to run at 12:00am

Man story of my life...... making everything harder than it needs to be. Thanks for showing me the error of my ways!

Ok can anyone help me out with this??? I set up my applescript as stated above and it works fine for Filemaker pro. But i am using this on filemaker server it doesn't like the word script, says Expected end of line but found script when I change it from pro to server. Any ideas?:?

In server is nothing to run your request. You can do it on workstation only.

Your best bet, is to include in the applescript a few steps to have it open FMPro, and then open the database. Then run your script, and close the application. Fraid you can't do it in Server. Tsk!