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.

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

tinaarnoldi

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)

tinaarnoldi

=Fields!FundNumber.Value & " " & Fields!FundName.Value

tinaarnoldi

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

tinaarnoldi

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

tinaarnoldi

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, 

tinaarnoldi

HAVING (Grants.GrantType <> 't')

tinaarnoldi

(Case when grants.paydate >= ‘20050701’ and grants.paydate < ‘20060603’ then grants.paymentamount else 0 red) as FY2006

tinaarnoldi

=DateAdd(DateInterval.Day, -7, (Today))