How to combine several custom form fields into 1 cell in a report (both the field name and response). | Community
Skip to main content
Level 4
July 27, 2020
Solved

How to combine several custom form fields into 1 cell in a report (both the field name and response).

  • July 27, 2020
  • 1 reply
  • 834 views

My organization has 30 custom form fields they'd like to have on a report so it can be exported and shared externally, it has to be a report because of the inability to export custom forms. This creates an ugly horizontal scroll, so I'm curious if anyone has had any success with "sharecol=" in text mode and what pointers you may have? I'd like to make several groupings of custom form fields and their responses appear in 1 cell, maybe 6 groupings of 5 fields each.

I've found the page here as a reference - https://leappoint.com/2018/08/09/workfront-pro-tip-advanced-report-formatting-really-advanced/ but am just not having any luck. I seem to only get the headings I enter to appear and not the responses.

Here's what I've got so far, just trying to get 2 fields "What is the research about?" and "What are the core research questions?" to appear for now.

column.0.displayname=COMBINED

column.0.linkedname=direct

column.0.namekey=What is the research about?

column.0.querysort=DE:What is the research about?

column.0.sharecol=true

column.0.textmode=true

column.0.value=<font color=000000><b>What is the research about?</b></font>

column.0.valuefield=What is the research about?

column.0.valueformat=HTML

column.1.sharecol=true

column.1.shortview=false

column.1.textmode=true

column.1.value=<hr>

column.1.valueformat=HTML

column.2.displayname=

column.2.linkedname=direct

column.2.namekey=What are the core research questions?

column.2.querysort=DE:What are the core research questions?

column.2.textmode=true

column.2.value=<font color=000000><b>What are the core research questions?</b></font>

column.2.valuefield=What are the core research questions?

column.2.valueformat=HTML

Below is how the above appears -

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 NRYNR

Hey Ryan,

The WFPro Shared Columns post from 2018 should get you exactly what you need.

Thanks,

Narayan

1 reply

NRYNRAccepted solution
Level 10
July 28, 2020

Hey Ryan,

The WFPro Shared Columns post from 2018 should get you exactly what you need.

Thanks,

Narayan

Level 4
July 28, 2020

YES! Thank you so much, nailed it!