InfoPath Dev

You bet - glad you have it all set up.

Lets say I have a few users in a group called "Restricted" and I don't want them to be able to view or submit forms. Should I add some code in the Form_Loading event that checks what groups the current user is a member of? If so, how would I prevent the form from loading? So far the code I have doesn't seem to ...

Thanks Hilary, it worked, i promoted all the repeating table column fields and i can see the data in the share point list. Thanks again.

The data could be from sharepoint list or database. Right now we are pulling everything from them as we need to filter them based on User Input at run time. Based on my search around this site, it seemed we need to have custom code if we cannot get around this 1500k limit, right? Thx

When you publish your form to a SharePoint library, you can choose the fields you wish to "promote" or display in the form library. You can also add those under the Form Options (Tools > Form Options in IP 2007, File > Info > Form Options in IP 2010). Does that make sense?

Hi Hilary, thanks for the reply. I'm sorry, I didn't get the promotion point, i didn't use this property earlier. Can you please elaborate? And yes, this form is still in development and they will have a meaningful name when i get it working and push to testing environment. Thanks for the advice.

You should check out the QueryDB web service in DBXL.  Without any code, you can use a data connection to the web service to query SQL databases and return data back to your InfoPath form as a secondary schema. Here is a link for more info and to download a trial: http://www.qdabra.com/en/products/DBXL.aspx

Hi - to promote your repeating fields, you don't have to use a double eval formula. Simply promote the repeating field, and select "merge" - see screenshot. As a side note - if your form is not yet in production, you may want to consider giving your fields and groups meaningful names instead of "group13" and ...

I want to store repeating table values is sharepoint form library. I have a repeating table with 3 drop down list and a text field. I concatenated all the values from 3 drop down list in to the text field using the formula: concat(field56, ";", field57, ";", field58). I created a separate text field in the form and ...

Hi Jim, Just in case anyone else in the Forum is having a  issue when using Excel Services REST connections with Office 365 Daizy Shen with the  Partner Online Technical Community Has reporduced asimular issue with Office 365 and InfoPath Excel Services REST connections. See message below. I will update when provided ...