Using appsheet to create a reminder tracker to remind those that have not responded on the due date, and aiming to send only one reminder on the due date. Emails are getting sent but the condition logic is not working

AppSheet AppSheet Q&A
1

New topic: I have a google sheet with 2 tables one with the list of recipients, email address, reminder sent status and due date columns the other table for responses from google form which also collects the email address column.

I am using a filter within the appsheet to filter only those emails that are not in the responses table and send an email on the due date only once and also updating the row action for reminder status to sent with this formula in the bot event configuration

AND(
[Due Date] = TODAY(),
[Reminder Sent] <> “Sent”,
NOT(IN([Email], SELECT(Confirmations[Email Address], TRUE)))
)

adding a process to send an email and set the status to sent so it wont get picked again

however this is not working and the appsheet is not reading the logic. can anyone help me have alook at this. Not able to create a grouped action to fix this

2

I didn’t quite understand, but try using a scheduled event.

Try using something like this:

Scheduled Event

1. Go to Automation > Bots

2. Create a Scheduled bot

3. Configure:

Schedule: “Daily”

Time: desired execution time

Table: recipient table

Filter condition:

AND(

[Due Date] = TODAY(),

[Reminder Sent] <> “Sent”,

NOT(

IN(

[Email],

SELECT(Confirmations[Email Address], TRUE)

)

)

4. In the process:

Step 1: Send Email

Step 2: Data: set the value of some columns

update Reminder Sent = “Sent”

1 Like
3

image
image657Ă—681 11.6 KB

Used the same process. When i execute it it sends 2 emails and then once it sends an email to the email address thats not on the response sheet it should mark as sent which it does and then when i execute it again it sends the email again.

so 2 issues:

  1. why is it sending 2 emails when i execute all the the 3 steps
  2. why is it still sending email when its already marked sent

is executing causing the issue?

thanks for your help

4

Need screenshots of the configurations of all bot components involved.

Why not?

1 Like
5

Thank you here it is

Tables

image
image1374Ă—660 48.4 KB

image
image1404Ă—613 46.4 KB

Bots

image
image1894Ă—943 82.9 KB

Pleasel let me know if you need to see anything else

6

image
image1190Ă—813 47.3 KB

image
image1498Ă—900 65.1 KB

image
image1498Ă—767 44.9 KB

7

I replicated the structure and in all my tests only one email was sent.

1 Like
8

In your Process for your bot, you should start it with a condition check and put the Send an Email task inside that conditional.

The check would be something like NOT(IN([Email],Confirmations[Email Address]))

Put the Email task in the Yes branch and leave the No branch empty.

You can leave the Reminder status sent task as the final task outside of the condition.

2 Likes