Ricardo Palhano's Page

17
Thu

Get the Total for Calculated Columns in SharePoint

by: Ricardo Palhano | 2 Comments

Creating a Calculated Column MetroStar previously published a blog on using the DataView Web Part and SharePoint Designer to get the total on a Calculated Column. This is because SharePoint does not do totaling on Calculated Columns Out of the Box (OOB). Here we discuss an alternative method that does not have any restrictions on […]

Filed in: Collaboration, Sharepoint

15
Tue

SharePoint Tutorial: Creating a button in SharePoint 2013 or 2016

by: Ricardo Palhano | 1 Comment

An Updated Tutorial MetroStar previously published a tutorial detailing how to create a button to add items or documents to a list in SharePoint 2007. Since this was, and still is a popular post, in this blog we have updated the tutorial for SharePoint 2013 and 2016. Get the Add a New Item Link This […]

Filed in: Collaboration, Sharepoint

17
Wed

Dynamic SharePoint Graphical Inventory using Visio Viewer

by: Ricardo Palhano | No Comments

Dynamic SharePoint Graphical Inventory using Visio Viewer In this post we will create a Visio diagram with data shapes linked to multiple SharePoint lists.  We will then display the Visio floorplan diagram in a SharePoint inventory dashboard. 1. We start with multiple lists containing various different inventories. In this example we have different lists to manage […]

Filed in: Collaboration, Sharepoint, Technology, Tips & Tricks

11
Thu

Dynamic SharePoint List Dashboard using Excel Viewer

by: Ricardo Palhano | No Comments

Dynamic SharePoint List View Dashboard with Excel Viewer This post will cover how to create an Excel Dashboard inside of a SharePoint list or library view, using the Excel Viewer web part and an Excel sheet linked to your list or library.  The Excel sheet will use pivot charts and tables to display the data we want […]

Filed in: Collaboration, Sharepoint, Technology, Tips & Tricks

03
Wed

Knowledge Base Dashboard with SharePoint Content Query and Search

by: Ricardo Palhano | No Comments

Initial Setup for a Knowledge Base 1. We start with a set of documents for our Knowledge Base.  They are in a new Content Type and we have added in some fields to make it easier to organize and search. 2. We can create views to try and organize this library, but there are alternatives that can […]

Filed in: Collaboration, Sharepoint, Technology, Tips & Tricks

06
Mon

A Look at Microsoft’s SharePoint Mobile App

by: Ricardo Palhano | No Comments

When will the mobile app be released? For companies that heavily utilize Microsoft SharePoint, a mobile solution is on its way. The official SharePoint mobile apps will be released later this month for iOS, and later this year for Windows Mobile and Android. I, myself, have not had the chance to play with any betas of the […]

Filed in: Collaboration, Sharepoint, Technology

16
Fri

SharePoint 404 error Site Collection Corrupted (error 0x80070003), How to Delete

by: Ricardo Palhano | No Comments

SharePoint 404 error Site Collection Corrupted (error 0x80070003) How to Delete Previously we took a look at a possible cause of a 404 error in SharePoint after a content database restoration. This time we have determined that the site collection is corrupt, and we don’t have any backups (you should always have backups).  Another scenario […]

Filed in: Collaboration, Technology, Tips & Tricks

16
Fri

Fix a SharePoint 404 error (Caused by restoring a previous copy of a content database)

by: Ricardo Palhano | 1 Comment

SharePoint 404 error (After restoring a previous copy of a content database to replace the current one) A 404 error in SharePoint can mean multiple things.  In this case it happens because we restored an older version of a content database to resolve an issue.  Now when we go to the site we get a […]

Filed in: Collaboration, Tips & Tricks

25
Fri

SharePoint 2013 Business Connectivity Services, Create a Display Template for a Result Source or Result Type (Bonus Part of 3)

by: Ricardo Palhano | 2 Comments

Back to Part 3  Create a new SharePoint Item Display Template In the previous blog post we had created all of our SharePoint BDC connections, content types, search schemas, and crawls.  But the display left something to be desired.  Now we will update the display templates to show a bit more information in our search results. […]

Filed in: Collaboration, Tips & Tricks

16
Wed

SharePoint 2013 Any Color Coded Calendar, Step by Step

by: Ricardo Palhano | 16 Comments

Previously MetroStar had a blog on how to create a color coded calendar Out of the box (OOB). This post will cover step by step on how you can leverage just a bit of JS that you can easily copy and paste into a Content Editor Web Part to achieve a more robust solution. So […]

Filed in: Collaboration, Tips & Tricks