rheajt

function replaceLinks() {
  const trainingSheet = SpreadsheetApp.getActive().getSheetByName('Data');
  const trainingRange = trainingSheet.getRange(3, 3, trainingSheet.getLastRow() - 2);
  const values = trainingRange.getValues();
  
  values.forEach(([link], ind) => {
    const matches = /\/([\w-_]{15,})\/(.*?gid=(\d+))?/.exec(link); 
    
    if(!matches) {
      return;

rheajt

function main() {
  // 1. get the courses from the spreadsheet
  const courses = getCoursesFromSpreadsheet();
  
  // 2. create the courses on the classroom
  
  const responses = courses.map((course, ind) => {
    const resource = createCourseResource(course);
    const response = Classroom.Courses.create(resource);
    course[3] = response.alternateLink;

rheajt

function doGet() {
  var html = HtmlService
    .createHtmlOutputFromFile('form')
    .setSandboxMode(HtmlService.SandboxMode.IFRAME)
    .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
  
  return html;
}

function submit(name) {

rheajt

async function main(context: Excel.RequestContext) {
  // Your code here
  const items = context.workbook.names.load('items')
  await context.sync();

  items.items.forEach(item => {
    const lastIndex = item.formula.lastIndexOf('$');

    const main = item.formula.substring(0, lastIndex + 1);
    const split = +item.formula.substring(lastIndex + 1);

rheajt

function onOpen() {
  SlidesApp.getUi().createMenu('Template')
    .addItem('Build template', 'buildTemplate')
    .addToUi();
}

function buildTemplate() {
  var presentation = SlidesApp.getActivePresentation();
  var newPresentation = DriveApp.getFileById(presentation.getId())
    .makeCopy('COPY OF TEMPLATE');

rheajt

function onOpen() {
  SpreadsheetApp.getUi()
  .createMenu('Marking Application')
  .addItem('Open App', 'openApp')
  .addToUi();
}

function openApp() {
  var html = HtmlService.createHtmlOutputFromFile('app');
  

rheajt

Create-React-App with Sass configuration

Here are instructions for add Sass support to an app built with create-react-app. Hopefully this will be redundant when Sass support is built into the tool! Visit their form and let them know you need Sass support.

Install the create-react-app tool from npm. This will be installed globally. We also need to install the loaders needed for webpack, and we will save those as development dependencies.

npm install -g create-react-app

create-react-app your-app-name
cd your-app-name

rheajt

Sample Markdown file

This is going to be a test file for the Office 365 Add-in Tutorial

rheajt

function copyTitles() {

  var folderId = '0Byvt4e0JQrRAMVR2Z0dnZnVhcDA';
  
  var folder = DriveApp.getFolderById(folderId);
  
  var files = folder.getFilesByType(MimeType.GOOGLE_DOCS);
  
  while(files.hasNext()) {
  

rheajt

function gradeBar() {
  var gradeBar = HtmlService
    .createHtmlOutputFromFile('sidebar')
    .setSandboxMode(HtmlService.SandboxMode.IFRAME)
    .setTitle('Grader');
    
  SpreadsheetApp.getUi().showSidebar(gradeBar);
}

function endColumn() {