可以预先分配用户到Google表单？ [英] Possible to pre-assign user to google form?

问题描述

我拥有所有的用户信息，并且已经计算出如何记录这些信息响应。不过，我想将该人的电子邮件添加到表单中的行。

如果有办法，这将是理想的，因为我们已经收集了他们的电子邮件，将此电子邮件在背景中传递给我们发送的表单，并在答复页中附上答案。

谢谢！

解决方案

在我解决问题之前，我无法休息。几乎三年前这篇文章确实有所帮助。

不是如果有人知道如何真正将背景中的信息传递给工作表，那么我仍然打开它。

  var items = formName.getItems（）; 
 var itemOfInterest; 
 for（var i in items）{
 if（items [i] .getTitle（）=='QUESTION_TITLE'）{
 itemOfInterest = items [i]; 
} 
} 
 var preFilledUrl = 
 schedForm.createResponse（）。 
 withItemResponse（itemOfInterest.asTextItem（）。createResponse（email））。 
 toPrefilledUrl（）; 
  

预先填写该问题框，以便用户在发送之前编辑。它会工作。

I am creating a Google Form dynamically, and emailing it, using Google Apps Script.

I have all the users info, and have figured out how to record the response. However, I would like to add that person's email to the row in the sheet.

It would be ideal if there was a way, since we already collected their email, to pass this email in the "background" to the form we send, and it is attached with there answer in the responses sheet.

Thanks!

解决方案

I was not able to rest until I got this worked out. This article from almost three years ago really helped.

Not exactly what I was going for, still open if anyone knows how to actually pass info in the background to a sheet.

var items = formName.getItems();
var itemOfInterest;
for(var i in items){
  if(items[i].getTitle()=='QUESTION_TITLE'){
    itemOfInterest=items[i];
  }
}
var preFilledUrl =
    schedForm.createResponse().
withItemResponse(itemOfInterest.asTextItem().createResponse(email)).
toPrefilledUrl();

This prefills that question box, so also giving the user the ability to edit before they send. It'll work.

这篇关于可以预先分配用户到Google表单？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！