Newbie Questions

Re: Infopath Search form with multiple views

Hilary Stoupa — Tue, 10 Oct 2017 19:18:38 GMT

When you select the field you want from the field picker, there is a "Filter data" button - you can use that to add an XPath filter. Attach a sample form under the Options tab if you need a hand.

Re: Infopath Search form with multiple views

Janataan — Mon, 09 Oct 2017 17:57:36 GMT

Hi Hilary, the data did return the first record. I then dragged the whole data source into a single view (data fields). This returned the required fields from the database in a repeating table. So how do I just return one row from the repeating table based on a unique name?

Re: Infopath Search form with multiple views

Hilary Stoupa — Thu, 05 Oct 2017 15:33:13 GMT

I'd verify the query returns data. Just drag the whole data source into a single view, query & data fields, and add a button to query the data source. Then you can test & verify data is returned.

Infopath Search form with multiple views

Janataan — Fri, 29 Sep 2017 16:14:27 GMT

I'm trying to create a Search form with multiple views. First page, the text field has a rule to just query the database, on submit of the text field has a rule to look at the field if it's equal to the Unique ID. It should then switch to another view with the results, the third view springs into action if the Unique ID is incorrect. The problem is the fields aren't appearing on the results view. I'm using a Calculated field and the data is non repeating. I've set up the data connection on all the relevant fields I need. Why aren't the results appearing?