Title
Keeping multiple updates in one field.
Post
I am creating an alumni database and i am wanting to create a field where i can keep track of who makes updates to the alumni record. I want the field to record who makes corrections from the very beginning during data entry and retain that information as other people continue to update the record over the years. Does anyone have any ideas on how best to achieve this. I am using Filemaker Pro 11.
Well I wouldn't use a single field for that. I'd set up a related table and a portal so that each time changes are made to the field, you add a record to this related table in order to document those changes.
Do you want this logging of changes to be automatic via some scripts or do you want the users to make entries to log the changes that they are making to the data in the record?
Both are possible, but it can take a lot of scripting with script triggers to log all the changes automatically. (And there might be a plug in out there that makes this easier to do...)