Tina tinaarnoldi

Learning Google Apps Script

The best resource for learning Google Script is the official documentation available at developers.google.com. Here are other places that will help you get up to speed.

Case Studies - Sample Google Script Projects (google.com)
Google Apps Scripts - Snippets by +Amit Agarwal
scoop.it/t/gas by +Martin Hawksey
Awesome Google Scripts by +Amit Agarwal
O'Reilly - Apps Script - by +James Ferreira
Apps Script Webinars - YouTube - by +Eric Koleda and +Arun Nagarajan

	SELECT
	GIFT.CONSTIT_ID, GIFT.Amount, GIFT.DTE, FUND.FUND_ID, RECORDS.FIRST_NAME, RECORDS.LAST_NAME, RECORDS.ORG_NAME, GIFT.REF

	FROM
	RECORDS LEFT OUTER JOIN
	GIFT LEFT OUTER JOIN
	FUND INNER JOIN
	GiftSplit ON FUND.ID = GiftSplit.FundId ON GIFT.ID = GiftSplit.GiftId ON RECORDS.ID = GIFT.CONSTIT_ID

	WHERE (FUND.FUND_ID = 'YOUR PROJECT ID OR FUND ID') AND (GIFT.DTE >= @Date)

	SELECT DISTINCT
	V_GRRPT_PAYMENTS.PayDate AS GrantDate, V_GRRPT_Grants.RecipientName, V_GRRPT_Grants.PayeeName, V_GRRPT_Grants.GrantType,
	V_GRRPT_Grants.GrantStatus, V_GRRPT_Grants.PaymentAmount AS GrantAmount, V_GRRPT_PAYMENTS.PayDate AS DatePaid,
	V_GRRPT_PAYMENTS.TotalAmount AS PaymentAmount, V_GRRPT_PAYMENTS.PayStatus, V_GRRPT_PAYMENTS.CheckNumber, V_GRRPT_PAYMENTS.CheckDate,
	V_GRRPT_PAYMENTS.AdjustmentAmount, V_GRRPT_CCF_GrantCharacteristics_TOPLEVELPROGRAM.TopLevelProgramArea, V_GRRPT_PAYMENTS.FundNumber,
	V_GRRPT_PAYMENTS.FundName, V_GRRPT_PAYMENTS.GrantId

	FROM
	V_GRRPT_CCF_GrantCharacteristics_TOPLEVELPROGRAM RIGHT OUTER JOIN
	V_GRRPT_PAYMENTS ON V_GRRPT_CCF_GrantCharacteristics_TOPLEVELPROGRAM.GrantId = V_GRRPT_PAYMENTS.GrantId LEFT OUTER JOIN

	SELECT DISTINCT
	V_GRRPT_Grants.GrantId, V_GRRPT_Grants.PayDate AS GrantDate, V_GRRPT_Grants.FundNumber, V_GRRPT_Grants.FundName, V_GRRPT_Grants.RecipientName,
	V_GRRPT_Grants.GrantType, V_GRRPT_Grants.GrantStatus, V_GRRPT_Grants.PaymentAmount AS GrantAmount, V_GRRPT_PAYMENTS.PayDate AS DatePaid,
	V_GRRPT_PAYMENTS.TotalAmount AS PaymentAmount, V_GRRPT_PAYMENTS.PayStatus, V_GRRPT_PAYMENTS.CheckNumber, V_GRRPT_PAYMENTS.CheckDate,
	V_GRRPT_PAYMENTS.AdjustmentAmount, V_GRRPT_CCF_GrantCharacteristics_TOPLEVELPROGRAM.TopLevelProgramArea, V_GRQRY_GrantCharacteristics.Name,
	V_GRQRY_GrantCharacteristics.CodeValue AS Expr2

	FROM
	V_GRRPT_Grants INNER JOIN
	V_GRRPT_PAYMENTS ON V_GRRPT_PAYMENTS.GrantId = V_GRRPT_Grants.GrantId LEFT OUTER JOIN

	SELECT

	Grants.GrantId, Grants.PayDate AS GrantDate, Grants.FundNumber, Grants.FundName, Grants.RecipientName, Grants.PayeeName, Grants.GrantType,
	Grants.GrantStatus, Grants.PaymentAmount AS GrantAmount, Payments.PayDate AS DatePaid, Payments.TotalAmount AS PaymentAmount, Payments.PayStatus,
	Payments.CheckNumber, Payments.CheckDate, Payments.AdjustmentAmount, TL.TopLevelProgramArea, Grants.RecipientCity, WS.Email,

	(CASE WHEN Grants.PayDate >= '20050701' AND Grants.PayDate < '20060630' THEN Grants.PaymentAmount ELSE 0 END) AS FY2006,
	(CASE WHEN Grants.PayDate >= '20060701' AND Grants.PayDate < '20070630' THEN Grants.PaymentAmount ELSE 0 END) AS FY2007,
	(CASE WHEN Grants.PayDate >= '20070701' AND Grants.PayDate < '20080630' THEN Grants.PaymentAmount ELSE 0 END) AS FY2008,
	(CASE WHEN Grants.PayDate >= '20080701' AND Grants.PayDate < '20090630' THEN Grants.PaymentAmount ELSE 0 END) AS FY2009,