Google App Script - Display PDF on Form Submit

2019-08-15 02:28发布

站内问答 / 前端开发
712 1 4

I have a current Google Form and App Script where the Apps Script is taking the form data, putting it into a spreadsheet template (which does some calculations) then e-mails that spreadsheet as a PDF.

Is there a way in Google Apps Script to have this PDF displayed in the web browser rather than being sent in an e-mail?

1条回答
Animai°情兽
2楼-- · 2019-08-15 02:56

You can use this workround .

pag.html

<html>
<input type="submit" onclick="downloadPDF()"/>  
<a href="#" id="myDownloadLink" style="display:none">Click here to open</a>

<script>
  function sucess(e) {
   alert(e);
   var downloadLink = document.getElementById("myDownloadLink");  
   downloadLink.href=e;
   downloadLink.style.display = 'block';    
}

function downloadPDF() {
  google.script.run.withFailureHandler(alert).withSuccessHandler(sucess).getFile();
}
</script>
</html>

code.gs

function doGet() {
  return HtmlService.createHtmlOutputFromFile("pag");
}

function getFile() {
  return DriveApp.getFileById("1pczv0kRvgpI87owXWUXTtm4wXXsiG8-ErVWFtv05izI").getUrl();
}
查看更多
0人赞 添加讨论(0) 举报
登录 后发表回答
相关问题
查看全部
相关文章
查看全部
收藏的人(4)