Breaking News: Grepper is joining You.com. Read the official announcement!

Autofill Options in Google Forms using Google Apps Script

Smoggy Seal answered on June 19, 2023 Popularity 3/10 Helpfulness 1/10

answer Autofill Options in Google Forms using Google Apps Script

Autofill Options in Google Forms using Google Apps Script

Comment

const sheet_ID = "1zNrOZZbHIrO6L15ntStoBkBHfkAe01lpP3rGXwRFBp0";
const form_ID = "1avhXYR_BprUM3tg-Jy5IEVzQZfjBar-Jqezbxkc4dh8";
const data = SpreadsheetApp.openById(sheet_ID).getSheetByName("Sheet1");
const form = FormApp.openById(form_ID);

function main(){
    
    const startRowIndex = 1 
    const startColumnIndex = 1
    const amountOfRowsToUse = 1
    const lastColumn = data.getLastColumn()
    const labels = data.getRange(startRowIndex, startColumnIndex, amountOfRowsToUse, lastColumn).getValues()[0];
    const startColIndex = 2
    const lastRowIndex = data.getLastRow()-1
    const lastColumnIndex = 1
    labels.forEach((label, i) => {
        const startRowIndex = i +1
        const options = data.getRange(startColIndex, startRowIndex, lastRowIndex, lastColumnIndex).getValues()
        updateDropdownTitle(label,options)
})


}


function updateDropdownTitle(title,values){
    const items = form.getItems();
    const titles = items.map(item => item.getTitle())
    const pos = titles.indexOf(title);
    const item = items[pos];
    const itemID = item.getId();
    updateDropdown(itemID,values);
}

function updateDropdown(id,values){
  const item = form.getItemById(id);
  item.asMultipleChoiceItem().setChoiceValues(values);

}

Popularity 3/10 Helpfulness 1/10 Language whatever

Source: form-publisher.com

Tags: autofill google-apps-script google-forms using whatever

Link to this answer
Share Copy Link

Contributed on Jun 19 2023

Smoggy Seal

0 Answers Avg Quality 2/10

Autofill Options in Google Forms using Google Apps Script

Contents

More Related Answers

Autofill Options in Google Forms using Google Apps Script

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.