是否可以通过电子邮件发送表格 [英] Is it possible to email a form

问题描述

我想通过电子邮件将表格发送给客户，以便在浏览器中或理想情况下在rheir电子邮件客户端中进行填写.我创建了一个由id打开的表单，然后使用

I want to email a form to customers to fill out in the browser or ideally in rheir email client . I have created a form opened it by id , then sent it using

function openDialog() {

  // Open a form by ID.
  var form = FormApp.openById('kdhgsdfskfhs');


  var url = form.getPublishedUrl();
  var response = UrlFetchApp.fetch(url);
  var htmlBody = HtmlService.createHtmlOutput(response).getContent();
  MailApp.sendEmail({
    to: '[e-mail]',
    subject: 'hi',
    htmlBody: htmlBody
  });

}

您可以看到我在屏幕截图中输入的结果.我开始认为这在应用程序脚本中不可行.是否有可能 ?如果不是最好的发送方式，是允许用户在电子表格中输入信息?

You can see the result which I have put in screenshot . I'm starting to think that this is not doable in apps script. Is it possible ? if not what is the best way to send allow a user to enter info into a spreadsheet?

推荐答案

可能是电子邮件html.但是我认为您需要一个网站或Web应用程序或在线表单的链接才能将其提交到电子表格.

It's possible email html. But I think your going to need a website or a webapp or a link to the online form to submit it to a spreadsheet.

这篇关于是否可以通过电子邮件发送表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！