Author Archives: JP Lavoie
InfoPath: Make a field force the contents to be uppercase or lowercase.
Under Fields, Right Click on the field and choose Field Properties. Under the Default Value section click the “fx” button beside the blank field. To force the field to be upper case put in this formula: translate(., “abcdefghijklmnopqrstuvwxyz”, “ABCDEFGHIJKLMNOPQRSTUVWXYZ”) To force the field to be lower case put in this formula: translate(., “ABCDEFGHIJKLMNOPQRSTUVWXYZ”, “abcdefghijklmnopqrstuvwxyz”)
SharePoint Designer: Set a multiple checkbox field with a workflow
Separate the fields with “;#” and no spaces. Example: [field1];#[field2]
SharePoint/InfoPath: Get item Attachment URL for link
In InfoPath add a hyperlink (under the INSERT tab) Under link to click Data Source. Click the data source icon – Click Show advanced view at the bottom – Click the “+” next to dataFields – Click the “+” next to my:SharePointListItem_RW – Click the “+” next to Attachments – Click on :attachmentURL Click OK Beside Display choose whatever text you … Continue Reading
SharePoint: Enable Audience Targeting
You will need to first go to the top level site in the Site Collection. Click on Site Actions Click on Site Settings Under the Site Collection Administration heading click Site collection features Next to SharePoint Server Publishing Infrastructure click Activate You will notice in site settings under look and feel, Quick Launch is not changed to Navigation and you … Continue Reading
SharePoint: Add a Print Button to any page.
Add a Content Editor web part and add the following code to it: <input type=”button” value=” Print this page ” onclick=”window.print();return false;” />
SharePoint: Export list to another site collection.
I often create a list solution before I have a site or site collection created to put it in. Here is a way to get that list to another site or site collection. Export the list Go to List Settings Under the Permissions and Management section click Save list as template. This allows you to create a list based on the … Continue Reading
SharePoint: Hide Qucik Launch via URL
This little snippet is something that you can tack on to the end of any URL in SharePoint to get the quick launch side bar to disappear and there are two versions of it. One to keep the scroll bars, and one that doesn’t. Putting IsDlg=1 onto the end of a form url makes the quick launch bar disappear as well … Continue Reading