Query failing to run after submit - InfoPath Dev
in

InfoPath Dev

Query failing to run after submit

Last post 10-25-2015 07:28 AM by Laliho. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 10-19-2015 12:50 AM

    • Laliho
    • Not Ranked
    • Joined on 10-18-2015
    • Posts 4

    Query failing to run after submit

     Morning folks,

    After spending most of the weekend searching on google with no joy I’m hoping someone can help with (what I hope is) a simple issue, still very new to InfoPath and Sharepoint so go slow with me please.

    So a bit of background.... I'm currently have a form (InfoPath) that allows contact information to be entered and should then provide the submitter with a reference number, this form contains 2 views, the first allows information to be entered and contains a submit button with a few rules and the 2nd view displays a message and reference number along with a query field (hidden) and a repeating table. ((Just in case anyone asks the reference number is created using a simple counter on another list which is increased anytime a new item is added to the contact list))

    After the user enters information in view 1 and clicks submit the rules are set up to do the following... submit the data to sharepoint > set the query field on view 2 with whatever value is in the name field on view 1, > query a data connection > this should then show the reference number matching the query name > switch to view 2 so the user can see the reference number.

    When testing this in InfoPath its working as expected with no issue, I can enter data > click submit > see a reference number on view 2 (which matches the information on sharepoint), however when I try this from the sharepoint list itself the data is submitting with no issues but it doesn’t seem to be query the data connection when the button is clicked so when switching to view 2 the reference is failing to show, it's setting the query field to the correct name and I can get around this by adding a button to view 2 with just a query data rule which will then cause the reference on view 2 to display but this isn't ideal.

    I just can't work out why it works perfectly well in InfoPath but fails in the browser unless I add a second button with a rule to query the data again on view 2

    Hopefully the above makes sense, anyone have any ideas as this is driving me round the bend.....

     

    Thanks in advance.

    David 

  • 10-22-2015 02:30 PM In reply to

    Re: Query failing to run after submit

     This is odd - but I do see a lot of things work in filler / preview and fail in the browser. What if you try without switching the views? You don't have to put the query field on the form - you can just hide the reference number field if it is blank. Another thing worth trying might be to set postback to "always" on the button with all the rules - that is under the button properties on the browser tab.

    Hilary Stoupa

  • 10-23-2015 12:55 AM In reply to

    • Laliho
    • Not Ranked
    • Joined on 10-18-2015
    • Posts 4

    Re: Query failing to run after submit

     Hi Hilary,

     I get the same issue if I just have the one view, reference fails to load but I can add a second button with a query setting which then causes the reference to display.

    Will have a look at the postback stuff and report back.

     

    Regards

    David 

  • 10-23-2015 02:25 AM In reply to

    • Laliho
    • Not Ranked
    • Joined on 10-18-2015
    • Posts 4

    Re: Query failing to run after submit

     Changed the postback setting to always but still getting the same issue when using a browser, preview mode still working perfectly

    Any other ideas? (still googling away in the background)

     

    Regards

    David 

  • 10-23-2015 10:44 AM In reply to

    Re: Query failing to run after submit

    Yeah, I've not seen this specifically - I have forms where we submit, query, submit again. What version of InfoPath / SharePoint? On-prem SharePoint, or Office 365?
    Hilary Stoupa

  • 10-25-2015 07:28 AM In reply to

    • Laliho
    • Not Ranked
    • Joined on 10-18-2015
    • Posts 4

    Re: Query failing to run after submit

     InfoPath vs 14.0.7153.500, Its a company hosted sharepoint so all I know is its sharepoint 2010

Page 1 of 1 (6 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.