Important things too know about using TODAY in a calculated column! http://www.linkedin.com/news?viewArticle=&articleID=185992482&gid=93094&type=member&item=28659782&articleURL=http%3A%2F%2Fblog%2Epentalogic%2Enet%2F2010%2F09%2Ftoday-sharepoint-calculated-default-values%2F&urlhash=q1qF&goback=%2Egde_93094_member_28659782
Dataview Web Parts
How to Repair/Replace a broken SharePoint List Form
A life saver of an article from Ben. I used these steps to recreate the default dispform.aspx page!
HTML
Add Site Quick Launch Menu to a Web Part Page
You need to edit a line of code in SharePoint Designer Go to Code View FIND: “Placeholderleftnavbar” Delete Row (approx. line 47) that has that above code OK to Change site definition
Best Practices
Creating Single Server Sign On from Central Admin
SSO Single Server Sign On Add Application Services in Central Admin Operations Tab Manage Settings for SSO Ensure SSO Service is Running (If you get a “Failed to Connect…”) Start/ Admin Tools/ Services Open Microsoft Single Sign On Services Log On Tab Best Practice to use to Server Admin Account (from A.D.) not the Local [...]
Calculated Columns
Nested If Then Statement with 15 Conditions
Another GREAT tip from Christophe at Path to SharePoint =IF([Status]=””,”Black”,IF([Status]=”Choice1?,”Red”,IF([Status]=”Choice2?,”Gold”,IF([Status]=”Choice3?,”Green”,IF([Status]=”Choice4?,”DarkBlue”,IF([Status]=”Choice5?,”DarkCyan”,IF([Status]=”Choice6?,”DarkRed”,IF([Status]=”Choice7?,”Gray”,””))))))))&IF([Status]=”Choice8?,”MediumSlateBlue”,IF([Status]=”Choice9?,”SpringGreen”,IF([Status]=”Choice10?,”MidnightBlue”,IF([Status]=”Choice11?,”Sienna”,IF([Status]=”Choice12?,”SlateGray”,IF([Status]=”Choice13?,”OliveDrab”,IF([Status]=”Choice14?,”Gray”,””)))))))
Excel Services
Excel Services Does Not Support…
Published Excel Spreadsheets do NOT support VBA macros Toolbox controls XLM Sheets Embedded Clip art Cell and Sheet BG Pictures IRM Enabled Workbooks Forms Controls MS 5.0 Dialogues Active X Controls DDE Links Query Tables Split Panes Headers Footers Page Layout View Cell Patterns Zoom
Page Layout
How to Modify the Layout of a Default.aspx Page in MS SharePoint Designer
http://www.5min.com/Video/How-to-Modify-the-Layout-of-a-Defaultaspx-Page-in-MS-SharePoint-Designer-80729198?
Page Layout
How to Customize List View Pages in MS SharePoint Designer
Good demo for SPD beginners. http://www.5min.com/Video/How-to-Customize-List-View-Pages-in-MS-SharePoint-Designer-80729533
Tips & Tricks
Collapsing Multiple-line of Text in a Webpart
I’ve used this before. Great solution for collapsing a multiple-line of text field. Solution created by Paul Grenier and enhanced by Pater Allen.
SharePoint Designer
Custom Group Order in a SharePoint List: Dynamic Grouping
Groups can be dynamically ordered by the number of child elements they contain.
Content Editor Web Parts
Adding Page Tabs in SP 2007
The Web Part can be used on a SharePoint 2007 site by anybody who has design or full control permissions (it is actually based on a Content Editor Web Part). The installation does not require server access.
Other Bloggers
Display Form and Edit Form Customizations
Great idea from Jim Howard for creating section breaks in a Display Form or Edit Form.
Tips & Tricks
SharePoint Page Modes
Sometimes there are instances where page functionality is not operating as it should. The GUI is not letting you edit a page or remove a corrupt web part. Here I will start listing those URL appendices that will get you to the mode you need: Put a page in EDIT mode.
Central Administration
LASPUG Meeting 9/24
Index Crawl: minimum 15 min. 5,000 sites takes 15 min. to replicate When you create an SSP you need to create a crawl account If crawl account is Admin Right, then it will crawl major and minor versions. stsadm-0 command resets Admin password Manage File Type to include PDFs ifilter.org: install on front end server.
Calendars
With WSS3 (or MOSS 2007) and Outlook 2007, we have the ability to view & edit SP Calendars from Outlook.
Thanks to Rob Fisch on LinkedIN. With WSS3 (or MOSS 2007) and Outlook 2007, we have the ability to not only view activity from multiple calendar sources in one virtual calendar view, but we can also edit these SharePoint calendars directly from Outlook. We can also tack on Outlook reminders to SharePoint Calendar events. Read [...]
Document Libraries
Visio Documents in a SP Library
See discussion at microsoft.public.sharepoint.portalserver
Workflow
How to get an SPD Workflow to Run at a Specific Time – Employee Vacation Reminder: Part 1
Solution provided by Dessie Lunsford at EndUserSharePoint.com.
InfoPath
Creating a Multiple selection List Box in browser enabled InfoPath form.
Solution provided by Mehul Bhuva at SharePoint Fix.
Search
Does anyone know if Search results are filtered based on permissions?
Good question, and more important, great feedback from Jie Lie. http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionID=14186886&gid=42512&trk=EML_anet_qa_ttle-cThOon0JumNFomgJt7dBpSBA SharePoint search result is trimmed by permissions – which is working with content sources like SharePoint, File Share and Lotus Notes (if you choose to not ignore security). But keep in mind. Security info is picked up at indexing time OOB. So if you [...]
Workflow
Workflow History is Hidden by Default
Workflow History can be found at /lists/Workflow%20History