Report to show all custom fields on a custom report | Community
Skip to main content
TaraMc2
TaraMc2
Level 2
June 14, 2024
Solved

Report to show all custom fields on a custom report

  • June 14, 2024
  • 2 replies
  • 880 views

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! 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

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

2 replies

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
June 14, 2024

 

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
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
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
    Terms & ConditionsAccessibility statement

    Loading footer...