Assigned
Status Update
No update yet.
Comments
jp...@google.com
As per
Thanks!
Thanks!
bl...@google.com
Automated by Blunderbuss job workspace-devrel-public-issue-tracker-blunderbuss-autoassigner for config assign for component 191640.
ad...@redvespa.com
Hi,
I tried the recommendation but I get this error: Error: TypeError: new_form.publishForm is not a function. Any recommendations?
This is the snippet:
// Open the sheet
var new_sheet = SpreadsheetApp.openById(new_sheet_id);
var new_sheet_url = new_sheet.getUrl();
var new_form_url = new_sheet.getFormUrl();
// Get Form id
var new_form_id = new_form_url.match(/[-\w]{25,}/)[0];
Logger.log("Form new form ID: " + new_form_id);
// Open the form
var new_form = FormApp.openById(new_form_id);
Logger.log("Form new form: " + new_form);
// Check if form is published (Hypothetical method)
if (!new_form.isPublished()) {
Logger.log("Form is not published. Publishing...");
// Publish the form (Hypothetical method)
// Assuming a default publish type, or if you need to specify:
new_form.publishForm({publishAccessType: DriveApp.Access.ANYONE_WITH_LINK});
I tried the recommendation but I get this error: Error: TypeError: new_form.publishForm is not a function. Any recommendations?
This is the snippet:
// Open the sheet
var new_sheet = SpreadsheetApp.openById(new_sheet_id);
var new_sheet_url = new_sheet.getUrl();
var new_form_url = new_sheet.getFormUrl();
// Get Form id
var new_form_id = new_form_url.match(/[-\w]{25,}/)[0];
Logger.log("Form new form ID: " + new_form_id);
// Open the form
var new_form = FormApp.openById(new_form_id);
Logger.log("Form new form: " + new_form);
// Check if form is published (Hypothetical method)
if (!new_form.isPublished()) {
Logger.log("Form is not published. Publishing...");
// Publish the form (Hypothetical method)
// Assuming a default publish type, or if you need to specify:
new_form.publishForm({publishAccessType: DriveApp.Access.ANYONE_WITH_LINK});
sc...@yagisanatode.com
Responding to publishForm is a proposed function (an example) for this feature request. It is not available in the Forms API or FormApp. Please +1 this feature request to add your support to getting this feature request to the Google Developers.
ad...@redvespa.com
Thanks. Have done so. Do you have a workaround to get your forms to publish?
sc...@yagisanatode.com
Unfortunately, there is no workaround. That is why it is important to get this feature request through. Thanks for your support.
ma...@theotcentre.co.uk
Google, what is the point of providing APIs which provide the ability to programatically replicate user actions when you then mandate a user action on a workspace object (ie Publish Form) for it to be useable but don't then make this mandated feature available via the API !
The API needs to provide the facility to Publish a form since this is now a necessary step to making a form useable !!!
This has broken all of our customer facing forms which are managed programmatically.
The API needs to provide the facility to Publish a form since this is now a necessary step to making a form useable !!!
This has broken all of our customer facing forms which are managed programmatically.
Description
Description
FormApp now requires the user to
I am getting complaints from clients who have Forms bound to Sheets that now don't have forms already published and ready to use. This significantly impedes the streamlining of processes because now they cannot expect to just share or, in many cases, automatically/programmatically share the form link and start receiving inputs to the sheet from the form.
Note that
FormApp.getActiveForm().setAcceptingResponses(true)will fail on unpublished forms even though the meaning is similar:Requirement
For the FormApp service to meet the new Publish requirement the developers would need to:
isPublishedcheck published statusgetPublishedAccessTypeView how the form is publish. TheAccessenumsetPublishedAccessTypeSet the published access type.addEmailsToPublishedAccess- When set to 'restricted'removeEmailsFromPublishedAccess- When set to 'restricted'publishFormPublishes the form param may includesetPublishAccessTypeImpact
All automation workflows that require a completed and published form by the end of the process.