Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
function createDynamicQuiz() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var data = sheet.getDataRange().getValues(); var form = FormApp.create('NotebookLM Dynamic Quiz'); form.setIsQuiz(true); for (var i = 0; i < data.length; i++) { var row = data[i]; var question = row[0]; var correctAnswer = row[row.length - 1]; // Assumes the last column is the answer var item = form.addMultipleChoiceItem(); item.setTitle(question); var choices = []; // This loop looks at columns B through the second-to-last column for (var j = 1; j < row.length - 1; j++) { if (row[j] !== "" && row[j] !== null) { // Only add if the cell isn't empty var isCorrect = (row[j] == correctAnswer); choices.push(item.createChoice(row[j], isCorrect)); } } item.setChoices(choices).setPoints(1); } Browser.msgBox('Quiz Created Successfully!'); }
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)
