Updating the OSCQR Dashboard Script
Allene Slating
30 steps
Google Chrome
Updating the OSCQR Dashboard Script
An update in June 2026 deprecated a script function, taking away the "OSCQR" option in the toolbar. These straightforward steps will update the script and bring back the dashboard functionality without loosing existing content.
1
Open your OSCQR Dashboard in Google Sheets. This will be a copy from the original shared version. \ \ Click "Extensions" in the toolbar, then "Apps Script".
2
This brings up the script with a notice of the function no longer supported. \ \ Optional: To learn more, you can click "Learn how to migrate to V8" in the warning banner.
3
Navigate to the left panel and gear wheel. In Project Settings (gear wheel), click the box to "Enable Chrome V8 runtime". This is an essential step.
4
Optional 1/4: To confirm in the code that the V8 (selected above it) is running: click "Show "appsscript.json" manifest file in editor"
5
Optional 2/4: After selecting "Show "appsscript.json" manifest file in editor", you can confirm the V8 is running by navigating to the "Editor" (< >) view in the left panel.
6
Optional 3/4 : Select the "appsscript.json" file from the sidebar.
7
Optional 4/4: Confirm the bottom code states "runtimeVerison": "V8"
Refresh & Authorize
8
Return to your Dashboard and reload the page to apply changes. You will now see OSCQR in the toolbar, but still need to make additional updates.
9
At this point or later, you may be prompted to authorized Google to access: Click "OK" to begin the process. (More screenshots are detailed in later steps: [Google Authorization](https://scribehow.com/viewer/Updating_the_OSCQR_Dashboard_Script__Ckg1CuGOQJSnEvPxN2_sZA?scrollToActionId=d69f3a5e))\ \ Then return to complete additional updates.
Additional code updates
10
Navigate back to the App Script in Extensions
11
Navigate to the code (< >) section of the left panel.
12
Click within the code window. Press [[Ctrl]] + [[F]] to:\ \ Find: **.equals** Replace with: **===** There will be several instances. Click the floppy disk icon to save once replaced.
Refresh & Delete Triggers
13
Click "Triggers" in the left panel
14
For the "updatePercentages" trigger: Click the pencil next to "Edit Trigger"
15
No changes are needed (unless desired). Click "Save" to refresh.
16
For the "getAccessibilityData" and "getDesignData" triggers: click the three dots and choose "Delete". This eliminates any related error notifications.
Google Authorization
17
Return to the Dashboard and refresh. In the OSCQR menu: Choose "Options"
18
The options are defaulted to OFF. No changes are needed unless desired. Click "Submit"
19
If you haven't already authorized Google: Click "OK" to begin the script authorization process.
20
Complete the Google OAuth authorization flow to grant the script necessary permissions. Starting with "Advanced"
21
Click "Go to OS4 - Dashboard - v4.0.0 - SEED (unsafe)"
22
Click "Continue"
23
Select "All" (if not already enabled) to allow access. Click "Continue"
Rubric Test
24
Run the script by "Add a course rubric"
25
Fill in the course details in the generation modal and click "Submit". It will take a moment to generate.
26
Your new rubric should now be listed in the Dashboard. Click the generated rubric link within the spreadsheet to open and test.
27
Click "Allow access" in the yellow banner to enable rubric formulas and the RSI icon.
28
Fill out a section in the Instructional Designer tab to test.
Dashboard Synchronization
29
Return to the Dashboard. Open the OSCQR menu and select "Update percentages/comments for all courses" to sync the dashboard.
30
Your Dashboard should now reflect the rubric test and retain the OSCQR script functionality.
Updating the OSCQR Dashboard Script
Allene Slating
30 steps
Google Chrome
Updating the OSCQR Dashboard Script
An update in June 2026 deprecated a script function, taking away the "OSCQR" option in the toolbar. These straightforward steps will update the script and bring back the dashboard functionality without loosing existing content.
1
Open your OSCQR Dashboard in Google Sheets. This will be a copy from the original shared version. \ \ Click "Extensions" in the toolbar, then "Apps Script".
2
This brings up the script with a notice of the function no longer supported. \ \ Optional: To learn more, you can click "Learn how to migrate to V8" in the warning banner.
3
Navigate to the left panel and gear wheel. In Project Settings (gear wheel), click the box to "Enable Chrome V8 runtime". This is an essential step.
4
Optional 1/4: To confirm in the code that the V8 (selected above it) is running: click "Show "appsscript.json" manifest file in editor"
5
Optional 2/4: After selecting "Show "appsscript.json" manifest file in editor", you can confirm the V8 is running by navigating to the "Editor" (< >) view in the left panel.
6
Optional 3/4 : Select the "appsscript.json" file from the sidebar.
7
Optional 4/4: Confirm the bottom code states "runtimeVerison": "V8"
Refresh & Authorize
8
Return to your Dashboard and reload the page to apply changes. You will now see OSCQR in the toolbar, but still need to make additional updates.
9
At this point or later, you may be prompted to authorized Google to access: Click "OK" to begin the process. (More screenshots are detailed in later steps: [Google Authorization](https://scribehow.com/viewer/Updating_the_OSCQR_Dashboard_Script__Ckg1CuGOQJSnEvPxN2_sZA?scrollToActionId=d69f3a5e))\ \ Then return to complete additional updates.
Additional code updates
10
Navigate back to the App Script in Extensions
11
Navigate to the code (< >) section of the left panel.
12
Click within the code window. Press [[Ctrl]] + [[F]] to:\ \ Find: **.equals** Replace with: **===** There will be several instances. Click the floppy disk icon to save once replaced.
Refresh & Delete Triggers
13
Click "Triggers" in the left panel
14
For the "updatePercentages" trigger: Click the pencil next to "Edit Trigger"
15
No changes are needed (unless desired). Click "Save" to refresh.
16
For the "getAccessibilityData" and "getDesignData" triggers: click the three dots and choose "Delete". This eliminates any related error notifications.
Google Authorization
17
Return to the Dashboard and refresh. In the OSCQR menu: Choose "Options"
18
The options are defaulted to OFF. No changes are needed unless desired. Click "Submit"
19
If you haven't already authorized Google: Click "OK" to begin the script authorization process.
20
Complete the Google OAuth authorization flow to grant the script necessary permissions. Starting with "Advanced"
21
Click "Go to OS4 - Dashboard - v4.0.0 - SEED (unsafe)"
22
Click "Continue"
23
Select "All" (if not already enabled) to allow access. Click "Continue"
Rubric Test
24
Run the script by "Add a course rubric"
25
Fill in the course details in the generation modal and click "Submit". It will take a moment to generate.
26
Your new rubric should now be listed in the Dashboard. Click the generated rubric link within the spreadsheet to open and test.
27
Click "Allow access" in the yellow banner to enable rubric formulas and the RSI icon.
28
Fill out a section in the Instructional Designer tab to test.
Dashboard Synchronization
29
Return to the Dashboard. Open the OSCQR menu and select "Update percentages/comments for all courses" to sync the dashboard.
30
Your Dashboard should now reflect the rubric test and retain the OSCQR script functionality.
