InfoPath Dev

The intent is that fundingID will come from SQL Server generating an auto numbered identity & primary key value. I was not aware that DBXL had to be provided with a key value. The plan was to import the legacy data into the SQL database, including the legacy IDs, then set the column as an identity column/primary key/auto number. Some ...

I currently have a form with a repeating table.  I am trying to create a report based on down time code which is one of the fields.  The problem that I am having is that I cannot group by down time code in the SharePoint library because the repeating table has a merged value.  I have attached a screenshot of what I have in ...

Hi, First of all I would like to thank this forum for providing me some guidance to develop solutions using InfoPath. This issue is in regard to http://www.infopathdev.com/forums/p/23959/83208.aspx#83208 I have a repeating table with some drop downs(Color, Seed Type) depending upon which the price textbox gets auto populated. I have YES/NO as ...

Thanks for checking. The problem is that the key is blank, and SQL won't accept a blank value for the key. Where is fundingID coming from? Is it a value calculated in the form, or does the user type it in? It sounds like the mapping is set up correctly, but there is bad data in the forms, namely, the blank key. Just make sure that the key is ...

The document does show up in the document count. Reshreding throws errors on four of the six documents (attached). The other two documents do populate data into the SQL Database. So the complication is how to set up keys. Ignoring, for the moment, the fact that I am dealing with legacy data from another system that this form is ...

 After submitting, does the form show in the Documents tab? If you click Reshred, does an error come up?

I have an InfoPath 2010 form with qRules that submits via  SubmitToDBXL to DBXL 2.6. Ernesto had guided me in setting DBXL up to map the form to a SharePoint library. That functionality works great.   I’ve since added a database mapping to the form in DBXL. When I submit the form the data is not appearing in the mapped ...

You are my hero! Thank you for such a swift reply. I owe you more for this answer and many others.    

I think you are looking for Form Load rules - under the Data tab in the Ribbon, click on Form Load in the Rules section. :)  When I switched to IP 2010 it took me a week to find conditional formatting.

Am working on my first complex form in IP2010 with multiple views. In IP2007, it was an easy Forms Option setting to say, if field1=x, change and display this view.  If field1=Y, change and display this other view. In 2010 all I see i talk of user roles and VB programming. I have the initial user completing a XSN form and submitting it via ...