Tag Archives: SharePoint

Sharepoint / InfoPath: Use a Multiple Line of Text field in a Calculated Column

I stumbled upon this by accident. Try to do this by adding a multiple line of text field to a calculated column in SharePoint and it will tell you that it cannot be done. But it can with the use of InfoPath and some trickery: For this example I will call the field that will be the multiple line of text … Continue Reading

Posted in InfoPath, SharePoint | Also tagged , 2 Comments

Sharepoint / Sharepoint Desginer / InfoPath: Create a dynamic link that opens a particular InfoPath view in a SharePoint dialogue box with it’s own edit icon

I found that I needed to have 2 views in SharePoint that both had an Edit Icon but each icon need to point to a different InfoPath view. I wanted the item to pop up in the dialogue box just like the normal edit icon did.  I took a look at how SharePoint was encoding theirs and was able to mimic … Continue Reading

Posted in InfoPath, SharePoint, SharePoint Designer | Also tagged , , Leave a comment

SharePoint Designer: Create a dynamic link to your item in a workflow email using Encoded Absolute URL.

A better way to put a url in an email to the current item. Use the Encoded Absolute URL field. Before I would do something like this for the url of the link that I wanted to send someone to edit: https://sharepoint.school.edu/sitename/list/Item/Editifs.aspx?IsDlg=2&defaultview=VIEW&ID=[ID] Now I put the following: [Encoded Absolute URL]/../Item/Editifs.aspx?IsDlg=2&defaultview=VIEW&ID=[ID] Using Encoded Absolute URL puts in a url that looks … Continue Reading

Posted in SharePoint, SharePoint Designer, Uncategorized | Also tagged Leave a comment

Infopath: Get User Profile Data into your form

I needed to populate a drop down list with all the departments in my university (this is a field that is part of the user profile data.) Through my searching I stumbled through the UserProfileService.asmx and could not easily figure it out. I finally stumbled on a post from the famous Laura Rogers that explained a super easy way to … Continue Reading

Posted in InfoPath, SharePoint | Also tagged , , Leave a comment

InfoPath: Calculate Age based on Date of Birth date picker.

I needed to calculate the age of a person to run some validation rules on my form. This is how I did it: Create a Date Picker field (I named mine Birth Date) and place it on the form. Create a Number field (I named mine Age.) You don’t have to place it on the form, though you can initially … Continue Reading

Posted in InfoPath, SharePoint | Also tagged , , 2 Comments

InfoPath: Validate that form has an attachment

I have found that I often need to make sure that people attach a file before they can submit. InfoPath will not let you run a rule on attachment fields however there is a way around it: Create a single line of text field to use as the validation field (name is something like Attachment Validation). This field is also … Continue Reading

Posted in InfoPath, SharePoint | Also 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 | Also tagged , Leave a comment