Auto-Populate List Form Fields Based On Lookup Selection In SharePoint

In this article, I will show

How to populate the new form fields like (Lookup field, People and Group Field) based on the selected lookup field value?


Scenario

I have two lists, One list has a lookup field called “Issue ID” that holds the ID from the second List as shown below

First List

Auto Populate List form fields based on Lookup Selection In SharePoint

Second List

Autofill List form fields based on Lookup Selection In SharePoint

When adding a new item, I would like to populate the Issue name based on the selected lookup issue ID as shown below.

Auto Populate List form fields based on Lookup Selection In SharePoint


Continue reading “Auto-Populate List Form Fields Based On Lookup Selection In SharePoint”

Advertisements

SharePoint 2016: Show a List From Parent Site In Sub Site

In this article, I will Show

How to display a SharePoint list from Parent site in Sub Site?

Scenario

In SharePoint 2016, I have a list in the parent site, I would like to show this list inside a page in the subsite.

So that when adding a new item to this list from the subsite, it should also be listed in the same original list in the parent site and vice versa.

Note: You can use the same steps to display a SharePoint list from subsite in parent site.

Continue reading “SharePoint 2016: Show a List From Parent Site In Sub Site”

The Supported and Unsupported Columns In SharePoint Calculated Column Formula

In this article, I will list

The Supported and Unsupported Fields in SharePoint Calculated Column Formula

The Supported and Unsupported Columns in SharePoint Calculated Column Formula Continue reading “The Supported and Unsupported Columns In SharePoint Calculated Column Formula”

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”

Windows PowerShell for SharePoint Command Builder

In this article, I will demonstrate a cool tool that hosted online by Microsoft to guide you to start working with SharePoint Command for SharePoint Versions (2010-2013-Online) and Office 365.It’s Windows PowerShell for SharePoint Command Builder

MainPage

I categorized this article to the following six questions:

  1. What’s Windows PowerShell?
  2. Windows PowerShell vs STSADM?
  3. What’s cmdlet?
  4. Is SharePoint Command builder cover all the cmdlet of SharePoint?
  5. How you could use SharePoint Command Builder?

Continue reading “Windows PowerShell for SharePoint Command Builder”

This web site has been configured to disallow editing with SharePoint Designer

In this article, I will solve the below issue in SharePoint Server / SharePoint Online.

This web site has been configured to disallow editing with SharePoint Designer

This web site has been configured to disallow editing with SharePoint Designer

 


SharePoint Server: This website has been configured to disallow editing with SharePoint Designer

Scenario

In SharePoint Server 2013 / Project Server 2013. while I tried to edit the Project SIte Master Page. I got the following error message:

This web site has been configured to disallow editing with SharePoint Designer

Cause Continue reading “This web site has been configured to disallow editing with SharePoint Designer”