I've built a model driven app with some custom views, in which I've specified the columns I want exported.
My users can then use the default "export to excel" functionality to export what they need from this view. I've even set up some subgrids with associated rows on the forms so they can get all the data from one place.
The reason I want to export this data is so that it can be uploaded to another tool, that expects the first column (A) to start with the first column of my view.
Unfortunately, when I went to test it, I just realized that the data exported from my model driven app this way actually starts with column "D".
Columns A, B, and C are hidden, and contain (Do Not Modify) columns containing the rows guid, checksum, and last modified date.
Is there any way to change this behavior?
A solution or environment setting maybe?
Or something I can do with via javascript or a custom component?
I'm open to a solution that, for example, requires me add a new button to the command bar that calls a function that does what I want.
I'm playing around with templates a bit as well, which might be an alternative solution, but I was really hoping I could just adjust the functionality of the default "export to excel" button.
