One of the main usage of SharePoint is a Document Management System where you can setup a Library to store documents in electronic format and setup version control so that all changes are tracked. I will show how we can enhance on that to create an email alert system via email to keep track of Documents which have expiry dates(e.g. Process Documents which needs to reviewed yearly).

Expiry Date Reminder Software Free Online

1. I am going to create reminders prior to the expiration at 2 months, 1 month and 1 week. To do this, we need to create 3 Date/Time variables to create the date of reminder using the Add Time to Date Action in SharePoint Workflow Designer. See below for code. If Else for the reminders.
2. Expiration Reminder is the easiest, most powerful document expiration and renewal tracking software available. Track due dates for contracts, permits and licenses. Say bye-bye to Excel! Try Expiration Reminder free for 14 days!
3. SSLreminder offers certificate monitoring service by periodically checking the TLS certificate of your website. If an issue is discovered, you will receive an email describing the situation and the possible ways to fix it. Every domain name under your account is checked daily. We send expiration reminders based on the schedule below.

Simple Reminder Software for Small Businesses. Keep track of important dates with reminders. Set a one time or recurring reminders with a few steps. Free 14-day trial. No credit card required Immediate setup Unlimited reminders. No credit card required. Set your reminder for as far in advance as you would like so you have plenty of time to get your affairs in order before it’s too late. Licensed is also a valuable tool for tracking renewal dates for your driver’s license, car registration, insurance, first aid certification, free-trial expiration, and more!

SharePoint Library

We will only need one SharePoint Document Library to achieve this. I have named the Document Library as Documents_With_Expiry.

I always create names of Library for use in SharePoint join together with underscore(_) because this will create an easier url to be displayed. Using a space is a norm but that results in conversion to %20 when it becomes a URL. You can change the underscore to a space as norm after the Library is created as the URL will not change anymore. Doing this way shortens the number of characters for URL from 3 to 1 which is beneficial if you use windows explorer mode in SharePoint often because Windows Explorer can only support up to 256 characters for path before you cannot open a file anymore.

Go to Library->Settings->Versioning settings. Set Create a version each time you edit a file in this document library? to ‘Create major and minor (draft) versions’. The rest to leave as default.
Go to Library->Settings->Versioning settings. Set Allow management of content types? to Yes. The rest to leave as default.
Go to Library->Settings>Content Type->Click on ‘Document’->Click on ‘Title’. Set This Column is to ‘Hidden (Will not appear in forms)’.Go to Library->Settings. Add the below new fields required. You can leave the fields which are already as default when you create the Document Library alone, we are not going to use it.

Test out the Library

Once everything above is done, we can do a test on the Library. Try to drag and drop a document in the Document_With_Expiry Library

Expiry Date Reminder software, free download

Once done, you will see a green southeast pointing arrow against your document’s symbol which you have just copied in.

This is an indication the file is not checked in yet as you have not filled in the mandatory fields. Select the Document and go to Files->Edit Properties.

Input the Document Owner (You can create SharePoint User Groups or individual Windows ID if your SharePoint is linked to Active Directory) and Effective Date(which is the date this document is effective and SharePoint will help to calculate the expiry on your behalf). Then click on Save.

Now you can check in the document. Select the Document and go to Files->Check In.

Create SharePoint Workflow for Alert System

Now we are on to the part of the enhancement of the Document Management System which is the Expiration Alert System. We will achieve this via a SharePoint Workflow

Go to Library->Workflow Settings dropdown arrow->Create a Workflow in SharePoint Designer

Name your Workflow and set Platform Type to ‘SharePoint 2010 Workflow’. Note I used a SharePoint 2010 Workflow for this despite using SharePoint 2013 as the 2010 Workflow is good enough to get this done. So you can do this in both SharePoint 2010 and SharePoint 2013.

SharePoint Workflow

I am going to create reminders prior to the expiration at 2 months, 1 month and 1 week. To do this, we need to create 3 Date/Time variables to create the date of reminder using the Add Time to Date Action in SharePoint Workflow Designer. See below for code.

If Else for the reminders

We will need to capture all the possible scenarios so that we will be able to send out the emails accordingly. There are a total of 4 scenarios which we wrap inside if else statement to form the reminder system
1. Expiry Date is more than or equal to 2 months from today
We will need to send email out when it hits exactly two months, one month, one week and when it expires. See below for code

2. Expiry Date is less than 2 months and more than or equal to 1 months from today
We will need to send email out when it hits exactly one month, one week and when it expires. See below for code

3. Expiry Date is less than 1 month and more than or equal to 1 week from today
We will need to send email out when it hits exactly one week and when it expires. See below for code

4. Expiry Date is less than 1 week from today
We will need to send email out when it hits expiry date. See below for code

Conclusion

This is a very simple workflow which can be created in half an hour. There are further enhancement possible to make it more intuitive. Notice my workflow have Email CurrentItem:DocumentOwner which i did not eloborate further on how to do it. That will be discussed in my next post as it can be very broad indeed.

While Entering employee profile details, you are entering employee's Passport details with issue and expiry date, visa details, Emirates ID details and so on. This HR Software uses that details and as per entered expiry dates, EasyHR reminds you to renew those documents which are going to expire.
EasyHR welcomes with a dashboard of all documents which are going to expire or already expired. Now, No more fines for expired documents. Simply double click on any reminder to see detailed view which you can print or export to excel. This HR Software even prompts the user if software should email all the expiry reminders to the manager directly from software itself.

All those employee documents which you keep photocopies in your files, now you can save scanned copies of those documents along with each employee record in EasyHR. You can attach unlimited documents for each employee in word, excel, pdf or jpg format. This HR software allows you to take print out of attached documents or email those documents directly from the software.

Benefits of Document Management & Reminders in this HR Software:

• ⦿ Organize All Documents of Each Employee Along Wiht his/her Records.

• ⦿ No More Fines on Document Expiries, EasyHR reminds you to renew before expiry date.

• ⦿ Email Documents directly from this HR Software whenever need instead of finding.

• ⦿ Organized Soft Copies of documents saves time and keeps you well organized.

• ⦿ Pop-up reminder of documents near to expire, even you do not open the software.

• ⦿ Prompts to Software user to email summary of documents going to expire to his manager.

More Benefits of This HR Management System:

⦿ Employee Basic Details

⦿ Employee Contact Details

⦿ Employee Salary Details

⦿ Employee Passport and Visa Details

⦿ Employee Work Experience and Qualifications

Expiry Date Reminder Software Free Trial

⦿ Assets Issued to Employees

Due Date Reminder software, free download

⦿ Employee Expense and Complaint Records

Free Expiry Date Reminder Software

⦿ Employee Evaluation Records

Expiry Date Reminder software, free download

⦿ Employee Communication Records