I have an App for approval workflow. My requirement is that if an approver does not respond to a request, say within 48 hours, then it should be automatically be approved with email notification.
Please help.
Thanks and Regards,
Rajan
Hello,
I had gone thru the above posts. But I donโt find solution. My requirement is that a schedule should run every day say in the morning and update the approval status to โYesโ if system date minus request date is > 2 days and then send a mail notification.
Thanks.
Thatโs strangeโฆ
What you are asking is a Scheduled Report, which will run from your pointed table, with EachRowInTable with a simple expression:
TODAY() - [Request Date] >= 2
and
ACTION #1 :: APPSHEET API THRU WEBHOOK
Trigger a Webhook, with an AppSheet Preset: Edit Row with a simple JSON payload:
{
"Action": "Edit",
"Properties": {
"Locale": "en-US",
"Location": "48.220599, 16.239976",
"Timezone": "W. Europe Standard Time"
},
"Rows": [
{
"Key_Column_Name": "<<[Key_Column_Name]>>",
"Approval_Status": "TRUE"
}
]
}
ACTION #2 :: EMAIL WORKFLOW
Trigger an email workflow as a second action with associated data from the table.
I havenโt invented all these and they are all from the documentation that I had shared previously which you had said you donโt find a solution
It worked. Actually I was not aware of Webhook feature. Your example helped me.
Thank you LeventK.
Youโre welcome.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |