I am using SharePoint 2010, SP Designer, and Infopath 2010. I have created a browser-enabled infopath form. I have associated an approval workflow to this form. Evrerything works fine except one section of the form has been giving me problems for 2 days.
I am trying to display the current status, the approver and date it's been rejected/approved in 3 calculated fields. I have created a data connection to my library and was able to retrieve the approver and status but the problem is, it does not get the current form opened information. It gets the first form's workflow information that is listed at the top of the library.
How do I get a specific form status info?
how do I get the approval date?
Can this be done without writing code?
I have tried to add an extra column in my list and set the value of the field but it still only gets the first form in my list. I even tried to use a web service but i get an error when adding the connection. I even tried to use an article on MS office website about using a condition depending on if the status is approved and switches the view to read only. However, my workflow name is not in the list to be checked off while creating a data connection.
Any ideas? Thanks ....if only they had a where clause, like SQL.
I am trying to display the current status, the approver and date it's been rejected/approved in 3 calculated fields. I have created a data connection to my library and was able to retrieve the approver and status but the problem is, it does not get the current form opened information. It gets the first form's workflow information that is listed at the top of the library.
How do I get a specific form status info?
how do I get the approval date?
Can this be done without writing code?
I have tried to add an extra column in my list and set the value of the field but it still only gets the first form in my list. I even tried to use a web service but i get an error when adding the connection. I even tried to use an article on MS office website about using a condition depending on if the status is approved and switches the view to read only. However, my workflow name is not in the list to be checked off while creating a data connection.
Any ideas? Thanks ....if only they had a where clause, like SQL.