Browser Forms

Re: infopath Query string parameter

Hilary Stoupa — Mon, 25 Nov 2019 18:27:29 GMT

Woot! Glad you got it figured out. Since I don't have access to your data, it is hard to troubleshoot these things on my side - I just have to make my best guesses for the rules. :)

Re: infopath Query string parameter

Netaji J — Mon, 25 Nov 2019 18:12:08 GMT

Hi Hilary, Yes, i did little troubleshoot and got resolved. Just because of you thank you so much for your help. Really Appreciated!!! Once again Many Thanks!!!!:)

Re: infopath Query string parameter

Hilary Stoupa — Mon, 25 Nov 2019 17:40:10 GMT

You'll just need to troubleshoot that. I'd suggest putting the query and data fields on your form for the Story No. connection and a button that runs the query so you can unit test.

Re: infopath Query string parameter

Netaji J — Mon, 25 Nov 2019 17:33:54 GMT

Hi Hilary, i checked all the changes but when i hitting one storyNo which was already present in library still it accepting and appearing Story No in field instead of getting item already exist.

Re: infopath Query string parameter

Hilary Stoupa — Mon, 25 Nov 2019 16:18:28 GMT

In this copy of your form, I've done the following:

Changed your StoryNo. query to not run on form load
Added a rule to the StoryNo field to set the query field in the data connection and run the query
Added sections to your default view to show/hide based on whether rows are returned

The net effect should be that if the story no field is set by the query string parameter, which you have assured me it is, the form will query the library to see if any forms exist for that story number, which you have told me is unique. Hopefully this will be enough to clarify for you.

Re: infopath Query string parameter

Netaji J — Mon, 25 Nov 2019 15:54:44 GMT

i have rollback all the changes which was made on StoryNo field. Now only i have created StoryNo(QueryStringParameter) Data connection is there.

Re: infopath Query string parameter

Hilary Stoupa — Mon, 25 Nov 2019 15:44:24 GMT

Can you attach the latest copy of your form?

Re: infopath Query string parameter

Netaji J — Mon, 25 Nov 2019 15:29:26 GMT

Hi Hilary, any updates on this please? Thanks

Re: infopath Query string parameter

Netaji J — Sat, 23 Nov 2019 14:55:21 GMT

Hi Hilary, 1. I have added receive data connection( Name-Test) in library include only StoryNo. 2. In View 2, select story No field a nd click on manage rule, i wrote rule in "Action" as StoryNo is equal to Story No (Select "Story No" from Query Field under Test Data connection). Rule Looks like StoryNo = Story No 3. Now, Run these action i clicked in Add and Select option Query for data and added "Test Data connection" Now i stuck here not understand what to do? please help!

Re: infopath Query string parameter

Netaji J — Sat, 23 Nov 2019 14:32:19 GMT

Hi Hilary, Now i am adding data connection includ StoryNo field. but could you please help me which data connection i've to create submit data or receive data? Thanks

Re: infopath Query string parameter

Netaji J — Fri, 22 Nov 2019 19:29:09 GMT

Ok i will try to implement this and update you. Ok

Re: infopath Query string parameter

Hilary Stoupa — Fri, 22 Nov 2019 19:21:30 GMT

In your form, you already have promoted StoryNo to the library where you publish and submit the form. As per my earlier descriptions: 1. Add a data connection to the library that includes the StoryNo column, don't run the data connection on load. 2. Add rules to the StoryNo field to set the StoryNo query field in the data connection added in item 1, and then execute the query. 3. Use sections and conditional formatting in the default view to either show controls to fill out when no rows are returned from the query in item 2 or show the user a message.

Re: infopath Query string parameter

Netaji J — Fri, 22 Nov 2019 19:18:47 GMT

Hi Hilary Shall i create new list which i will store all the story no. then i need to create a data connection . after that in view 2 story field i need to write form load rule which is connected to this data connection if story No present then display (Formatting) message. Something like this i need to implement?

Re: infopath Query string parameter

Netaji J — Fri, 22 Nov 2019 16:45:40 GMT

No i didn't tried any implement and my coding is not good Mentioned data connection is used for retrieving data based on Application ID. And it will appear in Third view under summary field. And also same library using for data submit. Now this data connection I'm using and its included story no also.

Re: infopath Query string parameter

Netaji J — Fri, 22 Nov 2019 16:31:23 GMT

Yes I'm receiving and submitting data in only one library and there is story field (calculated ) i added. In library view it will reflect Story and new story both value save in Story No. Column.