Showing results for 
Search instead for 
Do you mean 
Reply

Contact Activities

Copper Contributor
Posts: 14
Country: Australia

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

Highlighted
Bronze Super Contributor
Posts: 1,170
Country: USA

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

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)

Steve

Platinum Elite Contributor
Posts: 6,295
Country: USA

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
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129