Styjun

Evolution of Pikachu: Pokemon Go

What are these silver stripes on Cosmic Girl for?

Does it make sense to occupy open space?

How can glass marbles naturally occur in a desert?

French equivalent of "Make leaps and bounds"

What are the examples (applications) of the MIPs in which the objective function has nonzero coefficients for only continuous variables?

What word can be used to describe a bug in a movie?

Should I take out a personal loan to pay off credit card debt?

Is alignment needed after replacing upper control arms?

Could one become a successful researcher by writing some really good papers while being outside academia?

Did silent film actors actually say their lines or did they simply improvise “dialogue” while being filmed?

How can I tell if a flight itinerary is fake

How to realistically deal with a shield user?

Why should public servants be apolitical?

How many years before enough atoms of your body are replaced to survive the sudden disappearance of the original body’s atoms?

What are these mathematical groups in U.S. universities?

Does this put me at risk for identity theft?

How do I say "Outdoor Pre-show"

Is it a bad idea to offer variants of a final exam based on the type of allowed calculators?

What can make Linux unresponsive for minutes when browsing certain websites?

"How do you solve a problem like Maria?"

Unexpected route on a flight from USA to Europe

Purchased new computer from DELL with pre-installed Ubuntu. Won't boot. Should assume its an error from DELL?

Does this smartphone photo show Mars just below the Sun?

How to fixupdate default values in a List in SharePoint 2013

How do you give a C# Auto-Property a default value?IEnumerable vs List - What to Use? How do they work?What is a NullReferenceException, and how do I fix it?SharePoint 2013 custom pagesWhy not inherit from List<T>?How to add button on SharePoint allitems.aspx list view column and update list items on its click event?How can I update a calculated column using Sharepoint Designer 2013?Customize “Add New Item” form in a Sharepoint 2013 List to pull parameters from the query stringHow to perform Looping Through List Items in SharePoint 2013 Designer Workflows?Sharepoint 2013 - Lookup item not working (Does not display value)

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I am working in SharePoint 2013 where while creating a new item in a list one column should have default value is my requirement. Could any one please let me know how to update (or) fix default value for a column of a list in SP 2013.

c# json sharepoint sharepoint-2013 sharepoint-designer

share|improve this question

asked Mar 27 at 5:55

murali kuruvamurali kuruva

1644 bronze badges

add a comment | 

0

I am working in SharePoint 2013 where while creating a new item in a list one column should have default value is my requirement. Could any one please let me know how to update (or) fix default value for a column of a list in SP 2013.

c# json sharepoint sharepoint-2013 sharepoint-designer

share|improve this question

asked Mar 27 at 5:55

murali kuruvamurali kuruva

1644 bronze badges

add a comment | 

I am working in SharePoint 2013 where while creating a new item in a list one column should have default value is my requirement. Could any one please let me know how to update (or) fix default value for a column of a list in SP 2013.

c# json sharepoint sharepoint-2013 sharepoint-designer

share|improve this question

asked Mar 27 at 5:55

murali kuruvamurali kuruva

1644 bronze badges

share|improve this question

asked Mar 27 at 5:55

murali kuruvamurali kuruva

1644 bronze badges

share|improve this question

asked Mar 27 at 5:55

murali kuruvamurali kuruva

1644 bronze badges

asked Mar 27 at 5:55

murali kuruvamurali kuruva

1644 bronze badges

asked Mar 27 at 5:55

murali kuruvamurali kuruva

1644 bronze badges

2 Answers
2

active

oldest

votes

0

You can always use powershell to fix default values.

 $myweb= Get-SPWeb http://yoursiteURL
 $mylist = $myweb.Lists["yourlistname"]
 $myFieldName = $list.Fields["mySPFieldName"]
 $FieldName.DefaultValue = "MY Default value"

share|improve this answer

answered Mar 27 at 9:09

Syed Danish AftabSyed Danish Aftab

111 bronze badge

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Syed, i tried your script. unfortunately its not working. Error message as below Cannot index into a null array. At C:UsersspsetupCodedefaultvalue.ps1:3 char:5 + $myFieldName = $list.Fields["Default"] + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : NullArray The property 'DefaultValue' cannot be found on this object. Verify that the property exists and can be set. At C:UsersspsetupCodedefaultvalue.ps1:4 char:5 + $FieldName.DefaultValue = "google.com" + CategoryInfo : InvalidOperation
  
  – murali kuruva
  Mar 27 at 11:41
  
  

  
  
  
  

