This topic is locked

Short cut insert or automatic

7/19/2013 1:10:54 PM
PHPRunner General questions
M
Mwilson91325 author

I wish to open the edit Form click into the memo field and enter current date and time

Ether
1: Automatically insert Current date and time in a new line

Or

2: Have a short cut Key (Ctrl_D) Insert a current date and time
My Dbase is MySql and I'm coding in PHP
Test form:

http://allvalleyattorney.com/MDW-Back-Office/Task_edit.php?editid1=4
The goal is to have a Date and time entry's into one memo field and be able to follow it chronologically.

W
wildwally 7/22/2013

I suggest you add another field to the db called date or something along them lines. Then have it timestamp the entry. To do this hide the field on the add/edit views allow the user to add an new record and fill in the memo field and save. In the before Add event simply add this:



$values['..yourdatefieldname..'] = now();


This will do everything behind the scenes.

M
Mwilson91325 author 7/22/2013

How would this work as i wish to enter a new date and time every time i go to the edit form
Something like this
01/01/13 6:45am "I called and asked him to come in"

01/01/13 6:30am "I called to finish intake form"

01/01/13 6:15am "He called me back said he would call back"

01/01/13 6:00am "I called"