Appending text

[ttran]

How can I append a text string from one field to another field in the same database? For example, I have a newestupdate field and a history field. I want to have the latest updates added to the text that is already in the history field.

Having a modifiedby and timestamp would also be swell. Thanks for any help!!!

[Louisa]

Hi,

I'm not sure if this is the most elegant solution but I'v ehad to resort to this sort of thing quite a few times and it does work!

I suggest you do this using a script. Copy the information from the newestupdate field to the history field. In the paste step deselect the "Select entire field contents" this way the paste will appear after what is already in the field, not replace it.

Then make the title for the history field a button for this script so that when it is clicked History is updated.

As for the modifiedby and timestamp, create two calculation fields modifiedby and timestamp. Set modifiedby equal to Status (CurrentUserName) and set the timestamp equal to Status (CurrentTime), and voila more update info!

[ttran]

Louisa,

Thanks for the input. I'm still pretty new at writing scripts and just can't get the newest update info to paste in the correct field.

Also, I wanted to know how I could get the data in the history field to look like:

Modifier Datestamp Timestamp: text

Modifier Datestamp Timestamp: text

I have created a modiefiedby, modifieddate, modifiedtime fields and these automatically update when there are and changes. Now I just need the history field to be updated with the latestupdate info.

Any additional help would be greatly appreciated. Thanks.

[geod]

Make a button, call it Update History, or whatever you like and attach the following script to it.

If [ IsEmpty(History) ]

Set Field [ History , DateToText(Status(CurrentDate) & " " & TimetoText(Status(CurrentTime) & " " & NewUpdate ]

Else

Set Field [ History , History & "

[ttran]

Thanks, Geod.

Worked like a charm!