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:
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…)
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…)
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:
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…)
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
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.