This recipe sets up an approval flow for expenses. When someone submits an expense, Tape puts it in review. Expenses over the limit go to a manager, and everything else is approved right away. It's meant to save your finance team from checking every small expense by hand.
What you'll need
An
Expensesdatabase app with these fields:Expense, a text field with the titleAmount, a number fieldStatus, a status field with the optionsSubmitted,In review, andApprovedProcessed on, a date fieldApprover, a person fieldApproval note, a text fieldFollow-up task, a relation field to theTasksdatabase appA
Tasksdatabase app withTitle,Status(withTo do),Due date, andPriority(withHigh).
Build the automation
Open the
Expensesapp and click the automations icon at the top right (Create and view automations).Select
New automation, then selectWhen a record is updated.In the trigger, select the field name and choose
StatusunderFIELDS.Under
And if the following conditions are met, selectAdd filter. PickStatus, thenHas changed to, thenSubmitted.Select
Add action→Update record. The action readsUpdate the current record. SelectAdd fieldfor each of these, usingSet option,Set date, andSet person: -Status:In review-Processed on:Current date-Approver: the manager who approves large expensesSelect
Add action→Conditional actions. UnderIf the following conditions are met, selectAdd filter, pickAmount, then>and enter5000.Inside the condition, select
Add action→Update record. Add the fieldApproval note, selectSet value, and enter "Over limit: " followed by theAmountfield and " needs approval".Select
Add action→Create record. Choose theTasksapp and add these fields: -Title: "Approve expense: " followed by theExpensefield -Status:To do-Due date:Set date→Current date, then+2 Days. For 9:00 AM, selectAdd fieldagain, chooseDue date / Time, thenSet time→Exact time-Priority:HighSelect
Add action→Send email. InTo, insertApproverand its email. InSubject, enter "Approval needed: " and insertExpense. SelectShow moreand write the message, for example "Hi " followed by the approver's name, then the expense and amount. SelectShow previewto check it.Select
Add action→Update recordagain. Add the fieldFollow-up task, selectSet record(orSet recordsif the field allows several records), and chooseCreated record.Select
Add action→Add comment. Enter "Over the $5,000 limit. ", mention theApprover, and add "please review and approve."Next to
Else if conditions are not met, selectAdd action→Update record. SetStatustoApprovedandApproval noteto "Within limit: auto-approved".Select
Create automation.
Note:
Order matters. Create the task before you link it.
Created recordonly exists after theCreate recordaction ran.Emails are real.
Send an emailsends a real email on every matching run. Test with your own address as the approver.
The result
Set the Status of an expense to Submitted. If the amount is $5,000 or less, the status becomes Approved and the note says "Within limit: auto-approved". If it's more, the status is In review, the approver gets an email, a High priority task appears in Tasks with a due date two days out, the expense links to that task, and a comment mentions the approver.
Variations
Change the limit by editing the number in the condition.
Add a second
Conditional actionsstep for travel expenses with a different approver.Add a
Send emailstep to theElse if conditions are not metbranch to tell the submitter their expense is approved.
Learn more
FAQs
Can I use an automation to approve expenses in several steps?
Can I use an automation to approve expenses in several steps?
Yes! Start a second automation from a status change, or use Call automation to hand the record to another one. Learn more about calling automations →
Why did the automation run but the task wasn't linked?
Why did the automation run but the task wasn't linked?
The link step uses Created record, which only exists after Create record ran in the same run. Check that the link step comes after the task step.
Are you a developer using the Tape API for automations?
Are you a developer using the Tape API for automations?
The automation API has its own documentation for developers. Full reference: conditional in the developer docs →
Still have questions? Find answers and get help from community experts in the Tape community →
