Google Form - List Drop down dari spreadsheet

 

https://www.youtube.com/watch?v=73tVo_bJPSc

https://www.pelatihanholistik.com/2021/11/11/spreadsheet-google-forms-lebih-detail/

https://www.youtube.com/watch?v=XAUtW6HFwaE

https://www.youtube.com/watch?v=d7avS1wH1TU

https://www.youtube.com/watch?v=dYF7c3yws9A

/**

 * Auto-populate Question options in Google Forms

 * from values in Google Spreadsheet

 *

 * Written by Amit Agarwal (MIT License)

 *

 **/

const populateGoogleForms = () => {

  const GOOGLE_SHEET_NAME = "NAMA SHEET ANDA";

  const GOOGLE_FORM_ID = "ID GOOGLE FORM";

  const ss = SpreadsheetApp.getActiveSpreadsheet();

  const [header, ...data] = ss

    .getSheetByName(GOOGLE_SHEET_NAME)

    .getDataRange()

    .getDisplayValues();

  const choices = {};

  header.forEach((title, i) => {

    choices[title] = data.map((d) => d[i]).filter((e) => e);

  });

  FormApp.openById(GOOGLE_FORM_ID)

    .getItems()

    .map((item) => ({

      item,

      values: choices[item.getTitle()],

    }))

    .filter(({ values }) => values)

    .forEach(({ item, values }) => {

      switch (item.getType()) {

        case FormApp.ItemType.CHECKBOX:

          item.asCheckboxItem().setChoiceValues(values);

          break;

        case FormApp.ItemType.LIST:

          item.asListItem().setChoiceValues(values);

          break;

        case FormApp.ItemType.MULTIPLE_CHOICE:

          item.asMultipleChoiceItem().setChoiceValues(values);

          break;

        default:

        // ignore item

      }

    });

  ss.toast("Google Form Updated !!");

};