Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Formulas and XPath   (RSS)

“Invalid Data” error when calculating the result of 2 or more fields

Posted Thursday, April 17, 2008 1:30 PM by infopath
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...
1 Comments

Calculating Elapsed Time…without code!

Posted Wednesday, February 21, 2007 6:45 AM by infopath
How many times have you needed to calculate the difference between time entries…only to find out the only way to accomplish this was to write custom code? Well no more! If your time entries will not cross days, then you can use a number of functions and Read More...
27 Comments
Filed under:

Attachment(s): ElapsedTimeSample.xsn

Calculating new, default date and time values

Posted Monday, February 19, 2007 5:43 AM by infopath
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...
0 Comments
Filed under:

Attachment(s): DailyTaskPlanner.xsn

Firing rules when removing InfoPath controls

Posted Monday, December 11, 2006 6:42 AM by infopath
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...
1 Comments
Filed under:

Attachment(s): RulesOnDeletionSample.xsn

XPath Powers: Calculating Totals

Posted Monday, December 04, 2006 6:13 AM by infopath
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...
2 Comments
Filed under:

Attachment(s): OrderTotal.xsn

Conditional Default Values

Posted Monday, November 27, 2006 5:56 AM by infopath
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...
5 Comments
Filed under:

Attachment(s): ConditionalDefaultValues.xsn

Powerful Declarative Logic: Phone Number Parsing

Posted Monday, November 13, 2006 7:32 AM by infopath
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...
7 Comments
Filed under:

Attachment(s): PhoneNumberFormatting.xsn

Complex Data Validation

Posted Wednesday, October 25, 2006 8:09 AM by infopath
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...
1 Comments
Filed under:

Do it anyway: Submitting with Data Validation errors

Posted Monday, October 09, 2006 9:41 AM by infopath
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...
5 Comments
Filed under:

Enforcing unique values in a repeating list

Posted Thursday, August 10, 2006 9:50 AM by infopath
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...
1 Comments
Filed under:

Goodbye WhoAmI! Hello userName()

Posted Friday, May 26, 2006 8:39 AM by infopath
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...
8 Comments
Filed under:

Check if form is new using roles, not code

Posted Thursday, April 13, 2006 3:00 AM by infopath
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...
2 Comments
Filed under:

Email Submit "To" line (loops in formulas)

Posted Wednesday, April 05, 2006 2:54 PM by infopath
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...
5 Comments
Filed under:
 
Page view tracker