Change theme
Help
Press space for more information.
Show links for this issue (Shortcut: i, l)
Copy issue ID
Previous Issue (Shortcut: k)
Next Issue (Shortcut: j)
Sign in to use full features.
Vote: I am impacted
Notification menu
Refresh (Shortcut: Shift+r)
Go home (Shortcut: u)
Use Markdown for this comment
Set severity, which reflects how much the issue affects the use of the product
Change issue status back to 'Assigned'
Pending code changes (auto-populated)
[ID: 1388909]
[ID: 1388852]
[ID: 1388884]
0: low
5: moderate
10: good [ID: 1388853]
[ID: 84481]
processed = processed by automation
triaged = validated by human
blocked = depends on another issue
information_requested = depends on reporter supplying additional information
unblocked = the issue is no longer blocked, but may not be fixed
fixed = a change was submitted but may not be deployed fully [ID: 1245093]
[ID: 1388836]
[ID: 1385984]
Set the version(s) of the product affected by this issue (comma-separated list)
Set the version(s) of the product in which the issue should be fixed (comma-separated list)
Set the version(s) of the product in which the issue fix was verified (comma-separated list)
Set if this issue occurs in production
Tags used for linking issues. [ID: 1172495]
Set Reporter
Set Type
Set priority, which reflects how soon the issue should be fixed
Set Status
Set Assignee
Set Verifier
Remove item
View or edit staffing
View issue level access limits(Press Alt + Right arrow for more information)
Description
#1There is no source field for form submit event created by onFormSubmit() of FormTriggerBuilder in a standalone script.
If a script is bound to a spreadsheet, a source field appears.
However, it does not contain Form object but the Spreadsheet object.
Please provide a small sample script that reliably reproduces the issue.
The sample should run as-is or with minimal setup, without external
dependencies.
function myFunction() {
var form = FormApp.openById("a form id");
ScriptApp.newTrigger("onFormSubmitTest").forForm(form).onFormSubmit().create();
}
function onFormSubmitTest(e){
Logger.log(e);
MailApp.sendEmail("mail address", "report", Logger.getLog());
}
What steps will reproduce the problem?
1. make a form
2. make a standalone blank script, write the above script, and run myFunction to make a trigger for the form
3. respond the form.
What is the expected output? What do you see instead?
Accourding to
the output in mail should be
{response=FormResponse, source=Form, authMode=FULL},
but the actual output in mail is
{response=FormResponse, authMode=FULL}.
What is the project key (found under "File > Project properties")? The
project key does not give the Apps Script team access to your source
code or data. We use it to look up debug information about your script.
MbhzuVtZwb4GCealMFUsrJ68VJNknFO53
Please provide any additional information below.
When I make the same script as one bound to a spreadsheet, source field appears but it contains not the form object but the spreadsheet object.
To subsequent readers: If you are also experiencing this issue, please
click the star next to the issue number. We prioritize issues with the
most stars.