Report to show all custom fields on a custom report

[TaraMc2]

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! 

[Doug_Den_Hoed__AtAppStore]

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

[skyehansen · Accepted solution]

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