I have a field that inserts the current user and time so I know who makes a new record and when. Works fine except for when a record is duplicated. It is copying the old information. Is there a way to enter new user/time information into the field when duplicating the record?

Thanks,

Mark Durgee

Mark:

Isn't that strange. I guess a duplicate is not a new record (which makes sense, in a way. It's the whole argument about cloning, encapsulated within FileMaker - is a clone new, or just a duplicate...)

When the record is duplicated, is it being done via a script? If so, you could modify the data from within the script, after the record has been duplicated.

There are only 4 auto-enter options that will override the original data in a field when duplicated. They are: Serial number, Creation Date, Creation Time, and Creator Name.

However, if you try to combine these same things together using status functions in a calculation type auto-enter, the result will always be a duplicate of the original record. So, what you have to do is create individual auto-enter fields for time date and user name, and then create a calculation field that concatenates the auto-enter fields together.