add a comment | 

0

Here is my test script(the script shared by Syed Danish Aftab just not use right variable ).

$myweb= Get-SPWeb http://sp:12001/
$mylist = $myweb.Lists["Chart"]
$myFieldName = $mylist.Fields["QTY"]
$myFieldName.DefaultValue = 3
$myFieldName.Update()
Write-Host 'complete'

Test result:

$myweb= Get-SPWeb http://sp:12001/
$mylist = $myweb.Lists["Chart"]
$myFieldName = $mylist.Fields["Link"]
$defaultValue=$myFieldName.DefaultValue
$myFieldName.DefaultValue = 'https://www.google.com/'
$myFieldName.Update()
Write-Host 'complete'

share|improve this answer

edited Mar 28 at 3:35

answered Mar 28 at 1:23

Lee_MSFTLee_MSFT

2,40411 gold badge22 silver badges88 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Lee, thanks for response. This script used for Hyderlink column in list also? I get below error when i try script The property 'DefaultValue' cannot be found on this object. Verify that the property exists and can be set. At C:UsersspsetupCodedefaultvalue.ps1:4 char:1 + $myFieldName.DefaultValue = "google.com" + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : PropertyNotFound You cannot call a method on a null-valued expression. At C:UsersspsetupCodedefaultvalue.ps1:5 char:1
  
  – murali kuruva
  Mar 28 at 3:02
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Check my update.
  
  – Lee_MSFT
  Mar 28 at 3:35
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I am try for hyderlink column. I tried your update script. I am getting below The property 'DefaultValue' cannot be found on this object. Verify that the property exists and can be set. At C:UsersspsetupCodedefaultvalue.ps1:5 char:1 + $myFieldName.DefaultValue = 'google.com' + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : PropertyNotFound You cannot call a method on a null-valued expression. At C:UsersspsetupCodedefaultvalue.ps1:6 char:1 + $myFieldName.Update() Please suggest me.
  
  – murali kuruva
  Mar 28 at 3:44
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Try to output the field title to confirm you got the field correctly. Write-Host $myFieldName.Title
  
  – Lee_MSFT
  Mar 28 at 7:43
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i am getting same error in powershell -> The property 'DefaultValue' cannot be found on this object. Verify that the property exists and can be set. At C:UsersspsetupCodedefaultvalue.ps1:5 char:1 + $myFieldName.DefaultValue = 'google.com' + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : PropertyNotFound You cannot call a method on a null-valued expression. At C:UsersspsetupCodedefaultvalue.ps1:6 char:1 + $myFieldName.Update() + CategoryInfo : InvalidOperation: (:) [], RuntimeException
  
  – murali kuruva
  Mar 28 at 8:45
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55370651%2fhow-to-fix-update-default-values-in-a-list-in-sharepoint-2013%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

You can always use powershell to fix default values.

 $myweb= Get-SPWeb http://yoursiteURL
 $mylist = $myweb.Lists["yourlistname"]
 $myFieldName = $list.Fields["mySPFieldName"]
 $FieldName.DefaultValue = "MY Default value"

share|improve this answer

answered Mar 27 at 9:09

Syed Danish AftabSyed Danish Aftab

111 bronze badge

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Syed, i tried your script. unfortunately its not working. Error message as below Cannot index into a null array. At C:UsersspsetupCodedefaultvalue.ps1:3 char:5 + $myFieldName = $list.Fields["Default"] + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : NullArray The property 'DefaultValue' cannot be found on this object. Verify that the property exists and can be set. At C:UsersspsetupCodedefaultvalue.ps1:4 char:5 + $FieldName.DefaultValue = "google.com" + CategoryInfo : InvalidOperation
  
  – murali kuruva
  Mar 27 at 11:41
  
  

  
  
  
  

add a comment | 

0

You can always use powershell to fix default values.

 $myweb= Get-SPWeb http://yoursiteURL
 $mylist = $myweb.Lists["yourlistname"]
 $myFieldName = $list.Fields["mySPFieldName"]
 $FieldName.DefaultValue = "MY Default value"

share|improve this answer

answered Mar 27 at 9:09

Syed Danish AftabSyed Danish Aftab

