Profile cover photo
Profile photo
Martin Mullan (Mart)
187 followers
187 followers
About
Posts

Run copy and share button is not working on my Windows Surface. No problem on Macbook.

Hi all,
I am trying to build a chart of a specific row of data in a Gsheet where col B is the email address based on the active user (education domain). I've used the encoded url directly in the browser and it returns the correct data but my apps script page will not draw the chart.
What am I doing wrong here?
Cheers.

<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawSheetName);

function drawSheetName() {
var user = Session.getActiveUser().getEmail();

//var queryString = encodeURIComponent('SELECT E,F,G,H where B = "' & user & " ');
var queryString = encodeURIComponent('SELECT E,F,G,H where B = "somename@domain"');

var query = new google.visualization.Query(
'https://docs.google.com/spreadsheets/d/KEY/gviz/tq?sheet=Sheet1&headers=1&tq=' + queryString);
query.send(handleSampleDataQueryResponse);
}

function handleSampleDataQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
return;
}

var dataChart1 = response.getDataTable();
var options = {'title':'Chart Name',
'width':400,
'height':300,
legend: {position: 'none'}
};
var chart = new google.visualization.ColumnChart(document.getElementById('chart1_div'));
chart.draw(dataChart1, options);
}
</script>

Any idea when the Migrator will be released to transform Classic to New Sites?

Is it possible to use the The Classroom API--or any other method--to retrieve all of the private comments I share with my students. I like to have the feedback I give in a spreadsheet/markbook so that I can see what I said and how they responded.

Protecting Sheets.
I have a list of sheet keys and am looping through to set protection to a sheet:

for(n=0;n<=sheetKeys.length-1;++n){
var sheetToProtect = SpreadsheetApp.openById(sheetKeys[n][1]).getSheetByName("Student Data");
var protection = sheetToProtect.protect().setDescription('Student Data Protection');

// I can't get the array to work :(
//var canEdits = new Array("myemail@mail.com", "anotheremail@mail.com", "adifferentemail@mail.com");
//for (var x = 0; x < canEdits.length; x++) {
//protection.addEditors(canEdit(x));

protection.addEditor("myemail@mail.com");
protection.removeEditors(protection.getEditors());
if (protection.canDomainEdit()) {
protection.setDomainEdit(false);
}

}

This works...but I can only make it set protection for me...the array won't work. How is this written to set more than one editor?
Cheers.

I've written a html scriptlet that is pulling date times from a GSheet - they present like this: Fri Mar 16 2018 00:00:00 GMT+0800 (HKT)

I am trying to format those dates but I am failing with style. Can anyone help me format the value to give the basic date and time in dd-mm-yyyy hh:mm, no time zones?

The variable pulling the dates looks like this:

<td><?!= data[i][2] ?></td>

Post has attachment
I have recently come across the same problem that is described here: https://productforums.google.com/forum/#!topic/docs/-MzymBo6FKE

I have a department folder shared with me that I create a doc in. When I am finished I change ownership to the department account. This results in the doc being labelled to appear in the folder it is supposed to in the department account but it also appears in the My Drive of that account too.

Other than using the details for each file and removing the label manually, is there a way to disable this or remove the duplicate labels in a faster way?

My students use GSlides as digital exercise books preferring the slide format and ease of design over GDocs. I use a lot of GQuizzes and have, in the past, created GDoc feedback on answers they got incorrect...similar to what Flubaroo does. Since my students use GSlides, I want to give the feedback on incorrect answers as Slides so they can slot them into their work as evidence and items for improvement.
Could one of you fine coder types help with the Slides API?

- onFormSubmit check for incorrect answers in the FormResponse
- if any incorrect, create new slide deck entitled with quiz name and the total score out of questions (and/or percentage) in specified Teacher folder
- for each incorrect answer, create a slide, add question (including images or other media, add incorrect responses, add correct responses and feedback.
- Share with Quiz submitter.

Should be easy enough...LOL! ;-P

Post has attachment
Any idea as to how well the sites migration tool will transform a classic site to a new site?

I am struggling to get the new Google Forms to auto submit from the prefilled URL. Previously tweaking the url and adding submit=Submit worked but I can't make the new forms do it; is there a way?
Wait while more posts are being loaded