Community
Showing results for 
Search instead for 
Do you mean 
Reply

Custom Reports Syntax for custom fields

Copper Contributor
Posts: 12
Country: New_Zealand

Custom Reports Syntax for custom fields

I am trying to define some custom fields in a report but cannot find a listing anywhere of allowed syntax in custom fields.

 

For example I have a report where I am trying to return the count of each type of answer to a specific field, something like:

 

if([C:ETSA Status 0]="8 Approved",1)

 

but this and many variants I've tried don't seem to work.

 

Any suggestions on where I might find a syntax guide or answer to this question would be appreciated.

 

Cheers

 

Rob Spijkerman
Infosystems Technologies Ltd
Phone: 0064 3 3296444
Christchurch
NEW ZEALAND
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Custom Reports Syntax for custom fields

The ACT! reports use Visual Basic script programming for that.

 

There is a third party book with comprehensive training information on the ACT! reports, here is the link.

https://www.packtpub.com/sage-act-2011-dashboard-and-report-cookbook/book

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129