Out of the Box

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

Posted in InfoPath, SharePoint | Tagged , , | Leave a comment

SharePoint Designer: Set a multiple checkbox field with a workflow

Separate the fields with “;#” and no spaces.

Example: [field1];#[field2]

Posted in SharePoint, SharePoint Designer | Tagged , , | Leave a comment

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 would like it to display.

Click OK

Posted in InfoPath, SharePoint | Tagged , , | 1 Comment

SharePoint: Enable Audience Targeting

You will need to first go to the top level site in the Site Collection.

  1. Click on Site Actions
  2. Click on Site Settings
  3. Under the Site Collection Administration heading click Site collection features
  4. 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 can add an audience to any web part.

Posted in SharePoint | Tagged | Leave a comment

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;” />

Posted in SharePoint | Tagged | Leave a comment

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

  1. Go to List Settings
  2. Under the Permissions and Management section click Save list as template.

This allows you to create a list based on the list you exported inside your current site collection.

Export list to another site collection

  1. On the top level site of the site collection containing the list that you want to copy, click Site Settings.
  2. In the Galleries section, click List templates.
  3. On the List Template Gallery page, click the check box next to list template that you want to export.
  4. In the ribbon Click Download a Copy.

You should now have a .stp file. Now go to the site collection you want to copy the list to.

  1. Click Site Settings.
  2. In the Galleries section, click List templates.
  3. Click on the Documents tab.
  4. Click Upload Document.
  5. Click Choose File and navigate and choose the .stp file you downloaded.
  6. Click Ok

When you go create a new list, you will see the template you uploaded as one of the options.

Posted in SharePoint | Tagged | Leave a comment

Sample Page

Posted in Uncategorized | Leave a comment

Welcome to Elon Tech Geeks!

We are the tech geeks of Elon University and for over 10 years we have been solving Elon’s technology problems 1 solution at a time. We figured, that for the greater good we should share some of these higher education based solutions so that others that run into these same issues can see how we did it! Right now we will be starting off with some of the solutions and tips and tricks that we have amassed for Sharepoint, WordPress, and general web based tips and tricks. Please note that many of these solutions will deal with code and other non basic information.

Posted in SharePoint | Leave a comment

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 as the scroll bar on the right

Putting IsDlg=2 onto the end of a form url just makes the quick launch bar disappear

Example:
https://sharepoint.edu/yoursite/Lists/yourlist/Item/newifs.aspx?IsDlg=2

Posted in SharePoint | Tagged | 2 Comments