111 bronze badge

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Syed, i tried your script. unfortunately its not working. Error message as below Cannot index into a null array. At C:UsersspsetupCodedefaultvalue.ps1:3 char:5 + $myFieldName = $list.Fields["Default"] + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : NullArray The property 'DefaultValue' cannot be found on this object. Verify that the property exists and can be set. At C:UsersspsetupCodedefaultvalue.ps1:4 char:5 + $FieldName.DefaultValue = "google.com" + CategoryInfo : InvalidOperation
  
  – murali kuruva
  Mar 27 at 11:41
  
  

  
  
  
  

add a comment | 

You can always use powershell to fix default values.

 $myweb= Get-SPWeb http://yoursiteURL
 $mylist = $myweb.Lists["yourlistname"]
 $myFieldName = $list.Fields["mySPFieldName"]
 $FieldName.DefaultValue = "MY Default value"

share|improve this answer

answered Mar 27 at 9:09

Syed Danish AftabSyed Danish Aftab

111 bronze badge

 $myweb= Get-SPWeb http://yoursiteURL
 $mylist = $myweb.Lists["yourlistname"]
 $myFieldName = $list.Fields["mySPFieldName"]
 $FieldName.DefaultValue = "MY Default value"

share|improve this answer

answered Mar 27 at 9:09

Syed Danish AftabSyed Danish Aftab

111 bronze badge

answered Mar 27 at 9:09

Syed Danish AftabSyed Danish Aftab

111 bronze badge

answered Mar 27 at 9:09

Syed Danish AftabSyed Danish Aftab

111 bronze badge

0

Here is my test script(the script shared by Syed Danish Aftab just not use right variable ).

$myweb= Get-SPWeb http://sp:12001/
$mylist = $myweb.Lists["Chart"]
$myFieldName = $mylist.Fields["QTY"]
$myFieldName.DefaultValue = 3
$myFieldName.Update()
Write-Host 'complete'

Test result:

$myweb= Get-SPWeb http://sp:12001/
$mylist = $myweb.Lists["Chart"]
$myFieldName = $mylist.Fields["Link"]
$defaultValue=$myFieldName.DefaultValue
$myFieldName.DefaultValue = 'https://www.google.com/'
$myFieldName.Update()
Write-Host 'complete'

share|improve this answer

edited Mar 28 at 3:35

answered Mar 28 at 1:23

Lee_MSFTLee_MSFT

2,40411 gold badge22 silver badges88 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Lee, thanks for response. This script used for Hyderlink column in list also? I get below error when i try script The property 'DefaultValue' cannot be found on this object. Verify that the property exists and can be set. At C:UsersspsetupCodedefaultvalue.ps1:4 char:1 + $myFieldName.DefaultValue = "google.com" + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : PropertyNotFound You cannot call a method on a null-valued expression. At C:UsersspsetupCodedefaultvalue.ps1:5 char:1
  
  – murali kuruva
  Mar 28 at 3:02
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Check my update.
  
  – Lee_MSFT
  Mar 28 at 3:35
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I am try for hyderlink column. I tried your update script. I am getting below The property 'DefaultValue' cannot be found on this object. Verify that the property exists and can be set. At C:UsersspsetupCodedefaultvalue.ps1:5 char:1 + $myFieldName.DefaultValue = 'google.com' + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : PropertyNotFound You cannot call a method on a null-valued expression. At C:UsersspsetupCodedefaultvalue.ps1:6 char:1 + $myFieldName.Update() Please suggest me.
  
  – murali kuruva
  Mar 28 at 3:44
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Try to output the field title to confirm you got the field correctly. Write-Host $myFieldName.Title
  
  – Lee_MSFT
  Mar 28 at 7:43
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i am getting same error in powershell -> The property 'DefaultValue' cannot be found on this object. Verify that the property exists and can be set. At C:UsersspsetupCodedefaultvalue.ps1:5 char:1 + $myFieldName.DefaultValue = 'google.com' + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : PropertyNotFound You cannot call a method on a null-valued expression. At C:UsersspsetupCodedefaultvalue.ps1:6 char:1 + $myFieldName.Update() + CategoryInfo : InvalidOperation: (:) [], RuntimeException
  
  – murali kuruva
  Mar 28 at 8:45
  

  
  
  
  

add a comment | 

0

Here is my test script(the script shared by Syed Danish Aftab just not use right variable ).

$myweb= Get-SPWeb http://sp:12001/
$mylist = $myweb.Lists["Chart"]
$myFieldName = $mylist.Fields["QTY"]
$myFieldName.DefaultValue = 3
$myFieldName.Update()
Write-Host 'complete'

