Push Notification for 7 days

[AnshulKamboj]

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 

[Marc_Dillon]

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

[TeeSee1]

Have you tried setting up a Condition like

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

in your bot event?

[AnshulKamboj]

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

Do I enable ForEachRowInTable Option and select the respective table?

[TeeSee1]

The bot needs to be attached to your table.

My screen shot is just a sample.

[AnshulKamboj]

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

[TeeSee1]

Show us what you actually have by attaching screenshots.

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