Hi there all. I have a question. I set up a file with lookup fileds (just about all of them) to pull in information form three different files. I now want to find a way to use a script to import all matching data from all three files and do this every two weeks automatically. Is this possible?

Thanks in advance.

Is this a file that's going to be served (i.e., open all the time) or will it be opened locally?

If it's a locally opened file, you could have the startup script check the time since the last import and then run the import if it's >2 weeks.

If it's a hosted file, then you'll need a means of scheduling scripts. There are plugins that do this, but you can also do it with a combination of the OS X cron scheduler, and Applescript.

This is a file that will be open all the time. Hosted on a server. Any idea how or where I would go about figuring out how to write a script for somthing like this? Thanks.