Direkt zum Hauptbereich

Posts

Es werden Posts vom August, 2009 angezeigt.

Sharepoint: Field with month portion of the current date

Problem: I need a field which holds the month and the year portion of the current date. This field should be auto-filled when an entry is created. Although the field is autofilled, it should be editable by the user later. Problem detail: 1) A calculated field will no show in the Editform.aspx or in the NewForm.aspx. So it is not editable. 2) Formatting of dates in workflows is not possible with Sharepoint Designer. Solution: 1) Create a helping field, i.e. month-help, which is a calculated field with your formula, i.e. =TEXT(MONTH(Created),"00")&"."&TEXT(YEAR(Created),"00") Attention: Formatting to i.e. 08 for August does not work with "MM". It works with "00". 2) Create the "real" field, i.e. month. 3) Create a workflow which starts whenever an item is created and do this action: Set month to month-help.

Use Me or Today in Sharepoint calculated field

Error message: "Calculated columns cannot contain volatile functions like Today and Me. " But you can!!!! Solution: 1. Create a field (no matter what type) called Me or Today depending what you want to use. 2. Create your calculated field and use Me or Today like you want to use it. 3. Delete the first field: Me or Today. Ready. Now your calculated field will use Me=the user which is me or Today=the day today.