InfoPath Dev

Almost there!!!!! Clay, your last idea worked!!!! Any account that contains 3 alpha characters or 4 alpha characters only finally worked. There is one instance where the rule(s) don't work....We have some accountID's that are in the form ....JA1, E7T, H53, 131 ... Basically on the three character accountID's that contain a numeric, ...

Thank you

Hey Mr. Monkey. First of all I would say that best practice for these scenarios is to write a webservice which requires input parameters and let them call the usp (stored procedure). However I agree that it can may be become bit bothersome to allways write/use a webservice if you jsut want to call an usp on a database to which you are connected ...

Hi Any luck getting the latest code? Regards Rico  

Hi Monkey nad welcome! This is no waste at all. In fact, I think this is a great technique. I learned something new thanks to you! :)

Good idea DJay! Using the secondary DOM will make it much faster.

Note: the above tutorial does not require code and accomplishes the same thing. We are coming out with a tool in the next few weeks that will let you map InfoPath forms to SharePoint lists using a simple configuration. Stay tuned to this channel...

Clay, Thanks for the quick response.  When i create a rule and then set a field's value, I can't use an absolute value function.  There are only minimal math functions (avg, boolean, ceiling, etc.).  ABS is not one of them.  I tried to square the number and then take the square root, but it ...

Hey Bruce. I think you are making this more complicated then you need to. One of the great things about InfoPath forms is that you can do most things without code. Open up the control (double click) which the user makes the selection from and then create a rule. You should set a fields value as the action, select your target field, and ...

I'm so new at  this I'm not sure where to begin.  I've made a InfoPath 2003 form and connected it to a SharePoint 2003 forms list.  That all works great.  Now I'm trying to get a little fancier on data integrity.  My application is tracking activities related to energy consumption.  I've added a ...