Okay,
I am trying to build a form in IP 2010 that, upon loading, shows one field (policy number) from the first record of a sharepoint list, organized by another field called status. This will then be used to populate information in the form, as it is a unique identifier. I have been able to do this with form load rules and the position()=1 expression on my data connection the the SharePoint list. But then, I want the form to (either on load automatically, or when the user clicks a button) to change the status associated with the Policy number that was shown and Submit back to the SharePoint List. This will ensure that when another form is created, the next item in the list will appear, since that status changed it sorted down to the bottom of the list.
http://blog-sharepoint.blogspot.com/2009/07/summary-how-to-programmatically-update.html#process-6 - This post got me through setting up the CAML and web submit, but I was testing it, and editing the status in the repeating field then submiting does not give me an error, but does not update the list and when I query again to check it resets to the default.
http://www.infopathdev.com/blogs/hilary/archive/2009/06/07/hack-manifest-xsf-to-filter-the-target-of-a-rule.aspx - In theory this does what I want to, instead of only updating ItemType of Labor, it would only update the item that corresponds to the policy number that was populated when the form opened. Unfortunuatly, following the steps in this document does not seem to work for me, while manifest.xsf is saving the changes I made, it is not updating the Xpath in the action.
Unfortunately, I cannot use C# coding as of right now due to corporate restrictions (though I am exploring that option), and for the same reason qrules is not an option - this may not even be possible with these restrictions.
I have attached what I am working off of, any help would be appreciated!
Thanks,
Kathryn