Solved

Date time author stamp in solution field

Posted on 2003-11-26
3
252 Views
Last Modified: 2013-12-18
I have a form called Problem with a solution/comments field.

What I would like it to do is everytime someone clicks the solution/comments button a section opens on the form with date, time and author stamped to the left and they fill in the solution or comment.

Also, I need the most recent solution/comments to be at the top with older ones at the bottom.

Any ideas? Also, please be very specific.
0
Comment
Question by:aeonflux2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 31

Expert Comment

by:qwaletee
ID: 9826080
Where do you want the comments to go?  Let's assume for the moment that the button somehow opens up the form or document that you wish to use.

Add a field called COMBINED, type text, computed when composed, value ""

Add a table below that, one row, two columns, first column fairly narrow.

In the left side, add two computed for display fields:
1) NextAuthor - text - formula: @If(@IsDocbeingLoaded; @Name([CN]; @UserName); NextAuthor)
2) NextStamp - timedate - formula: @If(@IsDocbeingLoaded; @Now; NextStamp)

In the right side, add a text field, editable, named NextComment

Add a button at the bottom.  Formula:

NextCombo := ">>>>>>>>>>>>>>>>>> At " + @Text(NextStamp) + ", " + NextAuthor + " commented:" + @NewLine
+ NextComment;
break := @If(@Trim(COMBINED) = ""; ""; @Newline);
FIELD COMBINED := COMBINED + break + NextCombo;
FIELD NextCOmment := "";
"Have a nice day... qwaletee"
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 500 total points
ID: 9826087
Oops, that would put new comments at the bottom.  Revised button code:

NextCombo := ">>>>>>>>>>>>>>>>>> At " + @Text(NextStamp) + ", " + NextAuthor + " commented:" + @NewLine
+ NextComment;
break := @If(@Trim(COMBINED) = ""; ""; @Newline);
FIELD COMBINED := NextCombo + break + COMBINED;   "<----- This is the only change";
FIELD NextCOmment := "";
"Have a nice day... qwaletee"
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9826517
Create a form called frmComments with time/date, author and comments text fields..

When user hits a button to enter comments, open up a dialog box (using frmComments) with comments text field and other header details like time and date.

Once when he enters the comments and clicks OK button on dialog box.. Create a comments document (using  Form  frmComments)  with the data that has been entered into the dialog.

Now create a view called Comments, with selection formula .... Select Form = "frmComments"
Create columns that will show time/date and author and comments listed .

Now embed this view into the main form which will show all the comments listed by date and you can arrange sort either to show latest or oldest comments !

PS: First start of with form frmComments and then call it in dialog.. Then if you need step by step instructions.. let me know

~Hemanth

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question