InfoPath Dev

i've implemented same as https://blogs.msdn.microsoft.com/infopath/2010/06/03/how-to-pass-querystring-data-into-an-infopath-form/ But when i passing Existing (SP Library )parameter in URL it will again appear fresh infopath form. Trying to implement do not proceed if paramenter already exist in SP library. If so, then simply message will display as this item has already exist.please enter new ID. Thanks

Have you verified that the query string parameter is being successfully passed? The most likely issue is with your rules, or with your implementation of the blog post. It is impossible to guess without more information, or seeing your form, which you can attach under Options in a reply.

Yes i have verified the query string parameters and it is successfully passing Today i passed parameters id= 1 Tomorrow again i pass same Id=1 then it should come error as this item as already exist.

Ok, so if you've verified the query string param is being passed into the form correctly, then the issue is likely in your form load rules. Again, without seeing the form, I can't begin to guess how to help you.

Ok ok i will attach here my infopath form in 30 mins is it ok?

Sure. I'll try to take a look at the rules sometime today.

i have attached my form here. please have look and let me know where i need to do changes. Thanks

I'm sorry - didn't have a chance today - I'll try to take a look tomorrow. :)

Ok

Hi Hilary, please,Any chance to check today?

You are passing in the ID, and you have verified that ID is being set? You have put the ID field in your form (is that where you are passing the ID?) on the form, and verified it has a value? Based on your initial post, I think that what you are saying is if the ID is populated via parameter, you don't want the user to fill out the form? I would actually kind of expect your ID field to have a rule to set the query ID field in your library data connection, then query, then do something if any rows are returned.... can you describe what your desired outcome is?

Hi Hilary, Open view 2 Actually i have passing parameters in URL is Story No. Not ID. And i have set story no. In Query string parameters. When i manually pass in url like "?StoryNo=1" then only it will reflect in view 2 Story No. Field.

Ok, so you are passing in your query field to StoryNo, but there aren't any rules on StoryNo? So, again, what are you trying to achieve? Because I don't see any rules doing anything here. Is StoryNo unique? If so, you could promote it to the library, then when the param is passed in, you could query the library for any rows that match, and add logic to do something to block the user.

Yes, there is no rules in story field. And story No. Is unique. And this story field textbox is read only. Every item has unique story no. If item stored in library Story No= 1 and again i want to pass in url "? Story No=1" that itime something will come and don't allow to fill form it have to block or something.

Ok, so it sounds like you haven't tried to implement any logic at all around this yet. Is that correct? I see a data connection called "SiteMinder Protected Applications Receiving Data Connection" in your form - it appears to be to the same library the form is submitted to. If you aren't using it for anything else right now in your form, you could re-use that - but it needs to have the StoryNo field included. If you are using it already, add another data connection to the library. The connection must include the StoryNo. The connection should not run when the form loads. On the StoryNo field, add a rule that if StoryNo is not blank, set the StoryNo Query field in the data connection in the library to the StoryNo field in the form. Run the query. You can't switch views in a form on field change, but you could put the controls in one section and a message in another section and use conditional formatting to show / hide the sections based on whether the data connection returns any rows.