Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var formUrl = "https://docs.google.com/forms/d/1lNsJIzQsm09Hp5Is9jHE3CwrXWW9IdwX666HIoSOWG8/edit";
- function main() {
- let wsData = SpreadsheetApp.getActive().getSheetByName("Клиент");
- let form = FormApp.openByUrl(formUrl);
- let formItems = form.getItems();
- let data = wsData.getDataRange().getValues();
- for (x in data[0]) {
- let header = data[0][x];
- Logger.log(header);
- let formFilter = formItems.filter(g => g.getTitle() == header)
- if (formFilter.length) {
- let v = data.map(col => col[x]).slice(1).filter(t => t);
- Logger.log(v);
- form.getItemById(formFilter[0].getId()).asMultipleChoiceItem().setChoiceValues(v)
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement