Hiding the column headings

Hiding headers in SharePoint can be very handy when you don’t want that “Spreadsheet” look. It’s also a useful feature for when you have created some “Group By” or other out of the ordinary views, and the header row just kind of hangs out there.

To hide the header row, create a Snippet Editor web part from the Media and Content folder and add the following CSS snippet.

<style type=”text/css”>
.ms-viewheadertr {display: none; }


Creating Leave Approval Calendars – Part Two

In the previous tutorial we covered the mechanics of creating the approval workflow on your calendar. Now we’re going build the user interface to where it’s more accessible for your users.

Create a Calendar view showing Approvals only

We want the calendar on SharePoint to only show approved leave, so we need to create a view that only shows approved leave.

You can edit the Calendar view if you wish and just add the filter piece to it; I prefer to create a new view based on the Calendar view, and then called it Approved, and set that as the default view.

Then scroll down to the filter area and set the Approval Status field is equal to Approved

SharePoint: Approval Calendar View

Set the default view for Approval Tasks to be Active Tasks

You do not need to see old requests when you go to the Approval Tasks screen. You only want to see current items so you can approve or reject them.
Click on the Active Tasks link next to All Tasks, then once your active tasks load, go to the LIST tab and choose Modify View. Click the Set as Default checkbox and save.

Create pages that do not allow general users to see the back end of the SharePoint lists.

In general, within SharePoint you can click on a web part header to go to the back end of the SharePoint list. Because leave requests can be sensitive in nature, you don’t want the general population to be able to do that and gain access to submitted requests.

To combat this ability, create separate pages for each of the users, and then add the web part views to them, with Chrome Type = None. That way users can see the content of the page, but unless they are familiar enough with SharePoint, and have the necessary access, they won’t be able to see the back end.

You can get to the pages screen by going to the Site Contents and looking for SitePages. Else, you can click on the PAGE tab, and then View All Pages.

Calendar Page

You may want to add instructions to the calendar page on how to use it. In my blog post about how to break SharePoint I warn you about editing the actual calendar page. Therefore, create a new page, call it Calendar, and then add the calendar web part to it. Under Edit Web Part, choose the Approved view, and then under Appearance, set Chrome Type = None.

My Leave Requests

Create a new page, call it My Leave Requests, and then add the Task list web part to it. Under Edit Web Part, choose the My Leave Requests view, and under Appearance, set Chrome Type = None.

Side Note…

You could also create a page with both the Calendar and the My Leave Requests web parts on the same page.

Leave Approval – Pending Requests

This page will be hidden in the navigation from everyone except the Approvers Group using the Target Audience setting in Navigation.

It contains the Tasks web part, with the Active Tasks view. I recommend you do not turn off the Chrome Type on this one so that if they needed to, the Approvers could click on Tasks and get to the back end if they needed, to possibly reverse a request response, etc.

Update the Workflow

To complete the process, we need to make a final change to the workflow itself to add a link to the Leave Approval – Pending Requests Page.

The email that is sent to the approver generates a link to the calendar item that was added. On the calendar item, there is an option to approve or reject the request. If the approver only uses that function, it does not close out the task on the task list. Therefore, we want to train the approver to go to the Leave Approval – Pending Requests page that contains the Active Tasks view.

Return to Workflow settings, and click on the name of the workflow (Leave Requests)

On the second screen, under the Request field, add the link to the Leave Approval – Pending Requests page such as shown below.

A request for leave is waiting for approval. To view details of request click on the link at the bottom of the page.

However, to actually <a href=”https://starfleet.sharepoint.com/sites/***/****/SitePages/Leave%20Approval%20-Pending%20requests.aspx”>approve request please use this link</a>.

Update Site Navigation

If you went through the steps of creating all the pages above, and thus hiding the built-in functionality of allowing users to get to the back end, then before you deploy the solution to your group, you will want to remove your apps from the navigation, and add your new pages to the navigation in their place.

