![]() Its the long string of characters & numbers. You can get the sheet id by looking at the web link of your Google sheet in your browser. You can set a choice for the dropdown list items by referencing the Google sheet cell range that the form is linked to or any other sheet by referencing the Google sheet id & sheet name where your dropdown choices are located. getCell(1,1) in this code returns the cell at B2, B2 The row and column here are relative to the range This piece of code is referencing an active sheet but you can modify the code to get cell ranges by referencing the sheet id instead var ss = SpreadsheetApp.getActiveSpreadsheet() Instead of typing in the actual choices into this bracketed part of the script like the code sample above (cats) - use a cell & column range instead (4,3) that points to data range on the sheet where your dynamic dropdown choices are located, like this here. ![]() Sample code: var item = form.addListItem() Unfortunately this is a direct copy paste of the codes from ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |