getFormUrl() in google spreadsheet return url only of last linked form?

Question

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?

Answer 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.

Answer 2

I know that it's an old question, but I'll still add an answer to whom it may concern.

Generally speaking, Form is connected to Sheet, not to Spreadsheet itself. So, one way to get all of the Spreadsheet forms is to go through the Sheets of the Spreadsheets, and get their Form URL, like that:

function getFormsOfSpreadsheet(spreadsheetId) {
  const ss = SpreadsheetApp.openById(spreadsheetId);
  const sheets = ss.getSheets();
  const formsUrls = [];

  for (const sheet of sheets) {
    const formUrl = sheet.getFormUrl();
    // getFormUrl() returns null if no form connected
    if (formUrl) {
      formsUrls.push(formUrl);
    }
  }
  
  return formsUrls;
}

Docs

The other possible way is to get all of the Forms in the Drive or in the Folder, iterate through them to get their destination and compare it to your Spreadsheet ID, like in this answer