.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Calculated column Default Value not retained in site template.

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :SharePoint

On a new blank site, create a custom list and make these changes to the Title field:

  1. Change the name to Date
  2. Change Required to No
  3. Change Default Value: to Calculated Value
  4. Enter the formula "=TEXT(Today,"d-mmm-yyyy")" so that it defaults to today's date

Save thsi site as a template, then create another site based on this template. Items 1 and 2 above are carried over to the new site but items 3 and 4 revert to the default setting.

Does anyone know how to get around this ... er ... abnomaly?

View Complete Post

More Related Resource Links

Creating a Site Column that Looks up an External List causes error when saving site as a template.


I'm not sure what the best practice is here, but I'm having a major issue trying to save sites as templates and I think I narrowed it down as to what the issue is.

When I try to save a site as a template, it creates the solution package, but it doesn't activate it.  When I try to activate it manually, I get the following error:

Feature definition with Id e9431ed5-27b1-4c33-9eeb-81b4ace9d372 failed validation, file 'test1ListInstances\ElementsFields.xml', line 481, character 231: The 'SystemInstance' attribute is not allowed.

I opened up the solution package and looked at the ElementsFields.xml file.  I traced the line to this:

<Field Type="BusinessData" DisplayName="Acme People Name" Required="FALSE" EnforceUniqueValues="FALSE" Group="Custom Columns" ID="{55b3bbba-a7e3-4698-9946-648a6b726e9e}" SourceID="{026904fd-f2d0-4e57-a239-c6da838458fa}" StaticName="Acme_x0020_People_x0020_Name" Name="Acme_x0020_People_x0020_Name" SystemInstance="ACME" EntityNamespace="http://????????:28241" EntityName="People" BdcField="FullName" Profile="" HasActions="True" SecondaryFieldBdcNames="0" RelatedF

Provision/Add custom Layout, Master and Default pages in Site Template


I'm attempting to use the onet.xml of a custom Site Template to provision/add (same thing?) a custom Master Page, a Custom Layout page and then reference them in Configurations.

I'm having trouble understanding the steps and order to do this in properly and am getting errors where the Layouts/Master pages cannot be found.  Here is what I have now:

<Module Name="SitesLayout" Url="_catalogs/masterpage" Path="Layouts" RootWebOnly="false">

  <File Url="SitesLayout.aspx" Type="GhostableInLibrary"><Property Name="Title" Value="AEP Sites Layout Template" /></File>


<Module Name="AEPMasterPage" Url="_catalogs/masterpage" RootWebOnly="false">

     <File Url="CustomMaster.master" Type="GhostableInLibrary" IgnoreIfAlreadyExists="true" />


<Module Name="DefaultFunctional" Url="Pages" Path="">

     <File Name="MyDefault.aspx" Url="DefaultOrgFuncHomePage\default.aspx" Type="GhostableInLibrary" IgnoreIfAlreadyExists="TRUE">

     <Property Name="Title" Val

How to change Default My Site Template

When new user access to SharePoint for the first time and click on MySite (or access to MySiteHost), SharePoint will automatically create the Personal Site. I understand that it will use SPSPERS template (ID = 21). Can we change this default Site Template to other saved site template (that is based on SPSPERS (ID=21)?

I have tried to configure onet.xml of SPSPERS (I am aware that this might not be supported). However, it's very difficult to configure all the webparts and features that are needed for every new site created for users in onet.xml. So my idea is to save one configured personal site as Site Template, and every personal site should use this Site Template as personal site instead. What I have done now, is to manually create the Personal Site based on Site Template (using stsadm -o createsite), and it works perfectly. But it's tough to pre-create every personal site for new users. Is there any way to change the default personal site template?

And 2nd questions, is there any way to set Blog feature automatically created?

No longer have the ability to move webparts to different zones on the default "team site" template

I noticed today that one of the default site templates that i most widely use in sharepoint 2007 -the "Team Site" template when used in sharepoint 2010 i can no longer move webparts on the main home page from one zone to another from the browser in sharepoint 2010, or specify where they should be when creating them.   I am able to do this if i create a blank site, but that would also involve creating all the neccesary document libraries and  other team site lists.  I suppose as a last resort i could make my own template off of the blank site template that is similar to the team site template. but i am curious as to why this has been setup this way, or if anyone else has noticed this behavior

Ryan Klick

Accounts in Default Template


Hi,  I'm trying to learn in the VS 2010 Express. Using the default template for ASP.Net Website. It starts the web application with an accounts folder. I'm trying to extend the "registration" or "AddUser" utilities. What I'd like to do is modify the registration by adding additional elements (i.e., address, city, ST, zip, etc.). I know I can open the database and modify the Users table and also modify the stored procedure for CreateUser.

My question is:  I don't see any reference in the page code (here's a reprint of the register.aspx.vb) that calls the procedure, or even passes in the variables from the textbox entries from the page. I must be missing something. Can someone clue me how to drill into this template to find the elements like how it communicates with the database. There are a few JQuery files. I am not yet very familiar with JQuery. Is that where I need to look? Thanks for any advice...

Public Class Register
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        RegisterUser.ContinueDestinationPageUrl = Request.QueryString("ReturnUrl")
    End Sub

    Protected Sub RegisterUser_CreatedUser(ByVal sender As Object, ByVal e As EventArgs) Handles RegisterUser.CreatedUser

How to get character count in 'Multiple Text 'column using Calculated Column?


Hi All,

I have a multiple text box in a list

I want

  • A column which lists number of characters in multiple list column example 188, 199 etc
  • Multiple character column must not have more than 200 chars
Is this possible?

Appreciate all the help!


workflows when saving site as template with content

