Update few fields at a scheduled time

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










3 Likes

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 :hugs:

3 Likes

It worked. Actually I was not aware of Webhook feature. Your example helped me.

Thank you LeventK.

1 Like

You’re welcome.

1 Like