My SharePoint Blog

You may create a workflow for your Discussion Board with SharePoint Designer 2007(SPD) to send email to the one who created the discussion whenever message is created or changed. 1.        Open your SharePoint site in SPD, click File->New->Workflow; 2.        Specify the name of your discussion (suppose it is “discussion”) board to attach the workflow to; uncheck allow workflow to start manually and check both start workflow when item is created and changed; click next; 3.        Click Conditions->compare discussion field, and set the condition to be: If Content Type equals Message.    (The discussion board contains two content type: discussion and message. Since SPD workflow cannot be associated specific content type, you may put a condition before send email activity so that email only send out to discussion creator by changing of message); 4.  ...

  To make a calculated column today on SharePoint like excel picture above is highly unlikely because the calculated columns c an not get the function = TODAY (). Therefore, there are tips to do today on calculated column in SharePoint. How: 1. Create a column with the name of the Today in SharePoint with date data type and default value have, like the image below: 2 . After a column by name earlier today , create another column with the name of whatever . I am here to take an example with the name get date with a data type and then calculated the formula is loaded with = Today , today here in which we get from the column created earlier and the data return is date and time . As the picture below: which I circled is that should we choose and content of the data return, why date and time because the value that we need to display the date be for la...

How to customize a calendar Navigator? It’s simple, but we must have SharePoint Designer. Because we will edit it with hard code. Do the following instructions: Step 1 : Create Calender List Using Calender Template. Inside the circle is the calendar navigator. Step 2 : After then, open our SharePoint Designer and paste the url link and open it. Step 3: After we open our site. Now we must search our calendar list in folder list and search file calendar.aspx.   Open the code by double clicking on file calendar.aspx. Step 4: After we open the source code, we must search SharePoint Navigator code  under source code. After we found the SharePoint Calendar Navigator code, we must cut the code and move the code under SharePoint PlaceHolder main. After that save the page aspx and now we have a new customize calendar navigator like the following:   Finish . .  I hope this ...

To install add-in for use in office Excel 2007 Download and install the Excel 2007 Add-in : Synchronizing Tables with SharePoint Lists . ·                Start Office Excel 2007.          Click the Microsoft Office Button, Click Excel Options, and then click the Add-ins tab.          Select Excel Add-ins in the Manage drop-down list and click Go.            In the Add-ins dialog box, click Browser, navigate to the Excel 2007 SharePoint List synchronizing Add-in, and then click Ok.         In the Add-ins dialog box, verify that the SynchronizeWSSandExcel option is selected and then click Ok. Figure 1. The Add-Ins dialog with the Rwsplist opti on sele cted Publishing and Synchronizing Table Data to a Sharepoint Site Using the add-in is simple, as you see in the following steps.  ...