Test result:

$myweb= Get-SPWeb http://sp:12001/
$mylist = $myweb.Lists["Chart"]
$myFieldName = $mylist.Fields["Link"]
$defaultValue=$myFieldName.DefaultValue
$myFieldName.DefaultValue = 'https://www.google.com/'
$myFieldName.Update()
Write-Host 'complete'

share|improve this answer

edited Mar 28 at 3:35

answered Mar 28 at 1:23

Lee_MSFTLee_MSFT

2,40411 gold badge22 silver badges88 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Lee, thanks for response. This script used for Hyderlink column in list also? I get below error when i try script The property 'DefaultValue' cannot be found on this object. Verify that the property exists and can be set. At C:UsersspsetupCodedefaultvalue.ps1:4 char:1 + $myFieldName.DefaultValue = "google.com" + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : PropertyNotFound You cannot call a method on a null-valued expression. At C:UsersspsetupCodedefaultvalue.ps1:5 char:1
  
  – murali kuruva
  Mar 28 at 3:02
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Check my update.
  
  – Lee_MSFT
  Mar 28 at 3:35
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I am try for hyderlink column. I tried your update script. I am getting below The property 'DefaultValue' cannot be found on this object. Verify that the property exists and can be set. At C:UsersspsetupCodedefaultvalue.ps1:5 char:1 + $myFieldName.DefaultValue = 'google.com' + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : PropertyNotFound You cannot call a method on a null-valued expression. At C:UsersspsetupCodedefaultvalue.ps1:6 char:1 + $myFieldName.Update() Please suggest me.
  
  – murali kuruva
  Mar 28 at 3:44
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Try to output the field title to confirm you got the field correctly. Write-Host $myFieldName.Title
  
  – Lee_MSFT
  Mar 28 at 7:43
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i am getting same error in powershell -> The property 'DefaultValue' cannot be found on this object. Verify that the property exists and can be set. At C:UsersspsetupCodedefaultvalue.ps1:5 char:1 + $myFieldName.DefaultValue = 'google.com' + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : PropertyNotFound You cannot call a method on a null-valued expression. At C:UsersspsetupCodedefaultvalue.ps1:6 char:1 + $myFieldName.Update() + CategoryInfo : InvalidOperation: (:) [], RuntimeException
  
  – murali kuruva
  Mar 28 at 8:45
  

  
  
  
  

add a comment | 

Here is my test script(the script shared by Syed Danish Aftab just not use right variable ).

$myweb= Get-SPWeb http://sp:12001/
$mylist = $myweb.Lists["Chart"]
$myFieldName = $mylist.Fields["QTY"]
$myFieldName.DefaultValue = 3
$myFieldName.Update()
Write-Host 'complete'

Test result:

$myweb= Get-SPWeb http://sp:12001/
$mylist = $myweb.Lists["Chart"]
$myFieldName = $mylist.Fields["Link"]
$defaultValue=$myFieldName.DefaultValue
$myFieldName.DefaultValue = 'https://www.google.com/'
$myFieldName.Update()
Write-Host 'complete'

share|improve this answer

edited Mar 28 at 3:35

answered Mar 28 at 1:23

Lee_MSFTLee_MSFT

2,40411 gold badge22 silver badges88 bronze badges

$myweb= Get-SPWeb http://sp:12001/
$mylist = $myweb.Lists["Chart"]
$myFieldName = $mylist.Fields["QTY"]
$myFieldName.DefaultValue = 3
$myFieldName.Update()
Write-Host 'complete'

$myweb= Get-SPWeb http://sp:12001/
$mylist = $myweb.Lists["Chart"]
$myFieldName = $mylist.Fields["Link"]
$defaultValue=$myFieldName.DefaultValue
$myFieldName.DefaultValue = 'https://www.google.com/'
$myFieldName.Update()
Write-Host 'complete'

share|improve this answer

edited Mar 28 at 3:35

answered Mar 28 at 1:23

Lee_MSFTLee_MSFT

2,40411 gold badge22 silver badges88 bronze badges

answered Mar 28 at 1:23

Lee_MSFTLee_MSFT

2,40411 gold badge22 silver badges88 bronze badges

answered Mar 28 at 1:23

Lee_MSFTLee_MSFT

2,40411 gold badge22 silver badges88 bronze badges