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

0 5 228
5 REPLIES 5

LeventK
Participant V









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.

Top Labels in this Space