Set Default Value for Hyperlink or Picture Column in SharePoint
Requirement: Set Default value for Hyperlink or Picture Column in SharePoint List
There is no provision for specifying default value in Hyperlink or Picture type columns in SharePoint! In some scenarios, we may want to specify SharePoint 2010/2013 hyperlink column default value. But there is no option in SharePoint web UI to enter hyperlink field default value!
How to set the default value for Hyperlink or Picture Field in SharePoint?
We can set the SharePoint hyperlink column default value with PowerShell! Use this PowerShell script to specify the default value for hyperlink or picture type fields:
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
#Variables
$WebURL="https://intranet.crescent.com"
$ListName="Proposal Documents"
$ColumnName="Reference URL"
$DefaultValue="https://externalsites.crescent.com"
#Get the Web
$web = Get-SPWeb $WebURL
#Get the List
$list = $web.Lists.TryGetList($ListName)
If($list -ne $null)
{
#Get the column
$column = $list.Fields[$ColumnName]
if($column -ne $null)
{
#Set Default Value
$column.DefaultValue = $DefaultValue
$column.Update()
$list.Update()
Write-Host " Default value set for the column!"
}
}
$web.Dispose()
Here is the output for SharePoint list hyperlink default value specified programmatically:
How do I update, the description
$column.Description = “Field Description Goes here”
How to set format url is Picture instead of Hyperlink using server side powershell?
Just supply the URL of the picture!
Hi Rajack,
Where do you incorporate the PowerShell Script?
Thanks,
Linh
Run the script in PowerShell ISE from any of your SharePoint On-Premises WFE!