2. PHPRunner General questions
  3. [SOLVED]  Date Last Modified code needed, PHPRunner
This topic is locked
[SOLVED]

 Date Last Modified code needed, PHPRunner

 		2/3/2012 7:30:06 PM
PHPRunner General questions
R
 realtoast author

Hello.
I've got a fairly simple app that I'm working on. Just one table. Works fine. I would like to have a field, Date Last Modified, automatically updated if any fields in the record are edited, or remain null until the first edits are made to an existing record.
The field is type, DATETIME.
Can you share with me not just the necessary code, but how/where I would place it.
I'm a newb and have not found an answer yet here in the forum.
Many thanks!
Rob
R
 		realtoast author 2/4/2012

Never mind. I figure this out.
For the benefit of the next newb who may have the same questions, here's what I did.

  1. Create field "Date Last Modified", type DATETIME
  2. In Editor, I double click the field
  3. In the dialogue box, select "Edit as > Date"
  4. Check "Required Field"
  5. Check, "Apply on the Edit Page as well"


The above steps gave me what I wanted: place a new date time stamp in the field every time I open the editor of a record.