Small expense claims are approved automatically; claims over $500 go to your finance manager.
Uses
Gmail
Google Forms
Google Sheets
Approve expense claims from a Google Form by amount
claim.When someone answers the form. Save it as claim.sheetUrl to blank.financeManager to blank.decision to approved.claim.answers.Amount is greater than 500If claim.answers.Amount is greater than 500Yes
claim.answers["Your name"]'s expense claim of $claim.answers.Amount Save it as review.
Who to ask: financeManager
Prepared by: claim.respondent_emailFrom claim.answers["Your name"]: claim.answers["What was it for?"] ($claim.answers.Amount)decision to review.decision.Change decision to review.decision.No
No steps
sheetUrl. Save it as logged.Google Sheetsclaim.respondent_email. Save it as told.
Subject: Your expense claim was decisionHi claim.answers["Your name"],
Your expense claim of $claim.answers.Amount for claim.answers["What was it for?"] was decision.
Thanks,
FinanceGmail