Skip to content

Instantly share code, notes, and snippets.

@user52839307

user52839307/Google Form from a Google Sheets document.js

Last active March 12, 2024 15:31
Show Gist options
  • Save user52839307/ccd5462494cb84b9e3fa13e18dd843df to your computer and use it in GitHub Desktop.
Save user52839307/ccd5462494cb84b9e3fa13e18dd843df to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. user52839307 revised this gist Mar 12, 2024. No changes.
  2. user52839307 created this gist Mar 12, 2024.
    13 changes: 13 additions & 0 deletions Google Form from a Google Sheets document.js
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,13 @@
    function createFormFromSheet() {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    var range = sheet.getDataRange();
    var values = range.getValues();
    var headers = values[0]; // Assumes the first row contains headers
    var form = FormApp.create('New Form from Sheet'); // Creates a new form

    headers.forEach(function(header) {
    form.addTextItem().setTitle(header);
    });

    Logger.log('Form created: ' + form.getEditUrl());
    }