I have have a MOSS 2007 site on a production server with custom workflows.  I saved the site as a template with content and used the template to create a sibling site.  I am testing it and the workflows aren't working.  Is this to be expected? I have read that workflow don't work when saving between development and production, but I can't find anything that addresses both sites being on production. Will I need to recreate the custom workflows by hand? 

Is there a way to update the template of a site?


I am looking for a best practice for managing and applying site design changes.

For instance, in another platform, I could release a site for testing or production use, so content would be added.  At some later date, a change* to the design would be needed and I would take a copy of the design only, make the change and then apply the updated design to the existing site. Content would be maintained but the new design changes would be applied. 

      *A change might mean creating new functionality on an existing element, adding new elements or changing an existing element.

How best should this be done in WSS?

Thank you in advance!

Is it possible to change the title bar background and the font style on default template?



Is there any way to change the default top link /title bar picture and the fonts of the title without breaking anything in the layout/structure?

I have changed the theme to Obsedian and I would also like to change the picture of the title bar of this theme and also the font/style of the title, top link bar, menus..etc. Is there a way to do this?

Please note: I am using WSS 3.0 and I am not the Administrator of the sharepoint. I am only the site admin of some sites on this sharepoint. I can do some basic customization using SPD.

Basically, what I am trying to do is that I want to set up a sharepoint site, however I want to make it NOT look like a sharepoint site.Well I know this is possible, but for my case it might be just partially possible due to the limitation that I am not the Site collection admin and hence I do not have direct access to the server itself.

What I want is to hide most of the sharepoint links/menus/bars, etc and use my own buttons/hyperlinks etc .. for user to navigate on the sites.

Thanks in advance for your help/advices.



Trying to set Calendar Time Interval Using Calculated Column, but getting Error



So i was trying to use a calculated column that added 7 days to the start date of a calendar item. The calculated column worked fine because i checked with several tests. Then i tried using the Column as the End Time in the Time Interval Setting in the Calendar View. This broke Sharepoint. Not the normal graceful error im using to seeing from Sharepoint but the Server Error Page when a dump happens in a ASP page. I havent enabled the full error page because i assume its not like i can fix it, i dont have the source code.


Does anyone else experience this? If so is it a known problem and being worked on?




computed column specification - When is it calculated?

on insert , select...?  It's better than Trigger? thanks.  

Sharepoint: In Calculated Column, Code with multiple "IF" condition does not work.

Implemantation:  Calculate expected resolve date exclude "Saturday" and "Sunday"  based on Priority and Severity.Columns are:1. Priority:2. Severity:3. Raised on: Date record createdCode: Below is the code which contains multiple "If" conditions. For quick undersatnding, i separated major If condition. Below code does not work and sharepoint gives me Sytax error message. =IF(OR(Priority="Critical",Severity="Critical"),IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+3,[Raised on]+1),     IF(OR(Priority="HIGH",Severity="HIGH"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+4, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+4,[Raised on]+2)) ,   IF(OR(Priority="MEDIUM",Severity="MEDIUM"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+3),"dddd")="Saturday",[Raised on]+5,[Raised on]+3)) ) ,   IF(OR(Priority="LOW",Severity="LOW"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+6, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+6, IF(TEXT

Custom Site Column in MOSS 2007

Hello, We have a request to add List in a List, for example, one of the column in the list should contain a table...so, created a custom column "Column with HTML Table" from the list of publishing fields...but, somehow, I dont seem to find that site column any more... That column type is "Publishing HTML", and it allows to define HTML table. I am unable to add a screenshot here...so, any clues? Also, can we copy the custom site column as a template and move it to another Site Collection? Regards, Kishore.  Kishore

Use Sharepoint Calendar Start Time field in calculated column

I'm trying to limit the calendar view to current week using the Sharepoint defined field Start Time. However, when I display the serial number behind the Start Time it looks like it is actually giving me the serial number for the Created Date field. I believe it is because the appointment is reoccurring but I'm hoping there is a way around it. I created a new testdate field and manually entered the date and set those appointments as all day events however they are not reocurring appointments. The testdate returns the correct serial number however the start time returns an incorrect serial number. SerialNumber1=DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time])) SerialNumber2=DATE(YEAR([testdate]),MONTH([testdate]),DAY([testdate])) Start Time  SerialNumber1 Testdate  SerialNumber2 8/31/2010 40420 8/31/2010 40421 8/31/2010* 40405    9/1/2010* 40405    9/2/2010* 40405    9/7/2010 40427 9/7/2010 40428 9/13/2010* 40405    9/14/2010 40434 9/14/2010 40435 9/14/2010* 40405    9/15/2010* 40405    *These are reoccurring appointments scheduled as all day events. The others were entered as one time appointments scheduled as all day events.

Navigation settings not applied when site created from template?

Hi, I created a customized site on MOSS and disabled Quick Launch and enabled Tree View on it. But when I create new site from this template it has Quick Launch enabled and Tree View disabled. I downloaded the STP file and looked inside and in the details <Details> ... <EnableTreeView>1</EnableTreeView> <EnableQuickLaunch>0</EnableQuickLaunch> ... </Details> Does anyone have a clue why it does not work correctly? Does this work for you correctly?  

Change Default Column Value programatically

On a Document Library Settings Page, there is a new setting in SP2010: "Change Default Column Value". Changing the default value of the Field is different from this value. Does anyone know what this value is and where to set it programatically? Also, what libraries is this setting available on? This code updates the field's default value but not the property mentioned above: SPField field = list.Fields["Column"]; field.DefaultValue = "DefaultValue"; field.Update(); Thanks!

hide column in insert template

Hello.  I would like to hide a foreign key column in an insert template.  It is auto populated with jQuery, and it would be great if this column was also hidden from view.  How is this done?  Thank you. 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend