Tag Archives: SharePoint 2010

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

Critical Error: Internet Explorer 11 and SharePoint 2010

When Microsoft updated Internet Explorer to 11 we started getting the following error on our forms: ” Object doesn’t support property or method ‘addEventListener’ ” We found that the fix is to add the following java script to the bottom of the Master Pages right above the </body> tag: <script language=”javascript”> /* IE11 Fix for SP2010 */ if (typeof UserAgentInfo.strBrowser … Continue Reading

Posted in SharePoint, SharePoint Designer | Also tagged , , 3 Comments

SharePoint: Get a calendar event (.ics) from a list item.

I needed to send a calendar event in an email that a workflow generated and thankfully SharePoint offers a really easy way to do this through the url: https://<site url>/_vti_bin/owssvr.dll?CS=109&Cmd=Display&List=<list ID>&CacheControl=1&ID=<ID>&Using=event.ics Replace the <bold> areas with your own info and you are ready to go. The list ID will look something like this: D386DD15-6767-47E2-9743-28B7A24C905D It can be found in the url … Continue Reading

Posted in SharePoint | Also tagged , , , 2 Comments

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 – InfoPath: Validate attachment URL for special characters

I did a ton of searching for this and could only find 1 solution. With this solution, if you have special characters in your file name and hit submit a warning pops up and tells you that  you have special characters in your file name. It will not let you submit the form until that is fixed. The solution is … Continue Reading

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

SharePoint: Duplicate or Copy a Page

I created a web part page added a list view and then added content web part and created some CSS tweaks to the page. I then wanted to use those same tweaks but to a different view of the list. I needed to duplicate the page. SharePoint does not offer an easy way to do this. First I tried downloading … Continue Reading

Posted in SharePoint | 7 Comments

Infopath: Limit decimal places to display for a calculation

We were adding up monetary fields and found that the calculation was giving us to many decimal places. Below you will find the solution to get them back to 2: Round to 2 decimal places:  round((calculation) * 100) / 100 Round to 3 decimal places: round((calculation) * 1000) / 1000 Example: Formula: round((1.5555*42)*100) / 100 result: 65.33

Posted in InfoPath, SharePoint | Also tagged , 4 Comments