November 7, 200322 yr Hi, I have a feeling this is probably very easy, but I can't seem to make it happen. I'd like to create a field that inputs today's date when field "A" is modified. I'm not looking for a record modification date, just a field modification date. Any suggestions? Thanks! Tiger
November 7, 200322 yr you can create a date field and then on the option part you can set the Auto-Enter as "Modification Date". So that when the current record was modified, then it will set the date as modification date. Regards, Henry
November 7, 200322 yr Take a look at these example files. File Name: Modification Log By: John Mark Osborne at this URL: http://www.databasepros.com File Name: Modify By: Hedrich Michaelsen at this URL: http://www.databasepros.com File Name: Field Modification Tracker By: Bob Cusick at this URL: http://www.fmfiles.com/tnt2.html File Name: Modification Times By: Alberto Diaz-Hermidas at this URL: http://www.fmfiles.com/tnt2.html File Name: Tracking Modifications By: Steve Wilmes at this URL: http://www.fmfiles.com/tnt2.html File Name: Field Modification By: John Mark Osborne at this URL: http://www.fmfiles.com/tnt4.html File Name: Audit History of Fields By: Rick Knight at this URL: http://www.fmforums.com File Name: Comprehensive Audit Tracking System By: Ray J. Cologon at this URL: http://www.nightwing.com.au/FileMaker/ HTH Lee
November 7, 200322 yr Sorry for miss understanding your question, you are not looking for the record modification date. So, just forgot about my post, i think Lee have give you a good answer. Henry
November 7, 200322 yr Author Thanks Lee - I've already implemented it and it works great! Have a great day...
Create an account or sign in to comment