Friday, September 19, 2008

Hiding Rows in a table based on a condition

Situation:
Sometimes you need to only show the records in a repeating table, depending on a selected value of a dropdownbox. Anoterhway to say it, you need to hide all rows where the value isn't equal to the selected value.

Solution:
- Create a Repeating Table (Menu Table -> Insert -> Repeating Table)
Follow the wizard and select the field you want to show.
- Update the table layout if needed
- Right-click a row and select conditional formatting
To be sure to select the row, make the control smaller and the column bigger, this
way you created an empty space



- Set the conditions



- Test your form.

Wednesday, September 17, 2008

Best Practices for Deploying InfoPath 2007 Form Templates to a Production Environment

How do I efficiently move a form template from my development environment to a production environment?

Unfortunately, there is not a simple answer to this question. Even with the introduction of InfoPath Forms Services in the 2007 Microsoft Office release, a lot of planning is still needed to configure and deploy a form template for InfoPath-only and browser-compatible form scenarios in both a development and production environment.


The following article examines some of the steps you can take to make InfoPath form template deployment less painful


Link: http://msdn.microsoft.com/en-us/library/cc704269.aspx

How to add User and Creation info to a document

Situation:
Within a profesional environment, extra information is added to documets, like creation date username etc. automatically.
So how to do this in nfoPath 2007

Solution:
1. Open an document
2. Add Created By + add a Textbox next to it.
- Change the name to CreatedBy
- Value = username()
- Display: Read-Only
- Size: Set Height and Width to auto
- Padding and Margins: Set all values to 0


3. Add the word on after the previous created textbox
4. Add a Textbox next to it.
- Change the name to CreateDate
- Value = today()
- Display: Read-Only
- Size: Set Height and Width to auto
- Padding and Margins: Set all values to 0

Result: