Community
Showing results for 
Search instead for 
Do you mean 
Reply

Adding a field to the history table

Copper Super Contributor
Posts: 73
Country: USA

Adding a field to the history table

[ Edited ]

We need to add a field to the history table, and add it to the columns in history list. We will input our data by an add-on to this field.

 

We tried to add a field through SQL server, but it is not shown in the "available fields" in the "customize columns" menu to add it to the history list.

 

I appreciate your suggestions.

 

I am using ACT! Premium V.16

Copper Elite Contributor
Posts: 232
Country: Germany

Re: Adding a field to the history database

Hi,

 

the historytable, can by default not be altered, and working in the SQL directly will break your sync, if you have one. the only possible aproch that i could think of, is to consider the use of Custom Tables, this can be done with an addon like Table-it

 

regards

 

Ingo Lange

ACC since 1995

ACC since 1995
Developer of Addons for ACT

CrmAddon Factory
+1 203 541 0040
Copper Super Contributor
Posts: 73
Country: USA

Re: Adding a field to the history database

Thank you very much for your reply.

 

As I found, the custom table fields can be shown only on contacts, companies, opportunities & groups. I need to see it in the "History List" tab.

Copper Elite Contributor
Posts: 405
Country: United States

Re: Adding a field to the history database

There is an addon from www.durkincomputing.com that will also allow you to do this.

 

Geoffrey B. Boulden
Twelve/Three Marketing, Inc.
Buffalo, NY
ACT!
SageCRM
GoldMine
SQL Certifications
Copper Super Contributor
Posts: 73
Country: USA

Re: Adding a field to the history database

Thank you very much for your reply.

 

I installed its trial version. It is a very interesting add-on.