Solved
Report to show all custom fields on a custom report
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!
skyehansenAccepted solution
Level 4
June 17, 2024
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