background preloader

Status Tracking with Google Sheets

Facebook Twitter

Nadh198. WAVE Report. StylesNo StylesContrast Summary WAVE has detected the following: ?

WAVE Report

Errors ? Alerts ? Features ? Panel Options DETAILS: A listing of all the WAVE icons in your page. Information, Guidance and Training on the Americans with Disabilities Act. ADA Title II Technical Assistance Manual. Covering State and Local Government Programs and Services Introduction This technical assistance manual addresses the requirements of title II of the Americans with Disabilities Act, which applies to the operations of State and local governments.

ADA Title II Technical Assistance Manual

It is one of a series of publications issued by Federal agencies under section 506 of the ADA to assist individuals and entities in understanding their rights and duties under the Act. This manual is part of a broader program of technical assistance conducted by the Department of Justice to promote voluntary compliance with the requirements not only of title II, but also of title III of the ADA, which applies to public accommodations, commercial facilities, and private entities offering certain examinations and courses. The purpose of this technical assistance manual is to present the ADA's requirements for State and local governments in a format that will be useful to the widest possible audience. Contents II-1.1000 General. II-2.1000 General.

Privacy & Security. Data replication, backup & recovery Asana uses Amazon’s relational database service (RDS) to manage all user data.

Privacy & Security

The database is replicated synchronously so that we can typically recover from a database failure in a matter of seconds. As an extra precaution, we take regular snapshots of the database and securely move them to a separate data center so that we can restore them elsewhere as needed even in the event of a regional Amazon failure. Learn more about Amazon’s relational database service at Amazon.   Google Developers. Apps Script can connect to external databases through the JDBC service, a wrapper around the standard Java Database Connectivity technology.

  Google Developers

In Apps Script, the JDBC service supports Google Cloud SQL, MySQL, Microsoft SQL Server, and Oracle databases. Setup for Google Cloud SQL Google Cloud SQL lets you create relational databases that live in Google's cloud. Note that, unlike Apps Script, Cloud SQL is not free. Although lightly used databases don't cost much by themselves, Apps Script can only connect to Cloud SQL instances that have a static IP address, which can cost up to $88 per year ($0.01 per hour the connection is idle, as of May 2014). To set up Cloud SQL with Apps Script, follow the steps below. Setup for other databases If you already have your own MySQL, Microsoft SQL Server, or Oracle database, you can connect to it through Apps Script's JDBC service. Note that the JDBC service can only connect to ports 1025 and above.

Apps Script – Google Apps Script. Tutorial: Automating a Help Desk Workflow   Function getColIndexByName(colName) { var sheet = SpreadsheetApp.getActiveSheet(); var numColumns = sheet.getLastColumn(); var row = sheet.getRange(1, 1, 1, numColumns).getValues(); for (i in row[0]) { var name = row[0][i]; if (name == colName) { return parseInt(i) + 1; } } return -1;} function emailStatusUpdates() { var sheet = SpreadsheetApp.getActiveSheet(); var row = sheet.getActiveRange().getRowIndex(); var userEmail = sheet.getRange(row, getColIndexByName("Contact email")).getValue(); var subject = "Helpdesk Ticket #" + row; var body = "We've updated the status of your ticket.

Tutorial: Automating a Help Desk Workflow  

\n\nStatus: " + sheet.getRange(row, getColIndexByName("Status")).getValue(); body += "\n\nNotes: " + sheet.getRange(row, getColIndexByName("Notes")).getValue(); body += "\n\nResolution: " + sheet.getRange(row, getColIndexByName("Resolution")).getValue(); // Create a vertical panel.. var panel = app.createVerticalPanel(); Apps Script – Google Apps Script. Apps Script. Add-ons run inside Google Sheets, Docs, and Forms, but they're built by developers like you.

Apps Script

Our new platform lets you add menu items and sidebars, edit files programmatically, and tie into over a dozen Google services without even spinning up a server. This guide will show you everything you need to publish your first desktop add-on to our store for millions to discover. See what you can make Add-ons are built with Apps Script, a server-side JavaScript platform that requires zero setup. Try a quickstart! View and manage form responses - Docs editors Help. Google Sheets as a Database – Authenticated INSERT with Apps Script using Execution API – MASHe. Making Collaboration Count: A Tool for Tracking and Building Participation in Community Collaboratives and Coalitions by Ashley Anglin, Chris Michael Kirk, and Sharon Johnson-Hakim in GJCPP Volume 6 Issue 2 2015. Download PDF version to access complete tool, including all illustrative figures Introduction: Principles and Practices of Successful Coalitions/Collaboratives Community collaboration and coalition development is a primary focus of the field of Community Psychology (Society for Community Research and Action, 2012).

Making Collaboration Count: A Tool for Tracking and Building Participation in Community Collaboratives and Coalitions by Ashley Anglin, Chris Michael Kirk, and Sharon Johnson-Hakim in GJCPP Volume 6 Issue 2 2015

Example Scorecard - Google Sheets. Create dynamic project plans with Sheets – Google Apps Learning Center. To send emails to your team using a single email address and simplify sharing, set up a Google Groups email list.

Create dynamic project plans with Sheets – Google Apps Learning Center

As you add new people to your groups, they automatically gain access to content you previously shared with the group. Similarly, if you remove someone from a group, that person no longer has access to any content you shared with the group. In Groups, click CREATE GROUPS. Enter a group name and group email address. For group type, select Email list. Spreadsheet CRM: How to Create a Customizable CRM with Google Sheets - The Ultimate Guide to Google Sheets. When VisiCalc came out as the first consumer spreadsheet software in 1979, it brought the number-crunching capabilities of big business to everyone.

Spreadsheet CRM: How to Create a Customizable CRM with Google Sheets - The Ultimate Guide to Google Sheets

It was the first time anyone could harness the power of automated calculations to manage their own data. Spreadsheets gave us the potential to input, modify, and calculate anything we wanted and store it digitally for re-use. You could build anything from run-of-the-mill grocery lists to financial models that feed off of massive data sets—the possibilities seemed endless. Spreadsheets were the original killer app, one of the main reasons you'd want to own a computer. And now, you can use spreadsheets to build your own apps. We'll learn how to do just that in this chapter, by building a full-featured, automated contact management system (or CRM) with just a spreadsheet. Use Form Publisher with new Google Sheets / Google Docs templates - Google Apps Script Examples.