Dani's Middleware

My problem: I "accidently" deleted the NewForm.aspx and then I got the errors: If you click New to create a new item in the list, you receive the following message: Invalid page URL: If you click an existing item in the list, you receive the following error message: An unexpected error has occurred I had a backup copy of my NewForm.aspx, but it did not work to just put it back into place. (see also here: http://support.microsoft.com/kb/935504 ) I also had the field "new item form" in list properties empty (see image) and I could not fill the value. Whenever I saved a change it was empty again, when I called the properties again. Here I found my rescue: To view the original information: http://blogs.msdn.com/dszabo/archive/2007/02/20/custom-list-newform-aspx-ruined-in-wss-3-0.aspx This is just to keep the information in case Davids page might be unavailable: 1. Open NewForm.aspx and EditForm.aspx in Sharepoint Designer 2. Copy the code for the ListFormWebPart contro...

SP calculated fields: http://abstractspaces.wordpress.com/2009/05/02/common-date-time-formulas-for-sharepoint-calculated-fields/ cw =INT((Created-DATE(YEAR(Created),1,1))/7) This is for calendarweeks as in Outlook: cw 1 is the first week in the year with a Monday. =INT(([Date Production]-DATE(YEAR([Date Production]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Date Production]),1,1)),"d")-1))/7)

Name the macro: Auto_open() Sub Auto_open() End Sub Auto_close() will also work.

Unfortunately there is no explicit function to clear a field within a workflow, but there is a workaround. It works similiar to the [Me] and [Today] trick. 1. Create a column. It does not matter how you name it or which type it is. 2. In your workflow use "Set Field in Current Item" like "Set to . 3. Save your workflow. 4. Delete the new column. Thanks to Nammy . :-)