function onOpen() { var menu = SpreadsheetApp.getUi().createMenu('Forms'); menu.addItem('CREATE TEMPLATE', 'createTemplate').addToUi(); menu.addItem('CREATE FORM', 'createForm').addToUi(); menu.addItem('CREATE FORMS', 'createForms').addToUi(); } function createTemplate() { var s = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); s.deleteColumns(17, 8); s.deleteRows(100,900); s.setColumnWidth(1, 110); s.setColumnWidth(2, 400); s.setColumnWidths(3, 16, 110); s.setFrozenColumns(2); s.setFrozenRows(3); s.getRange('A4:A100').setDataValidation(SpreadsheetApp.newDataValidation() .setAllowInvalid(false) .requireValueInList(['ACCEPTANCE', 'CHECKBOX', 'CHECKGRID', 'CHOICE', 'DATE', 'GRID', 'IMAGE1', 'IMAGE2', 'LIST', 'PAGE', 'PARAGRAPH', 'SCALE', 'SECTION', 'TEXT', 'TIME', 'VIDEO'], true) .build()); s.getRange('A1:A100').setFontWeight('bold').setHorizontalAlignment('center'); s.getRange('A1').setValue('JUDUL'); s.getRange('A2').setValue('DESKRIPSI'); s.getRange('A3').setValue('TYPE'); s.getRange('C1').setValue('FOLDER ID:').setFontWeight('bold').setHorizontalAlignment('right'); s.getRange('E1').setValue('PUBLIC URL:').setFontWeight('bold').setHorizontalAlignment('right'); s.getRange('G1').setValue('COPY FORM:').setFontWeight('bold').setHorizontalAlignment('right'); s.getRange('H1').setDataValidation(SpreadsheetApp.newDataValidation().setAllowInvalid(false).requireValueInList(['YES'], true).build()); s.getRange('I1').setValue('LINK COPY:').setFontWeight('bold').setHorizontalAlignment('right'); s.getRange('B3').setValue('PERTANYAAN').setFontWeight('bold').setHorizontalAlignment('center'); s.getRange('C3').setValue('PETUNJUK').setFontWeight('bold').setBackground('#f8f8ff').setHorizontalAlignment('center'); s.getRange('D3').setValue('POINTS').setFontWeight('bold').setBackground('#fafad2').setHorizontalAlignment('center'); s.getRange('E3').setValue('TEXT TRUE').setFontWeight('bold').setBackground('#e6e6fa').setHorizontalAlignment('center'); s.getRange('F3').setValue('TEXT FALSE').setFontWeight('bold').setBackground('#e6e6fa').setHorizontalAlignment('center'); s.getRange('G3').setValue('LINK').setFontWeight('bold').setBackground('#fffacd').setHorizontalAlignment('center'); s.getRange('H3').setValue('NAMA LINK').setFontWeight('bold').setBackground('#fffacd').setHorizontalAlignment('center'); s.getRange('I3:R3').setValue('OPSI').setFontWeight('bold').setBackground('#f5f5dc').setHorizontalAlignment('center'); s.getRange('E4:H100').setBackground('#eed5d5'); s.getRange('I4:R100').setBackground('#f3e9f3'); s.getRange('C4:C100').setBackground('#f8f8ff'); s.getRange('D4:D100').setBackground('#fafad2'); }; function createForm() { var s = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); body(s); } function createForms() { var sh = SpreadsheetApp.getActiveSpreadsheet().getSheets(); for (var k=0; k

Google Sheets