2. ASPRunnerPro General questions
  3. Concatinating form objects
This topic is locked

Concatinating form objects

 		8/13/2009 4:39:09 PM
ASPRunnerPro General questions
S
 sfkjeld author

I like to create running Notes in some apps. Users can post narratives into a textarea object on a Form and when saved, I concatenate it into the running Note along with UserName and timestamp. Looks like this.
I am glad I could help.

<<< posted by Jim 08/13/2009 @14:30>>>
Great, that worked. Thanks!

<<< posted by Sue 08/13/2009 @13:30>>>
Right-click, select 'Properties', then select font

<<< posted by Jim 08/13/2009 @12:30>>>
How do change the font size?

<<< posted by Sue 08/12/2009 @13:30>>>
So..... how do I present a <textarea> object in the Form View, then append it's contents with my username/timestamp to my rs("RunningNote") field when the record is saved?
J
 		Jane 8/14/2009

Hi,
use Before record updatedevent on the Events tab for this purpose.

Here is a sample:

values("RunningNote") = values("FieldName") & "
" & now() & "
" & values("RunningNote")
S
 		sfkjeld author 8/14/2009

Hi,

use Before record updatedevent on the Events tab for this purpose.

Here is a sample:


Thank you.
hichem 8/25/2009



QUOTE (Jane @ Aug 14 2009, 01:42 AM) Hi,
use Before record updatedevent on the Events tab for this purpose.

Here is a sample:

QUOTE values("RunningNote") = values("FieldName") & "
" & now() & "
" & values("RunningNote")
Thank you.


just another small addition. I tried this and in order to make it more user friendly especially if you have other fields to be updated at teh same line, you might want to wrap the above with an if condition to check if values("RunningNote")<>oldvalues("RunningNote") before you append the datetime stamp as other wise you will get a datetime stamp even if you update another field (assuming you have more than one field in your table to be updated)