Hi , I have created this "Work Request Approval "in Appsheet. Right now I’am still confused on how to make when Approver has completely approve the request and requestor will received notification some kind of receipt so they know their request has been approved or declined in email or other?
What should I do here ?
Hello @syamir, Welcome to the community!
To implement this, you will need to set up an Automation (Bot) inside AppSheet. This bot will watch your data table, detect when the status changes to “Approved” or “Declined,” and automatically trigger an email or push notification to the requestor.
Verify your Data Schema:
Ensure your data table has a Status column (Text or Enum with values like Pending, Approved, Declined) and a Requestor Email column (Email type) so AppSheet knows where to send the message.
Create a New Automation Bot:
Step 1- Navigate to Automation in the left menu, click “+” (Create a new automation), and select Create a new bot. You can name it “Send Status Notification.”
Configure the Event Trigger:
Step 2- Set up the event to monitor your specific data table by clicking on “Configure event”. Set the Data Change Type to Updates only (or Adds and Updates if it can be approved instantly).
Add a Condition to ensure the notification only fires when the final decision is made:
AND(ISNOTBLANK([Status]), OR([Status] = “Approved”, [Status] = “Declined”), [_THISROW_BEFORE].[Status] <> [Status])
Create the Email Action:
Step 3- Add a step to the bot called Run a Task and choose Send an email
To: Set this as a formula pointing to your requestor email column: [Requestor Email]
Subject: Use an expression like: "Work Request Update: " & [Status]
I hope it helps!!
Hi maybe i can setup google meet with you about this , I want to show to you about this app I do and maybe you can help me ?
Ensure to have read how appsheet works regarding expressions, automation, bots and workflows.
The bot approach above is the right direction. One extra detail: make sure the bot only fires when the approval status actually changes, otherwise it can send duplicate emails whenever the row is edited.
A condition like this is useful:
AND(
IN([Status], {"Approved", "Declined"}),
[_THISROW_BEFORE].[Status] <> [_THISROW_AFTER].[Status]
)
Then set the email To field to the requestor email column, not a fixed address. If you have multiple approvers, I would also add an Approval Completed? yes/no column or final status so the notification only goes out after the last approval step, not after every partial approval.