close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Track and display dates of updated records

Thread began 1/16/2014 12:27 pm by ori382079 | Last modified 1/23/2014 6:04 pm by ori382079 | 1082 views | 8 replies |

ori382079

Track and display dates of updated records

Please advise me how to keep a track of dates when a record is updated and show the history. Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

create a column to store the date, using the time stamp data type.

set the default value for the column to:
CURRENT_TIMESTAMP

on the update page, add a hidden form element to capture the date, set the value to:

<?php echo date("Y-m-d h:i:s"); ?>


in the update behavior, bind the date column to the hidden element.

Sign in to reply to this post

ori382079

Hi Jason,
What I am trying to achieve is keeping and showing changes made to a date datatype field in a form which in this case is the update page. That's when a user updates the datefield in the update page, the change is recorded and when any other user checks the detail page the history of date changes is displayed in a field.e.g changes made 12/12/2013<br />25/12/2013<br />10/01/2014<br />20/01/2014

Sign in to reply to this post

Jason ByrnesWebAssist

what i described above will do that.

Sign in to reply to this post

ori382079

Morning Jason, I have done it but nothing is happening, I created the hidden field, bind the date column to the hidden field, but nothing happens. Jason, actually the field in question should be getting it's data from another date field when users update. There is a date field which is court hearing date (date datatype field) that will be set be the user, each time the hearing is adjourned the user updates this field (court hearing date) in the update page.Now what I'm trying to do is to keep the record of all the court hearing dates for each case in the past_hearing_dates field ( which is the date datatype field , you advised me to create) and display these dates in both update and detail pages. Where the challenge for me is how to catalog these dates in the past_hearing_dates field? Please see the update page attached with your instruction. I'll really appreciate your help. Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

I dont follow, what precisely is it yoou are having trouble with.

please describe how the results of this page differ from what you are trying to accomplish?

Sign in to reply to this post

ori382079

The expected result is not showing. The history of changes made to the next hearing dates are not showing in the past_hearing_dates field, I want to display every change made to the next_hearing_date field in the past_hearing_dates field. Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

Please provide a Skype username or a US phone number and a good time to contact you when you will be in front of your computer and we will have an engineer contact you to resolve this issue over the phone.

We are available Monday - Friday from 9am - 4pm EST (except major U.S. holidays).

Sign in to reply to this post

ori382079

Thanks Jason, is it ok to connect tomorrow Friday between 10am - 11am which is 3pm -4pm GMT ( my time zone ). My skype username is annykaconsultingltd.
Looking to hear from you.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...