getFormUrl() in google spreadsheet return url only

2019-07-21 21:21发布

问题:

I have two forms linked with one spreadsheet, one sheet for each form. When I run such script

function myFunction() {
  var ss;
  ss = SpreadsheetApp.getActive();
  Logger.log(ss.getFormUrl());
}

I will see only one url (as life shows url for the second form). Is there any way to get urls for all linked forms?

回答1:

This functionality is currently missing in the API. There is an existing request on the issue tracker for this here. Star that issue to follow it for the resolution.