Welcome to MSDN Blogs Sign in | Join | Help

InfoPath Team Blog

Tips and tricks to get the most out of Microsoft InfoPath

News

  • For questions, comments, and feedback please use the public newsgroup: microsoft.public.infopath
    This is provided "AS IS" with no warranties, and confers no rights. Use of included script samples and forms are subject to the terms specified in the Terms of Use.

Browse by Tags

All Tags » Formulas and XPath   (RSS)
“Invalid Data” error when calculating the result of 2 or more fields
When you create a calculated field in an InfoPath XML node (field) you may find that some of the resulting calculations produce an “Invalid Data” error: This behavior is a known issue when doing floating point calculations and is *not* specific to InfoPath Read More...
Calculating Elapsed Time…without code!
UPDATE: Due to the number of requests for adding more columns to this sample, I have re-designed the sample. If I have time in the future I will update the steps to create this new design; however, for now you can download the updated design here to see Read More...
Calculating new, default date and time values
Similar to performing elapsed time calculations, creating a new date or time value based on a previous value used to require code – not anymore! With InfoPath 2007 you can use the new “ addDays() ” and “ addSeconds() ” functions to calculate a new date Read More...
Firing rules when removing InfoPath controls
The built-in support InfoPath offers for rules can be used to generate a relatively large and powerful set of conditions that trigger a rule action. There are some scenarios though were the default options available through the condition builder may not Read More...
XPath Powers: Calculating Totals
InfoPath makes it trivial to track totals for repeating structures, such as customer orders. Just create a repeating table of line items, and sum up the totals for individual line items. However, sometimes, totals for line items may not be available; Read More...
Conditional Default Values
Sometimes you want the default value of a field to be dependent upon a condition. However, there isn’t any direct functionality to support IF statements in the default values of fields. Substituting a rule for a default value only gets you so far, as Read More...
Powerful Declarative Logic: Phone Number Parsing
When entering phone numbers in InfoPath, you can validate that it is a phone number easily enough (Data Validation->field1 “matches pattern” Phone number), but what do you do if the input does not match that pattern? Asking users to exactly enter the Read More...
Complex Data Validation
How do you test more than 5 parameters? How do you group parameters? One answer to both questions, is to have multiple validations in one statement. We'll look into these problems in detail in the case studies below. Case Study #1 Problem : a form designer Read More...
Do it anyway: Submitting with Data Validation errors
When building a workflow solution using InfoPath, it is often necessary to enforce data validation for some, but not all users. For example, in a simple expense report workflow, Employee->Manager->Accounting, the manager may be required to specify Read More...
Enforcing unique values in a repeating list
Have you ever created a form which allows the user to choose items from a list and you wanted to make sure the user doesn't choose the same item twice? If you've got InfoPath 2007 you can use the new Multi Select List Box , but if you've got InfoPath Read More...
Goodbye WhoAmI! Hello userName()
Anyone who's tried to get the username of the person filling out their form in InfoPath 2003 knows the WhoAmI web service . That was the only way to get the username without writing Visual Basic or C# managed code and using System.Environment.UserName Read More...
Check if form is new using roles, not code
Ever want to add conditional formatting or special rules that only fire if your form was just created? For example, you want to show one view by default when someone creates a new expense report, but you want show a summary view for everyone else who Read More...
Email Submit "To" line (loops in formulas)
Everyone likes InfoPath's email data connection because it lets you collect forms using email only, no other infrastructure required (no need for Windows SharePoint Services, SQL Server, or even a file share). We've built even more Outlook integration Read More...
Page view tracker