Microsoft Office 2010 Engineering
The official blog of the Microsoft Office product development group

Browse by Tags

Browse by Tags
  • Blog Post: “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 or Microsoft for that matter. The floating point...
  • Blog Post: 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 the changes. The expressions are very similar to...
  • Blog Post: 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 or time based on a previous value. To illustrate...
  • Blog Post: 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 be sufficient. One of them is firing a rule when...
  • Blog Post: 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; it is still possible to perform dynamic calculations...
  • Blog Post: 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 the rule is only applied when that field that changes...
  • Blog Post: 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 format “(000) 000-0000” may be a little constraining...
  • Blog Post: 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 wants to use this logic: IF (State...
  • Blog Post: 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 the cost category. The employee, however, can't...
  • Blog Post: 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 2003, you're still in luck, this blog entry is for...
  • Blog Post: 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 .   In InfoPath 2007 we built an easier way....
  • Blog Post: 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 opens the form. Here's how. Click...
  • Blog Post: 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 in InfoPath 2007 Beta , but since most of you don...
Page 1 of 1 (13 items)