Detect the Installed SharePoint Edition Using PowerShell

In this article, I will explain

How to detect the installed SharePoint Edition Using PowerShell?


Prerequisites

Before you getting started, you should make sure that the current user has sufficient privilege to run PowerShell Script in SharePoint, Read more at Add-SPShellAdmin

Note: You can directly use the farm account to run this script.


Script Functions

There is a lot of articles talk about this topic, but the new here is detecting the SharePoint 2016 Edition based on the SKU ID. Continue reading “Detect the Installed SharePoint Edition Using PowerShell”

Advertisements

Using Lookup Field in SharePoint Calculated Column Formula

In this article, I will explain

How to use Lookup Field in SharePoint Calculated Column Formula

Scenario

I have a list with a lookup field, I would like to use this lookup field in in SharePoint Calculated Column Formula but unfortunately, it’s not listed in the available formula column as shown below:Using Lookup Field in SharePoint Calculated Column Formula

Cause

It’s by design, The lookup column can’t be used in SharePoint Calculated Column Formula and SharePoint Column Validation.

Check The Supported and Unsupported Columns in SharePoint Calculated Column Formula.

Workarounds

Continue reading “Using Lookup Field in SharePoint Calculated Column Formula”

Using ID Field in Calculated Column in SharePoint

In this article, I will explain

How to use The ID field in Calculated Column in SharePoint?

Scenario

I have tried to add ID field in a calculated column that added successfully without any error in the formula.

But I noticed that the calculated column is not calculated on the item added or updated!

Cause

Continue reading “Using ID Field in Calculated Column in SharePoint”

Group By Content-Type in SharePoint list view

In this article, I’ll show How to

Group By ‘Content-Type’ field in SharePoint list view

Group By 'Content-Type' field in SharePoint list


Scenario:

Continue reading “Group By Content-Type in SharePoint list view”

Show / Hide fields based on a dropdown selection using SPUtility.js

In this article, I’ll explain How to show and hide fields based on a Choice field selection in ‘New Form’, ‘Edit Form’ and ‘Display Form’ in SharePoint 2013 / 2016 via SPUtility.js?

Prerequisites:

  • Download SPUtility.js.
  • Upload the downloaded file (SPUtility.js) to an appropriate place in SharePoint Site like ‘Style Library’.
  • Create a Custom list.
    • Add a choice field displayed as ‘Drop-Down Menu‘.
    • Fill your choices as you need.
    • Add the fields that you need to show or hide based on the selected value of choice field.

Steps:

Continue reading “Show / Hide fields based on a dropdown selection using SPUtility.js”

Show / Hide DIV tag based on user group in SharePoint via SPServices

In this hint, I’ll elaborate How to

Show / hide HTML tag. in case , the current user belongs to a specific Group in SharePoint.

Show Hide DIV tag based on user group in SharePoint via SPServices


Scenario

Consider you have a SharePoint Page that holds two Script Editor Web Part or more, and each Script Editor Web Part has its independent DIV as shown below.

Show or Hide a DIV tag based on a user group in SharePoint via SPServices

Now, you need to hide the left (DIV) with ‘< div id="ID1"> Qassas div ID1< /div > from all users who belong to a specific SharePoint Group in your SharePoint site.


Check if the current user belongs to a specific Group In SharePoint

Steps:
Continue reading “Show / Hide DIV tag based on user group in SharePoint via SPServices”

Hide List View Header Menu via CSS in SharePoint

In this hint, I’ll show How to

Hide SharePoint List View column header menu via CSS for print purpose.

hide SharePoint ListView column header menu via CSS


Steps: Continue reading “Hide List View Header Menu via CSS in SharePoint”