Rather than going directly to Navigation and removing the links to the apps there, I suggest you go to the list settings for both the Calendar and Task apps, clicking on the Name & Navigation link and removing them from the Quick Launch. There can be an unintended consequence of having to manually add links in the future if you just remove them from Navigation.

Once you have set the apps to not show on Quick Launch, go to the Navigation menu by going to the Gear, then Site Settings, then Navigation.

In the Local Navigation, add the pages to the navigation. Use the Browse feature or just copy and paste the URLs from another browser window.

For the Leave Approval – Pending Requests page, use the Audience: field to restrict the link to that page. Click on the address book icon, search for your Approvers group, then add them to the audience. You also want to add the site collection administrators group, and if need be, your own site owners group.

SharePoint: Navigation Target Audience

Creating Leave Approval Calendars – Part One

In this post we will be creating an approval workflow for a leave calendar. Some departments and companies have a leave request submission process, often accomplished via paper forms that are submitted, reviewed, and then signed by the authorized person. Sometimes the approval comes back to the requestor, sometimes it doesn’t. There’s a better way… SharePoint to the rescue!

This tutorial involves quite a few steps, but they are all completed using the SharePoint browser window, which should make it accessible to all site owners. This tutorial assumes you know your way around SharePoint and does not include screen shots for every step.

Step One: Make sure you have a group on your site with Approver as one of their statuses.

If not, you can grant approver status to an existing group, or create a new group and give the new group Approver status.

Step Two: Create a new calendar.

You can also use an existing one if you’re not using it for anything else, but you generally want to create a new calendar for this purpose. Go to the gear, then Add an App. Give it a one-word name, then later in the settings, change the name to something more friendly.

Step Three: In the versioning settings, set Require content approval for submitted items? to Yes

SharePoint: Versioning Settings

By adding the versioning, SharePoint automatically creates a view for Approve/Reject items. It also creates a view called My submissions.

By default, the “My submissions” view does not actually have the filter set up to only show Created by is equal to [Me]. You’ll need to add that if you want that feature to work.

Step Four: Create your approval workflow.

You can find Workflow settings in the Calendar Tab, or from the List Settings page.
Click Add a Workflow to get to the Workflow screen. The image below shows a Change a Workflow screen, but the screen is the same. Fill in the details as shown below, with the exception of the CC field – please put your own name there, and not mine. You will also edit the request field later, but for now, this is good.

Approval Task List

When you create an approval workflow, it generates a task list and a workflow history list if it doesn’t already exist. When you first create an approval workflow, you probably only have the option to choose Tasks (new), and that’s ok. Do that, and then go to the list settings and rename it later. While you are in there, you may also want to display this list on the quick launch for now.

Final Touches

While you’re done with the creation of the workflow piece, and it will work now, you’re not done yet. There are a number of things that need to be done for the final touches of this process, which are covered in the next post.

5 tips for writing compelling Discussion List posts

Discussion lists allow us to connect with one another and react to the content being posted. While the announcement is nice for one-way communication, the features that go along with the Discussion List, such as the ability to connect them to, and post directly from Outlook, make this a standout in terms of collaboration and communication. The list is designed to post news and other bits of information to share with your colleagues. I don’t know about you though but sometimes reading through an announcement or discussion list is like trying to solve anagrams or crossword puzzles, and I thought it might be helpful to write up a couple of tips to help make our collaboration even better.

