AnsweredAssumed Answered

Append to Note Field

Question asked by JosahMower on May 27, 2011
Latest reply on May 27, 2011 by JosahMower

Title

Append to Note Field

Post

I am trying to append data from other fields into one note field.

I am setting up a DB for inventory and would like to keep track of the history of there the item has been. I will have a button that move the data into a Location history Log field and then clear out the other fields so that the location can be updated.

fields are:
building:
dept
fname
lname
etc.

The information would them be placed into location history like so:

******************************

Date: (Date Moved)

Building     (building)
Department   (dept)
First name:  (Firstname)
Lastname:    (Lastname)
Account User Update: (Username)

********************************


I tried to setup variable but they are not puting the data in the () fields. Every time I hit the button to move it deletes the past information and replaces it with the variable.

************************************************

Appending data to continue to fill

Building:         $building
Department:   $dept
FirstName:      $fname

******************************************

Is this possible?

Outcomes