Historical Comments Field

[CogoRickRose]

Respectfully request assistance/advice to see if its possible to create a field which will allow users to add comments and save them with user name and timestamp. Therefore, a field within a field if you will that allows you to capture a comment and then protect it. Then add another comment at a later time to that same field (or container) and then protect it. As such, creating a comments field that shows all of the comments that have been added over time. This is being used as a contact dbase and I would like to be able to add comments without overwriting or appending the old ones. Instead, it adds an entirely new comment to that field each time and saves that entry. I once saw this done through the use of container field but can't remember how it was done. It was even timestamped and showed which user entered that comment.

[Lee Smith]

If I understand you correctly, what you want to do is demostrated in these Tip Files:

Notes! By: Ari M. Weinstein URL:

http://www.fmfiles.com/enduserhom9.html

Notes Log By: John Mark Osborne URL:

http://www.databasepros.com

Notes Log By: John Mark Osborne URL:

Scripted Notes Log By: John Mark Osborne URL:

http://www.databasepros.com

If not, let us know.

Lee

[Ugimom]

I'm not familiar enough with container fields to know how you might do this using that route. But since none of the old hands and experts have jumped in yet..... If I correctly understand what you're describing, you could accomplish this with a portal to another file that saves each comment as a separate time/user/contact-stamped record, with a script that finds only the records (comments) related to the displayed contact.

Whoops! I see that one of the experts did jump in, while I was typing. Good luck!

[Ender]

If you just want the comment to be appended to a text field, this can be pretty easy. Use a global for the comment data entry and use a submit button. The script attached to the submit button can then take the comment text and append it with a date/time stamp to the text field. Users don't have direct access to edit this text field, so it could cause problems if there are mistakes that they want to fix.

[CogoRickRose]

Thank you all very much, I'll read up and give this a shot