SharePoint Tutorial: How to Create a SharePoint Employee In & Out Board, Part 1
While teaching a SharePoint 2013 Advanced User class for one of Accelebrate’s clients, a student asked me if it would be possible to create an Employee In & Out board using SharePoint. It seemed like a simple request, so that evening in the hotel, I started working on a solution. I quickly realized it was not as “simple” as I thought it might be. I kept running into the road block of how to tell SharePoint to update an employee record instead of creating a new one. I would also want to create a new entry if one did not already exist.
In this article series, I will teach you how to create the Employee In & Out Board using SharePoint lists, an InfoPath form, and a custom workflow. This three-part series will show you how to Create/Update list items using a workflow as well as how to do workflow lookups.
The final product will look like this:
To get started on the In & Out Board, we will create two SharePoint Lists:
Information for Readers New to SharePoint
We will use a 2-step process to create lists, libraries, columns and site columns. This is the same 2-step process that I teach in all my classes and is considered a best practice.
The GEAR: contains links to many of the common pages used in SharePoint including Site Settings, Add an App, and Site Contents. It is generally located in the upper right corner of the SharePoint UI, which I’ve shown below. This screenshot is from an Office 365 E3 SharePoint 2013 installation.
Site Contents link: on the Settings Gear and is where a complete listing of all apps included on your site. The Site Contents link is also on the left navigation (or Quick Launch), but I recommend you learn how to find it on the Settings Gear, as many companies remove this from the left navigation.
Left Navigation: The left navigation is, you guessed it, located on the “left” side of the SharePoint UI. It is also referred to as the Quick Launch. Many steps in the tutorial include the direction “Click the library on the Quick Launch and …”.
List Settings: You will be in the List settings page quite a bit throughout this tutorial as well as in your own SharePoint site. The List settings page contains organized links to pages that allow you to configure a SharePoint list. The List Settings button is located on the right-side of the ribbon of the List tab.
With the basics out of the way, let’s get started creating the lists used with the In & Out Board application. As I mentioned, there are two lists that will be used in this application. The first list that I will create is the IOBoard list. This is the list to which employees will log data, and it can also be used as a tracking list. To create the list, perform the following steps:
Your IOBoard list should look similar to the image below:
Now you will create the Employee Status list. This list contains a single entry for each employee. A new row will be created for an employee not already in the list. If the employee is already in the list, the workflow will just update the existing entry with new information. Use the steps below to create the Employee Status list.
Your Employee Status list should look similar to the image below:
Proceed to Part II.
Author: Eric Stepek, one of Accelebrate’s SharePoint instructors