Run Snap (The entire website) in sheets

Tutorials (Here's how to...)
,
1

click open link then click run3

2

Cool, but I see a warning that Google hasn't verified your sheet, and I couldn't confirm if this is safe or not. But yours is very exceptional.

3

if you want to confirm feel free to open up the script editor and take a look

4

I'd love to see this, but my school district doesn't allow any Google Docs from outside in.

What are the GS scripts for it?

5

function onOpen() {
var ui = SpreadsheetApp.getUi();
var menu = ui.createMenu('Open Link')
.addItem('Run3', 'test')
.addToUi();
}

function test(){
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var link = sheet.getRange("A1").getValue();
var html = HtmlService.createHtmlOutput('<iframe src="' + link + '" width="1024" height="768"frameborder="0" marginheight="0" marginwidth="0">Loading…')
.setWidth(1024)
.setHeight(800);
SpreadsheetApp.getUi() // Or DocumentApp or SlidesApp or FormApp.
.showModalDialog(html,'Embed');
}

6

when are we collabing

7

I don't know, but I did make something like this myself.

Mine is designed to not need anything in the spreadsheet. You can run it with Snap! $$\to$$ Run.

The Code 
function showHTMLDialog() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

var html = HtmlService.createHtmlOutput('<button onclick="document.getElementById(\'snapeditor\').requestFullscreen()">Fullscreen</button><br><iframe id="snapeditor" src="https://snap.berkeley.edu/snap/snap.html" width="100%" height="80%">')
.setTitle('Snap!')
.setWidth(500)
.setHeight(400);
SpreadsheetApp.getUi().showModalDialog(html, 'Snap!');
}
function SUCCESSOR(x){
return x+1

}

function helpscreen() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

var html = HtmlService.createHtmlOutput('<h1>Todo:</h1><p>Write Help</p>')
.setTitle('Snap!')
.setWidth(500)
.setHeight(400);
SpreadsheetApp.getUi().showModalDialog(html, 'Snap! Help');
}
function onOpen() {
var ui = SpreadsheetApp.getUi();
var menu = ui.createMenu('Snap!')
.addItem('Snap! editor', 'showHTMLDialog')
.addItem('Help', 'helpscreen')
.addToUi();
}
8

i only made it cell A1 so i can change the link easily . also i like your full screen option but your screen size when outside of full screen is messed up.

9

What do you do?

Oh, that makes sense.

10

get rid of the "%" sign and your dimentions should be '1024 by 768' not '500 by 400'

11

When I try this, I see a link in A1
image

when I hover over it I see this
image

and then when I click on the image I just get the Snap! home page opened in another tab

13

you did not follow my instructions

14

The project requests authorization to services completely unrelated to Snap or the workbook. :thinking:

15

its google and is related to snap

16

i posted the code earlier

17

cant even run it

18

why

19

I can't open the sheet since I'm using a school chromebook, I'll open the sheet at home.

20

Wait a minute, it's just a link. A link to Snap!.

21

no. you did not read my instructions