background preloader

Google Scripts

Facebook Twitter

Creating a Standard Data Layer for the Tag Management Industry. It’s been an exciting few months for Google Tag Manager.

Creating a Standard Data Layer for the Tag Management Industry

As referenced in our previous post this morning, Google Tag Manager is now serving twice the amount of traffic it was in April 2013 and we have been steadily adding features. Recently, at Google I/O, we announced that Google Tag Manager will also work with mobile applications. This week, a consortium of companies, including IBM, Accenture and more, along with the W3C, announced they are collaborating to create a standard Data Layer. The data layer is a core component of Google Tag Manager and a common way for all businesses to implement tag management tools. It’s a standard way to format data within a web page. It's typically used in two ways: 1. to store data and provide a clear separation between the data and presentation layer of the page and 2. to store data when some type of user activity occurs.

Through the W3C community group we’re supporting the effort to standardize the format and syntax of the data layer. Quick Start Guide - Google Tag Manager. Utilisez la base de données ScriptDB de Google Apps Script. Google lors de sa conférence Google I/O a annoncé l'arrivée d'une base de données dans les script.

Utilisez la base de données ScriptDB de Google Apps Script

C'est la Class ScriptDB, on peut ainsi s'affranchir des spreadsheet pour stocker des données. Voici quelques éléments pour se lancer avec ScriptDB. Remplir sa base de données Google fournit un script dans la page de présentation pour ajouter les données d'une spreadsheet à la base de données en automatique. Petite précaution avant de lancer l'import, il faut que les titres de vos colonnes ne contiennent pas d'espaces. Donc si votre colonne se nomme "prix produits" il faut la transformer en "prixproduits" ou PrixProduits" par exemple. Si vous voulez garder la première ligne de ce code voici la fonction pour ajouter l'id de la spreadsheet en tant que variable du projet: Créer une alerte sur Le bon coin. Les triggers pour les scripts dans google spreadsheet.

Performance et Simplicité du SI: Un diagramme de Gantt dans un Google Site. Douglas Crockford: Theory of the DOM (1 of 3) - Video by Luis Merino - Online Campus powered by Sclipo. Drive SDK. The Google Drive UI provides two ways to open files: The Open with contextual menu itemThe Google Picker dialog for opening files To see what these UI features look like, check the overview of What Can You Do with the Drive platform?.

Drive SDK

