Events /Scedule to Email Reminder for the approver

AppSheet AppSheet Q&A
,
1

Hi,

I need to make a schedule to resend the approval email, incase the approver forgoet to approve the request after 1 day.

I tried this but didnt work.

OR(AND([Status Approver 1]=“Pending”,OR(HOUR(Today()- [Approval 1 Sent ])/24=2,HOUR(Today()- [Approval 1 Sent ])/24=4,HOUR(Today()- [Approval 1 Sent ])/24=6,HOUR(Today()- [Approval 1 Sent ])/24=8,HOUR(Today()- [Approval 1 Sent ])/24=10)

Kindly advise.

Thank you

2

Leya0112:

OR(AND([Status Approver 1]=“Pending”,OR(HOUR(Today()- [Approval 1 Sent ])/24=2,HOUR(Today()- [Approval 1 Sent ])/24=4,HOUR(Today()- [Approval 1 Sent ])/24=6,HOUR(Today()- [Approval 1 Sent ])/24=8,HOUR(Today()- [Approval 1 Sent ])/24=10)

Is this a schedule for a Bot?

Is [Approval 1 Sent ] a time, date or datetime column?

2 Likes
3

Fix for expression giving 0% or missing decimal part Tips & Tricks ?

Trying to divide two numbers to get a percentage but always getting 0? Trying to divide two numbers but losing the numbers after the decimal point? TRY THIS Convert one or both of the values in your division expression to a Decimal value, either by: (1) wrapping the value in the expression with the DECIMAL() function; (2) multiplying the value in the expression by 1.0; or (3) changing the column’s type to Decimal if suitable to the app. FOR EXAMPLE If computing a percentage from two Number co…

2 Likes