Single click document generation and download

Question

Hi Experts, 
 
 Is there any way to generate and download an Excel file in a single click. 
 
 Thanks, 
 Gaurav Singh

Mike Schmitt · Answer

Vaithyanathan Raju said: I need to create and download the file in single click. 
 Is it really a "need", or a "want"? 
 the functionality is the same as it was almost 3 years ago when i wrote my original reply, so my same answer still applies.

Mike Schmitt · Answer

All supported methods I know of at this point will require 2 clicks - one to initialize the document generation and (automatically) display a link, then a second click by the user to actually download. There was an older plug-in that would create an excel from a datasubset and instantly try to download, but it was really finnicky and as far as I've heard, it no longer works in modern versions of Appian.

Peter Lewis · Answer

You can use a Web API to generate a CSV file and it can use a GET instead of a POST. Just create a Web API, use the CSV template, and make sure you separate all your fields with a common (it's usually easiest to use the joinarray() function to do that). 
 Then, call your Web API in a safelink and you should be good to go. 
 The other thing to consider if you truly need it to be one click is to pre-generate your document. If the data doesn't change that frequently or if you're okay with it not being completely current, you could run a process that runs on a schedule and generates the document for you. Then, in your UI just reference the document in a document download link.

Single click document generation and download

Top Replies