..:: I like SharePoint ::.. Rotating Header Image

InfoPath 2010

InfoPath Fill or empty a repeating table in browser-based form by using code-behind

Feb 24th, 2013
by Karsten Pohnke.
No comments yet

InfoPath is a powerful tool which can be customized by using rules or custom code behind. At one of my projects it was necessary to display some additional information from a database dependent on which checkbox the user clicked / checked. Another request to this was that the form has to be browser-enabled cause it should be displayed in a SharePoint environment.

So i have 3 Checkboxes: A, B, C. And i have a section with a repeating table which is structured like this:
RepeatingTable
—–FieldA
—–FieldB
—–FieldC
—–FieldD
—–FieldE

I use the onchange Event of each Checkbox which calls the function. Now let’s see how we can fill this repeating table with data: (more…)

InfoPath 2010/2013: UserInformationList query for current logged in user

Jan 24th, 2013
by Dennis de Vries.
1 comment
012413_1226_InfoPath2011.png

Sometimes you just want to use more information like just the user id within your InfoPath form. Now you are able to use the SharePoint webservices but it is also possible to query the userinformation list in SharePoint. The result looks like this: (more…)

InfoPath 2010/2013: Concat repeating table fields into one field with delimiter

Jan 24th, 2013
by Dennis de Vries.
No comments yet
012413_1050_InfoPath2013.png

Expect that you will create a summary section of a repeating table. In this sample we want to get all first names of a repeating table and want to use a semicolon as delimiter. We will use a calculate value to store all this names into one field. The result looks like this:

(more…)

InfoPath 2010/2013: MailTo Function for InfoPath Forms

Jan 23rd, 2013
by Dennis de Vries.
2 comments
012313_0823_MailToFunct1.png

Sometimes you just want to place a MailTo Link on an InfoPath Form. This link only open your favorite mail client application and fields like subject, body or mailto are filled out by data from the InfoPath form. (more…)

SharePoint 2010 & InfoPath Setting date field by using rules

Jan 19th, 2013
by Karsten Pohnke.
No comments yet

I already posted about how to set a date field in infopath by code behind. If you like to read this post, just look at this post. But this post i am gonna explain how to set the date field correctly by just using rules or the formula.

So we should look at first at the anatomy of the date. Mostly you know the date as

  • 18.11.2012
  • 2012-11-18
  • 11/18/2012

or whatelse. It does not matter. You have your date field and set the format as you like. But you can see that infopath saves the date always in this way:

yyyy-mm-ddThh:mm:ss – example: 2012-11-18T12:00:00

If you know that, you are able to use formulas to fill a date field with correct dates. So you have to use a “T” as separator between the date and the time.

(more…)

← Earlier Posts