Sandoval's SharePoint Spot

A personal collection of links, notes and shortcuts.

  •     
  • Biography
  • Bloggers I Follow
  • Links and More Links
  • Welcome
  • 16
    Sep 11

    Can not add the user because a user with that name already exists …

      Posted by Sandoval
      0 comments

    See solution here:

    http://rehmangul.sauftveyr.com/2008/04/23/can-not-add-the-user-because-a-user-with-that-name-already-exists/

    Worked for me.

      Security, Tips & Tricks
      Errors, Permissions, Security
     
  • 19
    Oct 10

    Illegal Characters

      Posted by Sandoval
      0 comments

    Here is a list of common illegal characters that must not be included in web urls – - – and not used when creating file names that will be used on the web:

    # % & * { } \ : < > ? / +

    In addition to this list it is prohibited to have consecutive periods in the URL (or file name). It’s also prohibited to start or end with a space or underline, or to end with a period.

    Even though it isn’t illegal to use commas or spaces in a url – it is best to not use them for consistency across different server platforms.

    These rules are Web Standards.

      Tips & Tricks
      Characters, Illegal, URL
     
  • 2
    Sep 10

    Using TODAY As a calculated column

      Posted by Sandoval
      0 comments

    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

      Calculated Columns, Functions and Formulas, Tips & Tricks
      Calculated Columns, Date Field, Formulas & Functions, Today
     
  • 14
    Aug 10

    Add Site Quick Launch Menu to a Web Part Page

      Posted by Sandoval
      0 comments

    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
      HTML, Master Pages, Page Layout, SharePoint Designer, Tips & Tricks
      Code View, LeftNavBar, Quick Launch
     
  • 13
    Aug 10

    Nested If Then Statement with 15 Conditions

      Posted by Sandoval
      0 comments

    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”,””)))))))

      Calculated Columns, Functions and Formulas, Tips & Tricks
      Calculated Columns, If Then Statement
     
  • 20
    May 10

    Collapsing Multiple-line of Text in a Webpart

      Posted by Sandoval
      0 comments

    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.

      jQuery, Tips & Tricks
      Collapse, jQuery
     
  • 5
    May 10

    Display Form and Edit Form Customizations

      Posted by Sandoval
      0 comments

    Great idea from Jim Howard for creating section breaks in a Display Form or Edit Form.

      jQuery, Other Bloggers, Tips & Tricks
      DispForm, Display Form, Edit Form, EditForm
     
  • 25
    Apr 10

    SharePoint Page Modes

      Posted by Sandoval
      0 comments

    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.

      Tips & Tricks
      Edit Page, URL
     
  • 30
    Mar 10

    Creating a Multiple selection List Box in browser enabled InfoPath form.

      Posted by Sandoval
      0 comments

    Solution provided by Mehul Bhuva at SharePoint Fix.

      InfoPath, Other Bloggers, Tips & Tricks
      Checkbox, InfoPath, Multiple Items
     
  • 10
    Feb 10

    Access the task pane of an ASPX page

      Posted by Sandoval
      0 comments

    How to Quickly get to the task pane of an ASPX page.

    Add the following text to the end of the ASPX page.

    ?&toolpaneview=2

      Tips & Tricks
      Task Pane
     
Recent Posts
  • Can not add the user because a user with that name already exists …
  • 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.
  • Illegal Characters
  • Using TODAY As a calculated column
  • How to Repair/Replace a broken SharePoint List Form
Recent Comments
    Tags

    Alerts Attachments Calculated Columns Calendar Calendars Checkbox Compare Values Concatenate Contains Crawl Customize Date Field Edit Page Error Folders Form Letter Formulas & Functions History hyperlinks If Then Statement Illegal Characters index indexing InfoPath LDAP Query Master Page Migrate Minutes Move Content Multiple Items Notes Office Outlook Integration Repeat Characters Server Limits SharePoint Designer Solid Line SSP stsadm Task Pane Today Truncate URL Visio Word Count

    Feed
    •    Posts Feed
    •    Comments Feed
    • Archives

      • September 2011
      • April 2011
      • October 2010
      • September 2010
      • August 2010
      • May 2010
      • April 2010
      • March 2010
      • February 2010
    • Categories

      • Best Practices
        • Browsers
        • I.T. Know How
        • Tips & Tricks
      • Blog Spots
        • Other Bloggers
      • Code Library
        • HTML
        • jQuery
      • Microsoft
        • Excel Services
        • Functions and Formulas
        • InfoPath
        • Office
        • SharePoint Designer
      • SharePoint
        • Calculated Columns
        • Calendars
        • Central Administration
        • Content Editor Web Parts
        • Dataview Web Parts
        • Document Libraries
        • Error Messages
        • List/Document Library
        • Master Pages
        • Page Layout
        • Search
        • Security
        • Server Limits
        • SharePoint Forms
        • SharePoint Server
        • SSO – Single Server Sign On
        • Web Parts
        • Workflow
      • SQL

    Copyright © Sandoval's SharePoint Spot