The rest of this page describes how to integrate your app with these Drive UI features to open files stored in Google Drive. When a user chooses files in Google Drive and selects the Open with menu option, Drive redirects the user to the Open URL for the selected application (this URL is defined when you enable the Drive platform). The redirected request from the user's browser contains this important information in the state parameter: The ID of the file(s) to open.The action, set to open.The userId of the authenticated user. You'll need the file ID to fetch file metadata and download file content. The following example illustrates how to load state information using the supported client libraries. Java Python Parse and load the JSON state parameter. if (! Ruby. Using the Google Picker to upload files to Drive.

The Google Picker API provides developers with an easy-to-use file dialog that can be used to open Google Drive files directly from their web app independently of the Drive UI.

Using the Google Picker to upload files to Drive

The Drive SDK documentation includes an example showing how to incorporate the Google Picker with just a few lines of JavaScript. Another powerful use case for the Picker API is to allow users to upload files to Drive with the same consistent UI. A single Picker dialog can incorporate multiple views and users can switch from one to another by clicking on a tab on the left: The following code sample opens the Picker dialog and registers a simple callback function to handle the completed upload event: There is an important difference between this upload example and the code used to open files: in addition to the standard view, an instance of DocsUploadView is added to the Picker object, thus providing upload capability.

Insider Tips for Using Apps Script and Spreadsheets. My role in Google Docs is to help manage many projects across Google Docs/Drive.

Insider Tips for Using Apps Script and Spreadsheets

As a part of my job, I ask for a fair amount of data from all of those teams and generate reports on project/feature status. To make this much simpler for everyone involved, I have created a lot of simple tools using Google Spreadsheets and Apps Script (as well as a lot of complex tools) that make it easier for collaborators to enter data and for me to collect that data and create reports. Below is a pair of foundational techniques that I include in nearly every Spreadsheet/Apps Script tool I build. Load Settings From a Configuration Sheet I have a dozens of scripts generating reports. With a globally accessible array, globals, you can then load the “settings” from the configuration (sheet SHT_CONFIG, here) at any entrypoint to the script. The LoadGlobals function, below, parses the data in the first three columns of the workbook and sheet name passed to it.

Tableau de bord Google Apps Script. Google Apps Script Tutoriel: Comment faire pour créer une interface utilisateur en utilisant Apps Script. Google JavaScript Style Guide. We follow the C++ formatting rules in spirit, with the following additional clarifications.

Google JavaScript Style Guide

Curly Braces Because of implicit semicolon insertion, always start your curly braces on the same line as whatever they're opening. For example: if (something) { // ... } else { // ... } Array and Object Initializers Single-line array and object initializers are allowed when they fit on a line: Multiline array initializers and object initializers are indented 2 spaces, with the braces on their own line, just like blocks. Long identifiers or values present problems for aligned initialization lists, so always prefer non-aligned initialization. Liens scripts feuille de calcul. Mastering Javascript Arrays. Filed: Sun, Mar 25 2007 under Programming|| Tags: reference arrays javascript stacks queues ajax Mastering Javascript Arrays Believe it or not, the very first version of Javascript shipped without Arrays.

Mastering Javascript Arrays

Tout [Tutoriaux javascript et PHP] - Scripts, Tutoriaux, Forums pour webmasters et développeurs. Fonction : isNaN() - Référence Tout JavaScript. JavaScript: Des fondamentaux aux concepts avancés (bibliothèques Prototype ... - Emmanuel Gutierrez. Javascript - Page 1. How to create UI using Apps Script. Introducing the Script Service. Triggers in Apps Script allow you to schedule your script’s execution in response to an event, at a specific time and date, or at given time intervals.

Introducing the Script Service

Publishing scripts as services allows you to deploy your web apps with a click of a button. The new Script service lets you perform both of these tasks programmatically. With the Script service at your disposal, you can create smooth install flows, chain your scripts’ executions, generate summaries of current triggers, and even programmatically publish the scripts as services. Create smooth install flows. Script Class Contacts. Je ne vais pas détailler toute la classe Contact mais donner quelques astuces qui m'ont manquées quand j'ai voulu l'utiliser.

script Class Contacts

Cela s'adresse à des personnes comme moi qui savent faire des scripts mais ne sont pas des purs développeur. Grading Made Easy using Apps Script. Grading Made Easy using Apps Script. Repost from Google Apps Developer Blog.

Grading Made Easy using Apps Script

Editor's Note: Guest author Dave Abouav is a Google employee who is a part-time instructor for a night class in physics. He created Flubaroo as a 20% time project at Google based on his own teaching experiences. As an instructor for a night class in physics at De Anza Community College, I didn't have enough time to grade assignments. Script : Facturation. Générer un pdf à partir d'un formulaire Google Spreadsheet. Google Spreadsheet Programming With JavaScript: Using the Google App Scripting API - Part 1. Google Spreadsheet Programming With JavaScript: Using the Google App Scripting API - Part 2. Overview - Welcome to Flubaroo. The grades created by Flubaroo will be located in an adjacent worksheet called "Grades", as shown: For each submission, Flubaroo will show which questions were answered correctly ("1" point"), which incorrectly ("0" points), and which were not graded.

If less than 60% of students got a question correct, the question will be highlighted in orange to alert you. Additionally, students who scored less than 70% on the assignment will be highlighted in red. The Flubaroo menu will now offer you the ability to email each student their grades, view a summary report, or regrade the assignment. You might want to regrade the assignment if more students submitted answers, or if you want to throw out a question that most students got wrong. If you choose to email each student their grade, you'll be given the option to include an answer key in the email. Choosing "View Report" shows you a summary report of the grading. Happy New Year - New Features in Flubaroo!! - Welcome to Flubaroo. How to Upgrade: If you have a spreadsheet in which you've never installed Flubaroo before, just install it from the Google Script Gallery as usual (Insert -> Script).

If you have a spreadsheet that already has Flubaroo installed, then you'll need to first remove the old version of Flubaroo before upgrading. Failing to do so can cause problems. Fusion Table Google. Google Apps Script.

  1. bouche42 Feb 23 2012
    Si on est patient, on a tout intérêt à suivre le tutorial, niveau par niveau. Moi qui suis plutôt impatient, je ne peux m'empêcher de voir ce que font les vrais gens, puis je reviens sur le tutorial. Au passage je Pearle tout ce qui me semble utile d'approfondir ou découvrir.