Routes each purchase request to the right approvers by amount, logs the outcome and tells the requester.

UsesFilloutGmailGoogle Sheets

Approve purchase requests by amount

FilloutFilloutWhen a Fillout form receives a new response. Save it as request.When a Fillout form receives a new response. Save it as request.
ValuesManager's emailSet manager_email to blank.
ValuesFinance approver's emailSet finance_email to blank.
ValuesPurchase logSet purchase_log to blank.
ValuesOutcome of the requestSet outcome to Approved without review.
Decisions & LoopsIf request.answers.Amount is greater than or equal to 1000If request.answers.Amount is greater than or equal to 1000
Yes
ApprovalsAsk the managerRequest approval: Approve request.answers["What do you need"] from request.answers.Vendor for $request.answers.Amount Save it as manager_decision. Who to ask: manager_email Prepared by: request.answers["Your email"]Requested by request.answers["Your email"]
Decisions & LoopsIf manager_decision.approved is noIf manager_decision.approved is no
Yes
ValuesChange outcome to Rejected by manager.Change outcome to Rejected by manager.
Else if @request.answers.Amount is greater than 10000
ApprovalsAsk financeRequest approval: Approve request.answers["What do you need"] from request.answers.Vendor for $request.answers.Amount Save it as finance_decision. Who to ask: finance_email Prepared by: request.answers["Your email"]Requested by request.answers["Your email"]. The manager has approved.
Decisions & LoopsIf finance_decision.approved is yesIf finance_decision.approved is yes
Yes
ValuesChange outcome to Approved by manager and finance.Change outcome to Approved by manager and finance.
No
ValuesChange outcome to Rejected by finance.Change outcome to Rejected by finance.
Otherwise
ValuesChange outcome to Approved by manager.Change outcome to Approved by manager.
No
No steps
Google SheetsLog the requestAdd a row to (not set) in purchase_log. Save it as logged.Google Sheets
GmailTell the requesterSend an email to request.answers["Your email"]. Save it as replied. Subject: Your purchase request: outcomeHi, Your request for request.answers["What do you need"] from request.answers.Vendor ($request.answers.Amount): outcome.Gmail