Apps Script Tutorial. Google Apps Script JISC CETIS MASHe. From the postbag Marjolein Hoekstra (CleverClogs) writes: Short description Can you make a Google Script for me that compares two strings character by character? If differences are found, the script should point these out. If no differences are found at all, the script should put out the text "[ id. ]" . Detailed description I have two columns containing lists of horizontally identical, but sometimes almost identical text strings. I'd like to compare them on a character by character basis, and then point out in the second column at which positions it differs from the first, for example like this: If you compare these two, you'll see that cell B2[3] has 'K' where A2[3] reads 'C'. My envisioned formula would then populate cell C2 with: "[ – – K – – ]" As far as I can tell, I'd need a Google Script that parses both strings character by character and output "–" when they are identical, and output the value of the character string from B2.
Note that LEN (A) is always identical to LEN (B) I'm awarding badges - Google Apps Script integration with Persona and Mozilla Openbadges. I'm finally awarding Mozilla Open Badges through a complete badge environment that handles questions, marking, badge assertion, persona authentication and Mozilla backpack awards. I introduced this in a previous post, but now that I've added the last stage of Persona and Mozilla integration, you can actually move these badges into your openbadges backpack. It ended up being a bit of mashup of various technologies, but the main one is Google Apps Script and ScriptDB to handle the award and badge management, with a jQuery panel that can be embedded in any blog or web page.
Most of the code is in a library, so the amount of code needed to implement your own environment is minimal. Look out for a step by step guide soon. To see how you would earn a badge, click on one of the badges on the below right, and take the associated quiz. Analytics reporting with Google Apps Script at the UK Cabinet Office. Guest author Ashraf Chohan works at the Government Digital Service (GDS), part of the UK Cabinet Office. Originally posted on the Google Apps Developer Blog by Arun Nagarajan. Recently, when we were preparing the launch of GOV.UK, my team was tasked with creating a series of high-level metrics reports which could be quickly compiled and presented to managers without technical or analytical backgrounds. These reports would be sent daily to ministers and senior civil servants of several government departments, with the data customised for each department. We decided to use Adobe InDesign to manage the visual appearance of the reports.
InDesign’s data-merge functionality, which can automatically import external data into the layout, made it easy to create custom departmental reports. In a previous post on this blog, Nick Mihailovski introduced a tool which allows automation of Google Analytics Reporting using Google Apps Script. Below is an example of how a report looks on publication. Google Apps Script | Knoldus.