For a large retail corporation that manages 800+ vendors and thousands of users, outreach is a phenomenally rigorous task. To ensure that the portal is kept up to date and users are informed of the latest information, the sites must be maintained with the last reports and documents.

Objective

Send out a notification email to users who have not accessed the portal in 60 days.

Overview

This task runs off a list on the parent site that records the last access time for each user. A bit of JavaScript applied to each vendor site will track the last visit of each user and update their item listing based on a unique user ID.

Obstacles

• The notification email should only be sent out if the user has not accessed the site for exactly 60 days.

Solution

A compare will be run once a day against the tracking list. If the Modified value for a particular user is exactly 60 days prior to the current date, a custom notification email is sent out to the user to remind them to check in on the portal for the latest updates and information.

Tracking list to manage users' last visit to the portal​