InfoPath Dev

I think what makes it hard for me is that the conditions are for hiding, not showing... add in a "not" and my brain sort of blows up. That's why I end up writing it out story problem style. Glad this fixed it! For more than five lines you have a couple options - you could add a second condition with the additional names (and a third ...

Hello! I have an infopath form which is producing an error message on two fields which need to agree. One field is called InvoiceAmount, which the user needs to manually enter, and it is set as formatted currency, USD with 2 decimal places. Users can enter the whole number with or without decimals if there are no cents in the amount (ie 20 or ...

how do you work if no rejecting form?

Hi Hilary! Thank you for getting back to me so quickly. I am new to InfoPath and this logic and conditions stuff is not a strong point for me. I made your suggested change and it worked! You are AMAZING! However I still have a minor issue. The condition is limited to 5 lines, and I have 8 users that are authorized users. I thought maybe I ...

Glad that worked for you. The current() function is very useful - it always refers to the current context node, so if you had a rule on a button, for example, current() is the node the section the button is in is bound to. :)

Your approach for does not contain was close... but I think you wanted "and" instead of "or". So, "if current user does not contain John AND current user does not contain Ann AND current user does not contain Bill, hide this control" - kind of goofy but I often have to write out logic in plain English in order to ...

Hello, I am trying to create a section on my form that is only visible to authorized users. I have already created a "Current User" field which detects the name of the person completing the form (in SharePoint online), and I want to create a rule such that if the user is not one of a specified group of users, the section would be ...

In order to submit to SQL without code, you need to create the form from the Database template. To submit with code, not using a data connection, I'd think you'd need the form to be full trust - but if you have a receive data connection, you could probably leverage that & change the command to use a stored proc (for example) - passing ...

 Hilary, you're a genius!! Amazingly simple how you used the .=current()/ function Thanks a lot 

Hi, I am new to infopath, programmer for some other application. retrieving data from sql is working. Anybody give me an idea or link where i can learn to submit data to sql in infopath2013? I've trying this for 1 week in online, no help. Thanks,