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
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
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
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
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
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
SharePoint Designer: Set a multiple checkbox field with a workflow
Separate the fields with “;#” and no spaces. Example: [field1];#[field2]