InfoPath Dev

Hi, Is there a way to update user roles for submitted forms? For example, the current workflow allows the Chairman role to edit all sections of the form. This works fine until the day the chairman changes to a different person. My user roles are based on form values and thus this change in chairman will only allow the new chairman to edit all ...

Thanks Jimmy for your suggestion! I was all resigned to do coding already... Using expressions to act as parenthesis works!

And what happens if my IF condition is: A is blank and One is not blank or Two is not blank? Will it be read as (A is blank) and (One is not blank or Two is not blank) OR (A is blank and One is not blank) or (Two is not blank)

Hi, I am stumped by how rule conditions work when there are multiple fields to consider. For example if there are 3 fields, "A", "One", and "Two" and want to set a "Results" field to be = 1 if "A" is blank and ("One" or "Two" is not blank). Do I set the condition as IF: A is ...

Hi Hilary, Will try out qRules for this function asap, thanks!

Hi Josera, Thanks, will try that out for my next form. Thanks!

Hi Josera, Thanks for your reply! We have since took another approach for our forms but I will keep your advise in mind the next time I design another form. Being able to run stored procedures from the form is a very useful feature indeed. Just curious, is it a must to restore previous DB access command and set cn = nothing? Otherwise what will ...

Hi Jim, Coincidentally, I already have my runtime settings to maxRequestLength="30720" executionTimeout="600" when I hit this issue. Shouldn't be a timeout as the error reply is within 3seconds upon my form submission. We are not using sharepoint. Just a webserver hosting DBXL connecting to a MS SQL 2008 database. Does ...

Hi Hilary, You got it all correct except 3. I'm actually trying to pull data back to another view on the same form. The data will be from previous revisions of the form and the view is used as a audit trail view. Your idea sounds good... Very good! Does it work if I place my attachments in a repeating section and try to pull back base64 ...

Hi Patrick, Thanks! It works! But somehow I am unable to upload a single document that is larger than 20MB despite setting my limit at 30MB. The error message on submit is: InfoPath cannot submit the form. An error occurred while the form was being submitted. InfoPath either cannot connect to the data source or the service has timed out. But ...