InfoPath Dev

The "simpler formula" you provided (first example above) did it!  I cannot thank you enough.  I've spent an unbelievable amount of hours trying to do this.  Next time I won't wait so long before raising the flag and asking for help.  Jimmy, you are my hero!

Thanks for the above reply but I need to send the form info as part of a mail rather than sending the form itself. Luckily i've found that there is a simple menu option within the file menu that lets you do this (well embarrasingly my non-technical boss found it for me). Now i'm trying to work out if I can add the menu action to a ...

Hi, I have just designed an infopath form which I want to roll out; however I'm not ready to create the workflow for it yet. Basically i'm happy for the initial user to fill in a form and then sends a read only version as part of an mail message. This can then be forwarded and approval added manually as required. Thankfully ...

You're missing a parenthesis before the minus sign and that's why you had to append one to the end.  That's most likely the reason you're only getting three characters.  There's a simpler formula to eliminate the extraneous separator character.  It's: substring(eval(eval(RepeatingGroup, ...

well this error is often thrown for access denied, check your permission on the file for your account, also check if the file is checked out by some other user.

Hello, I am new to this forum, and found this issue which is almost the same as what I am experiencing. I am using a repeating table, and am setting a dollar value to a "balance" field, when an account number I have just entered matches an account number in an Access DB.  The difference in my results (from that of the ...

I misled you, I'm afraid -- I didn't realize that calculated SharePoint columns wouldn't be available in a data connection. Apparently, even if you use an owssvr.dll connection to return XML you will have additional gunk on the string that you won't want. This may be something that can only be done with qRules or code....

I have a similar problem that I can't seem to get to work and hope someone can help me.  I have a Repeating Table and I want the row contents concatenated and separated by a comma but not have a comma at the end of the string.  My datasource is set up like this: Main myFields   EventPage (Folder)     ...

Hilary - I have a similar problem that I can't seem to get to work and thought maybe you could help me.  I have a Repeating Table and I want the row contents concatenated and separated by a comma but not have a comma at the end of the string.  My datasource is set up like this: Main myFields   EventPage ...

 Ok well I tried what you suggested by creating a calculated field (ApplicationVersion) in sharepoint which joins the Application_Name and Version into one.  It's not pretty, but I guess it would work.  Now when I look at the retrieve data connection in Infopath this new column is not available.  This list has only one view ...