Data download - Control field order

[elpinguino]

Hi Dashboarders, 

In the data download function (I'm using it from a table) is there anyway to control:

• which fields show
• the order of fields

If that's not possible in Dashboard is it possible in any of the other ArcGIS apps?

Or is it just best to work outside the system and set up an FME app?

End users of my dashboard need to be able to export the data, and it would look really messy if we had all the fields in the original feature service/order. A view layer is an idea, but still not sure how to re-order within the view layer.

Looking forward to hearing any solutions, ideas or things you've tried!

[rcGIS]

Hello @elpinguino, regarding data download in ArcGIS Dashboards, this video mentions: "When a user chooses to download the source data, a CSV file is downloaded that includes the fields from that layer and their values. The downloaded data respects all filter values applied to that data source and element, so if you have a layer or map filter or just filters from actions and selectors, only that filtered data will be downloaded."

Still, I haven't tried it myself yet, so you might want to test/review so first.

[ShaneBradt]

Hi @elpinguino!

I'm not sure that this will help with the order of the fields, but you could potentially control which fields are found in the download for that element by creating a layer view to use for the data source for that specific element. You would need to have enough fields visible that you are able to make any connections (I'm thinking about actions) to other elements, but it would give you the ability to potentially remove some excess fields from the downloaded file.

[elpinguino · Accepted solution]

Thank you for your replies. At this stage I don't think it's possible to control the order of the fields in an Experience Builder table widget or Dashboard table export to excel. The best option at this stage that has an easy/friendly front end user experience is to put a button to an FME app.