I've got Filemaker to import a .csv file (a mailing list - via a FMS Scheduled script - it's downloaded first from a web server and then imported).

I've set the import parameters to update existing and add any new which works fine.

I now want to add a field that contains the creation date of the new record , so I thought it would be a simple case of adding a Date field to my table (auto enter Creation Date) ,So when a new record is created , it would automatically populate the date field, but this doesn't seem to work.

Apart from getting my website people to add the field their end and have it import, is there a way for this field to be populated by Filemaker itself?

any help would would be appreciated.

thanks

I now want to add a field that contains the creation date of the new record , so I thought it would be a simple case of adding a Date field to my table (auto enter Creation Date) ,So when a new record is created , it would automatically populate the date field, but this doesn't seem to work.

When setting up the import, did you select the option to perform auto-enters during import? If not, why not?

yes I did.

I'm going to go back in to that dialog box and set it up again though to see if it makes a difference.

I unchecked and rechecked the option to perform audio enters and it worked - strange