Hi,
Is there a way we can provide a link in an interface to download the data in an excel from a recordtype.
Thanks
Discussion posts and replies are publicly visible
In general this implementation is pretty easy to do with a "2-click" setup -- first the user will click a button or link to generate the export file (i recommend having a button for this because buttons can use the "loading indicator" functionality to show the end user that something is processing), then after the generation is complete, offer them a Document Download Link serving the newly-generated document.
Can I use RecordType in this process.
I'm not sure what you mean. If you want to use RecordType data as the source of a Grid, you can actually enable the internal functionality to provide a one-click download from there. However, to use this you will need to accept the inherent limitations to this approach - namely that you'll have pretty little control over the formatting of the resultant export, etc. What have you tried so far? What are your specific requirements?
I have a readonly grid with below style of data. I have used RecordType to load the data into these columns Name, Email, Phone. Also I have provided "UPDATE" and "DELETE" buttons to perform respective actions on the record.
Now, when I enable "Export to excel" in the read-only grid and try to export the data into an excel, I am also getting "UPDATE" and "DELETE" text in first two columns of excel document.
Now I trying to find if there is any other way I can provide "Export Excel" link and pass on the just required columns from the RecordType.
I suggested you one approach for the same on other post, but now since you don't want to use that OOTB export functionality, you can try what Mike has recommended.
One of the implementation we have done in one of our project is to provide an export to excel button at top right of the grid which kicks a process on click and uses Export DSE to Excel service to generate document, a next screen is displayed to user which shows a confirmation message that your report has been successfully generated and has two options, to download the document or to send it to the user email. Of course it requires more work to be done but is also practical.