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 run this script, 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 hint, I’ll show How to Group By ‘Content-Type’ field in SharePoint list view?Group By 'Content-Type' field in SharePoint listScenario:

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 a DIV tag based on a user group in SharePoint via SPServices

In this hint, I’ll elaborate How to show/hide a DIV tag based on a user existence in a specific group with a specific permission in SharePoint via SPServices?Show Hide DIV tag based on user group in SharePoint via SPServicesScenario:

Consider you have a SharePoint Page that holds a 2 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 SPServicesNow, 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.

Steps: Continue reading “Show / Hide a DIV tag based on a 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 ListView column header menu via CSS for print purpose.open-menu-option-in-listviewSteps : Continue reading “Hide List View Header Menu via CSS in SharePoint”