InfoPath Dev

I was able to do this using jScript - I'll get the code on Monday night. It works by using the change event of root level groups. Group change events get fired any time there is a change in one of their containing fields in the XDocument. I use a global variable which tells the event whether to allow the change to occur or ...

 Thanks for your info..

As Skarn says, it's not possible to add rows to a repeating section with InfoPath's built-in functionality. On the other hand, qRules makes this task a breeze.  Your form will still behave as though it has code in it, but you won't need to write any of the code yourself.

I don't think this is possible - best you would get is adding a button to the repeating table/section of the secondary datasource which copies that record's values somewhere else - so the user would have to manually copy each record using the button. All other solutions use code or maybe a third party extension software/plugin. But you ...

Go to Data Connections - main connection, and 'edit SQL' - see if you can't figure out how to put a WHERE clause on it that looks at the values of both a1 and b1 and see if this allows you to accomplish - if not - I have my own approach using jScript. Can you use jScript?

Sure, you should be able to do this with conditional formatting and an extra field. The field could be a normal text field - with a default value of 1. Create a button on your form which sets the value of the new field = -1 * the field. Right click on the section you want to be able to hide - go to the conditional formatting and set when ...

Hmmmmmmmm maybe - you could try placing the repeating table on the form. Have a field (indexNum) created outside of the repeating group which stores an 'index number'. Default 1. Decide how many rows of the table you want to display (my example below uses 5) Now put conditional formatting on the repeating table to hide when position() ...

I've built a 'custom questionairre' form template which may do what you want. I'll get it from work next week and post it.

I tried an approach where in jScript I made a manual connection to the SQL server and sent the attachment field text (it's BASE64 encoded already) to the database to a memo field. You can't bind an Infopath field to a memo field directly - and memo fields are what's needed if you have an attachment of any appreciable size. It worked - ...

try catch would be it - makes sense - if there's no apples, and someone told me to eat the apple, i might have an error too ;-)