Getting an excel export for fields in a form IN THE SAME ORDER as it is in the form | Community
Skip to main content
TimothyBr
TimothyBr
Level 4
November 21, 2025
Question

Getting an excel export for fields in a form IN THE SAME ORDER as it is in the form

  • November 21, 2025
  • 1 reply
  • 54 views

Hello Community!

We have been asked a lot recently and in the past to give exports of forms so we can review and collect feedback on fields. We have a report to get the fields from a form or multiple forms BUT have not been able to figure out ways to get it to populate in the same order as the forms. 

 

There is just an ongoing annoyance that we cannot get an export into excel that is in the same order as the form itself. We then need to either just give a stakeholder the data dump and say “figure it out” which they are not always thrilled about, or we spend A LOT of time doing it manually.

 

Is there ANYWAY to do this better? Fusion, text mode, etc.? 

1 reply

skyehansen
Community Advisor
skyehansenCommunity Advisor
Community Advisor
November 22, 2025

If you have fusion, you should go the fusion route. It would be better for the stakeholder and less work for you (since you seem to have to do it regularly). 

 

Your other (easier) option is to just release them into the preview sandbox as a group admin or something, and make them go through it via the workfront interface. It's a lot less work on all sides, and by Saturday, if they accidentally did anything, it would be overwritten. It's minimal work and training as you just need to make sure they are converted to a group admin, and then just give them the links to the form in Setup and the form attached to an object. They'll just pull both up side by side and mostly use the object form to test display logic, calculated fields, and external lookups; that kind of thing.

 

One of the only other ways I know how to do this would be as a custom form report [the other is kickstarting it out which is even more painful], using collections reporting on the "category parameters" -- which means you're kind of stuck with getting your fields as one blob, and then them STILL being out of order.

 

sample code on a custom form report looks like this:

displayname=Fieldnames and Display Order
listdelimiter=<p>
listmethod=nested(categoryParameters).lists
type=iterate
valueexpression=CONCAT({displayOrder},' - ',{parameter}.{name})
valueformat=HTML

 

 

Terms & ConditionsAccessibility statement

Loading footer...