Return Solution Version in an Expression Box

Folks, Don’t claim to understand this 100%, but I do know it works.   Put this formula inside a formula dialog box for an expression box on your form, and when you invoke it it’ll show you the current solution version – without having to write code! substring-before(substring-after(/processing-instruction(), ‘solutionVersion=”‘), ‘”‘) Thanks, Tim  Edited on 10/7 per…


Manipulating Secondary Datasources using C#

Hey folks, Like many of you, I’m being dragged into the land of managed code in order to achieve things that I’ve had oodles of JScript code samples to do for a long time.   The InfoPath Toolkit for VS.NET allows you to write code in either VB or C#; since C# looked more like JScript,…


Increasing the TimeOut Value on Database Submit

Folks,    Had an issue recently where a user of one of my solutions had pretty terrible bandwidth to the SQL server where they needed to submit data.   The default timeout value on submits is 30 seconds.   As it turn out, the default for queries too is 30 seconds.   You can reset that value fairly easily…


Functionality Lost in InfoPath 2007 "Web-Enabled" Forms

Quick update to this post (6/7/2007).   Saw this article http://msdn2.microsoft.com/en-us/library/aa945450(VS.80).aspx which is pretty comprehensive on this topic.   Worth a read.  Folks, Getting tired of waiting for a list to be published, so will start to build my own from scratch as I go along.   Many of you know that InfoPath 2007 will have the ability to…

4

Awesome Webcast on Digital Signatures in InfoPath

Folks, I had to skill up recently on the use of digital signatures in InfoPath, and this webcast I found is pretty amazing.   I had no idea how rich the support in InfoPath for digital signatures was, and this webcast goes into *deep* detail.   I found myself dozing off after about 45 minutes, but that…

1

Drop the Solution Version Number in a Field

Simple question, simple answer.   Let’s say you want to tell a user what version of the solution they are using.   Technically the way the InfoPath works they don’t need to worry about that, but let’s just say you wanted to tell them.   The following code shows you how to grab a node and push the…


Dynamic Efficient Querying of Large Datasets

Folks, I have done a lot of work with making InfoPath live up to it’s promise of providing an offline experience.  That promise becomes a lot harder to fulfill when you are querying large datasets in your form to populate one dropdown lists or more likely a series of cascading dropdowns.   The issue is that…


Jumping Around in a Long Form

Hi Everybody, Hey sometimes you get a long form that requires you to do a lot of scrolling around to get to to the different sections.   I use a lot of tricks with views and/or conditionally hidden sections to make things look like they all fit on one page.  Nevertheless, there are some of you…

1

Preventing The Average User From Designing Forms

Folks, Although I think it severely impairs the value proposition of using InfoPath, I get asked a lot how a company can deploy InfoPath to every desktop and yet control who has the ability to build and post new forms.   It turns out that it’s pretty easy to do via the Adminstrative Templates that ship…

3

Adding Data to Dropdowns and Requerying in One Step

Folks, Ran into a sticky issue the other day where a customer wanted a drop down list to be bound to a table (they put it as enforced referential integrity), but wanted to allow the users the ability to add values to the dropdown on the fly.  The idea that I came up with was…

1