phillipwilhelm

This is related to the blog post: https://medium.com/p/5215c77083e5

phillipwilhelm

Letting Users Running Google Apps Script on Google Spreadsheet without both Authorizing Scopes and Showing Script

This is a sample workaround for letting users running Google Apps Script on Google Spreadsheet without both authorizing the scopes and showing the script.

The flow of this workaround is as follows.

1. Create Web Apps created by Google Apps Script and deploy it as Web Apps. As the returned value, the XML data is returned.
   • Your script can be included in this script.
2. User put a formula of =IMPORTML("WebApps URL", "xpath") to a cell.

phillipwilhelm

function exportSpreadsheet() {
 
  //All requests must include id in the path and a format parameter
  //https://docs.google.com/spreadsheets/d/{SpreadsheetId}/export
 
  //FORMATS WITH NO ADDITIONAL OPTIONS
  //format=xlsx       //excel
  //format=ods        //Open Document Spreadsheet
  //format=zip        //html zipped          
  

phillipwilhelm

/* Grab the values and make them globally available. */
var hoursPerDay = 8;
var hoursPerWeek = hoursPerDay * 5;

/**
 * We calculate the number of hours in a given range.
 */
function SUMTIME(allData) {
  var numHours = 0;
  var numCells = allData.length;

phillipwilhelm

• Navigating a page with jQuery
  • First lets see how we can select items within the DOM
  • Now we can select elements, let's see how to navigate the DOM
    • jQuery Traversing - Ancestors
      • Traversing Up the DOM Tree
        • jQuery parent() Method
        • jQuery parents() Method
        • jQuery parentsUntil() Method
• jQuery Traversing - Descendants

phillipwilhelm

function main() {
  var payload = {"channel": "bing", "reports": []};
  var date = new Date();
  date.setDate(date.getDate() - 1);
  var yesterday = date.toISOString().split('T')[0];

  var rows = AdsApp.campaigns().forDateRange('YESTERDAY').withCondition('Impressions > 0').get();
  while (rows.hasNext()) {
    var campain = rows.next()
    var row = campain.getStats();

phillipwilhelm

Committing Code

General Rules

• Make atomic commits of changes, even across multiple files, in logical units. That is, as much as possible, each commit should be focused on one specific purpose.
• As much as possible, make sure a commit does not contain unnecessary whitespace changes. This can be checked as follows:

$ git diff --check

phillipwilhelm

Branching

Quick Legend

Description, Instructions, Notes

Instance	Branch

phillipwilhelm

<?php

/**
 * Convert date/time format between `date()` and `strftime()`
 *
 * Timezone conversion is done for Unix. Windows users must exchange %z and %Z.
 *
 * Unsupported date formats : S, n, t, L, B, G, u, e, I, P, Z, c, r
 * Unsupported strftime formats : %U, %W, %C, %g, %r, %R, %T, %X, %c, %D, %F, %x
 *

phillipwilhelm

<div class='menu'>
  <svg class ='basket' width="24" height="24" viewBox="0 0 24 24">
  <path d="M17,18C15.89,18 15,18.89 15,20A2,2 0 0,0 17,22A2,2 0 0,0 19,20C19,18.89 18.1,18 17,18M1,2V4H3L6.6,11.59L5.24,14.04C5.09,14.32 5,14.65 5,15A2,2 0 0,0 7,17H19V15H7.42A0.25,0.25 0 0,1 7.17,14.75C7.17,14.7 7.18,14.66 7.2,14.63L8.1,13H15.55C16.3,13 16.96,12.58 17.3,11.97L20.88,5.5C20.95,5.34 21,5.17 21,5A1,1 0 0,0 20,4H5.21L4.27,2M7,18C5.89,18 5,18.89 5,20A2,2 0 0,0 7,22A2,2 0 0,0 9,20C9,18.89 8.1,18 7,18Z"></path>
</svg>
  <h1> Local storage basket</h1>
</div>
  <div class = 'menu__container'>

</div>