Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

Report to show all custom fields on a custom report

Avatar

Level 2

I would like to create a view for my end users of their custom intake form and all of the fields (and field selections). Is there a way to do this? 

 

Thank you! 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi, this is going to end up being a parameter (custom field) report. You'll be able to use all your regular parameter columns to show what kind of parameter it is (this is where you could call a collection in order to show dropdown options and that sort of thing). In the Filter, just paste in the following exists statement, taking care to place your custom form GUID where the underline is.

 

EXISTS:a:$$OBJCODE=CTGYPA
EXISTS:a:parameterID=FIELD:ID
EXISTS:a:categoryID=_____________________

 

In the View, you would add a column like this one, to show dropdown/radio button options:

 

displayname=Choices
listdelimiter=<p>
listmethod=nested(parameterOptions).lists
textmode=true
type=iterate
valueexpression=CONCAT({label})
valueformat=HTML

View solution in original post

2 Replies

Avatar

Community Advisor

 

Hi @TaraMc2,


One way to easily create a view of all custom parameters within a form (which you can then use in a report) is via our Excel Updater Generator solution, as described here.

 

Regards,

Doug

Avatar

Correct answer by
Community Advisor

Hi, this is going to end up being a parameter (custom field) report. You'll be able to use all your regular parameter columns to show what kind of parameter it is (this is where you could call a collection in order to show dropdown options and that sort of thing). In the Filter, just paste in the following exists statement, taking care to place your custom form GUID where the underline is.

 

EXISTS:a:$$OBJCODE=CTGYPA
EXISTS:a:parameterID=FIELD:ID
EXISTS:a:categoryID=_____________________

 

In the View, you would add a column like this one, to show dropdown/radio button options:

 

displayname=Choices
listdelimiter=<p>
listmethod=nested(parameterOptions).lists
textmode=true
type=iterate
valueexpression=CONCAT({label})
valueformat=HTML