Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Copper Contributor
Posts: 14
Country: Australia
Message 1 of 4 (1,470 Views)

Contact Activities

Hi all. Does anyone know if there is a way of changing the 'contact activities' field within the activities listing from a character field to a numeric field? If this was possible then it would be possible to generate a summary 'sum' report instead of only a 'count' summary.

Thanks, Steve

Bronze Super Contributor
Posts: 1,170
Country: USA
Message 2 of 4 (1,415 Views)

Re: Contact Activities

What screen/form are you refering to?  The schedule dialog box?  The task list?  The activities tab in contacts?
Copper Contributor
Posts: 14
Country: Australia
Message 3 of 4 (1,405 Views)

Re: Contact Activities

Hi Scott - apologies  I put this up in the wrong post - it is also in the ACT Premium section, and I think I have a track on it there. In answer to your question, the screen/ form is when one is developing a custom activity report. If you try to do a 'sum'on the ContactActivities: Duration subfield, you will find it is permanently locked as a character field. If it was a numeric field, you could set it as a 'sum' summary field, if you follow what I mean. ( Using ACT 2009)


Platinum Elite Contributor
Posts: 6,094
Country: United States
Message 4 of 4 (1,398 Views)

Re: Contact Activities

Its possible to use VB script programming in the report to extract the time information from a character field so that it can be summed.. The History Time Spent actually does that.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Tech Benders