1. Is there a way to get users to select the Columns/Fields that they need to export from a view as opposed to preset columns?
Reason, we have 100s of fields which not every user uses, those who only require to look/export five of those want to be able to select those 5 prior to the export so that theyre not lumped to endless/usless spreadsheet.
2. Also, is there a way that when a view is exported to Excel, those columns that are blank in the spreadsheet can then be hidden automatically.
For example, I have a view with 20 columns/displaying 20 fields values. Some users may have data in all of those fields and other have data in 5 of those view columns/fields only. For those that have the 20 fields full, their exported spreadsheet will display 20 columns with their data, but for those who have 5 completed fields and the rest is blank, the spreadsheet should display only those 5 columns with their data and hide the rest of the columns.
By the way, I have already a few Export to Excel routines which Exports a Notes View as is to Excel.
Any help in this matter will be much appreciated.