Checkbox value in IP not matching value in Sharepoint - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Checkbox value in IP not matching value in Sharepoint

Last post 10-24-2012 07:20 AM by poppyq. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 07-16-2012 10:14 AM

    Checkbox value in IP not matching value in Sharepoint

    Hi all,
    I have a two checkboxes that are set by buttons for submission.  The values in IP are set to be "0" when unchecked and "1" when checked.  These values are being used to indicate which view a user sees when they open the form.  If "x" role and "0" a certain view shows; if "x" role and "1" a different view shows.  Well, after publishing to sharepoint, the value showing in SP is Yes/No not 0 or 1.  Which is causing my load rules to not work. 
    When I was first testing the load functionality, the published field used 1 and 0 as expected... so I stayed with that.  Now that I'm in my real form and not just testing the concept, it gives me this issue. 
    Does anyone know how I can get the 0 or 1 to be the value in SP as well?  IP doesn't like it if I change the field on the SP side...

    Thanks!

    Jen

  • 07-16-2012 04:15 PM In reply to

    Re: Checkbox value in IP not matching value in Sharepoint

    Hi - SharePoint promoted boolean properties display Yes / No rather than true / false (1 / 0) I believe. But I'm perplexed as to how this would be changing your form data or causing your form rules not to fire. Is this promoted property one that can be edited from the library?

    Hilary Stoupa

  • 10-24-2012 07:20 AM In reply to

    Re: Checkbox value in IP not matching value in Sharepoint

    I'm having a similar problem, but my workflow is what is causing the problem. I have an InfoPath form with a boolean true/false field. It defaults to false and is only ever modified by my workflow. Form is submitted, workflow runs and depending on the flow it may set the value in the column in SP to either Yes or No. If I set it to Yes and open the form, a rule runs and triggers based on it being true. The odd thing, and my problem, is that when the workflow later sets it to No, and I see it in my SP form library as No and open the form, the rule still triggers thinking it's true. I then can go in, edit the value from SP itself (check and uncheck the box), and then the form recognizes now that it's false. Somehow the workflow setting it to No is not being seen in InfoPath as false. Boggles my mind.

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