Push Notification for 7 days

AppSheet AppSheet Q&A
1

I have a Projects Table in which a column Name is End date.

I want push notification on the basis of if project end date is in next 7 days, system should send a pushup notification once on daily basis till next 7 days.

Please Help

@Suvrutt_Gurjar @TeeSee1

2

https://help.appsheet.com/en/articles/4865307-appsheet-automation-the-essentials

1 Like
3

Have you tried setting up a Condition like

([End Date] - 7) <= TODAY()

in your bot event?

TeeSee1_0-1645504294324.png
TeeSee1_0-1645504294324.png472×871 42.4 KB

1 Like
4

The expression is showing an error, Unable to find Column End Date.

Do I enable ForEachRowInTable Option and select the respective table?

5

The bot needs to be attached to your table.

My screen shot is just a sample.

1 Like
6

I have Used the expression given by you but it is not triggering the message when I update the project End date.

7

Show us what you actually have by attaching screenshots.

The more you share, it will be easier for community contributors to help you.

1 Like