Here are some tips on making sure that your posts get read:

  1. Create a great descriptive title. “Idea” is not a good title. “Help” is not a good title. The title of the post shows up in nice, large letters, so use them to your advantage. You have 75 characters to get our attention. Use them well!
  2. Forget the salutation. The first 75 characters of your post appear in the preview, so make them count! Between 75 characters in the title and 75 characters in the preview, you have 150 characters to get us to click on your discussion item. I know that we’ve trained ourselves that we need to open emails and letters with Dear Team, but in a discussion list it’s somewhat redundant as only our colleagues are reading it. You don’t start ever web page with “Dear Reader” so no need to do it here either.
  3. Use separate discussion items to split your content. While we would love to read your prose, let’s be honest: we’re all very busy. Please help us by keeping discussion items short and to the point. If you have a lot to tell us, either break up the content with very easy to see headers, or you might be able to split your content into multiple discussion items so we can pick and choose which is most relevant. I fall into this trap all the time. I can get long winded trying to provide some context behind what we’re doing. In the end though, sorry to say, the longer the post, the less likely it gets read.
  4. Keep your message short by using links to expanded content. This may be redundant, but it’s a slight twist on the above note. If your content needs to be long, such as when you need to provide instructions or describe a detailed process, consider creating a web page or word document with all the details and linking to that source, so that we can get to the message quickly, and then if we need more information, we can go to the link.
  5. Create meaningful hyperlinks. SharePoint has the ability to insert hyperlinks through the INSERT tab. You can add meaningful text that’s linked to additional content. Type your meaningful text first, and then highlight your sentence and use the INSERT Link feature to hyperlink it to your content. Because links are not too easy to see on SharePoint, feel free to highlight and link the entire sentence. You also don’t necessarily need to use the words “click here” or “visit this site” to show people you’ve linked something. Just linking the sentence gets the point across that there’s something more to click on.

I hope these five tips will get you started with writing compelling content for your discussion lists and will make your collaboration more meaningful.

Stripping underscores on a page

​​When creating a new page, the title is the same as the file name.
As of this date, there currently is no way to split file name from page title.
It’s important that we do not include spaces in a file name, and that we instead use underscores.
Unfortunately, with underscores, we have a strange looking page title that includes underscores, which we can strip using a content editor web part.

This is what the title of this page would look like without the underscores stripped:

Page Head with Underscores

Check out the page, and place in EDIT mode.

In the footer of the page, or at the bottom of your site content, insert a Content Editor webpart.

You can find the Content Editor web part under the Media and Content category.

Insert Content Editor Web Part

Click on the little triangle in the top right hand corner of the web part, and choose Edit Web Part.

In the Content Link box, copy and paste the following:


Content Editor Javascript Strip Underscores

Under the Appearance drop down, choose Chrome Style of NONE.
Then click OK and SAVE the page.

Content Editor Chrome None

Adding Excel file information to the header and footer

Adding file information to the header and footer of an Excel file can be done as follows:

  • Under the page layout tab
    • click the little arrow under print titles to expand your page setup window
  • Under the header/footer tab, pick custom header or custom footer
    • For each section, click the information you want to show.
    • To figure out what information each option provides, just click on the buttons.
      • In the center section, I added the word “Page” in front of the options
      • In the right section, I added the words “Last printed: ” in front of the date field.

Excel Header and Footer

Create a calculated field to show due dates first

When viewing task lists ordered by due date, often the tasks with no due dates appear at the top of the list, while the items that have a due date appear at the bottom. Sorting the list in descending order doesn’t help either, because then your items that are due soon will appear in the middle of the list.

There doesn’t appear to be an out of the box setting that will display items with a due date first, followed by those without one, so we get around this by using a calculated field column within the list settings.

Click on the List tab, then on List Settings

SharePoint: List Settings

Scroll to the middle of the page and add a new column. Give that column a name, such as HasDueDate

Choose for this column to be a calculated field and use the following formula in the formula field:

=IF(ISBLANK([Due Date]),”No”,”Yes”)

Calculated field: hasduedate

Save the column.

Sorting your list to include this new HasDueDate column.

The next step is to add this field to the sorting options on your list view.

SharePoint: Modify View

Scroll to the middle of the page, where the sorting options are, and choose HasDueDate from the first column option; then set that to descending order (you want “Yes” to come before “No”).

In the second sort column, choose Due Date in ascending order.

Now your list will always sort with the due dates first, in ascending order.