I am using an InfoPath template in a Library. My form has 4 views, that all switch according to the document status (draft, pending, approved, rejected). On the library the built in document approval workflow is enabled. When the document gets pending status,
the approval workflow creates tasks related to the documents in a separate tasks library. In the approved and rejected view on the form I want to show details about the tasks, and the outcome of the worfklow, inside the form.
To acheive that I created a recieve connection from the tasks library, and added it on the form as a repeating table. This will give me all tasks, and create as many rows as there are tasks. Which can be more than 100 ++. To show only the unique row, I use
the document filename as an unique identifier, concatenated with "Please approve" becaue all tasks will have the title "Please approve 'filename'". Then on my repeating table on the form, I have conditional formatting that will hide the control when Title
is not equal to my builded string filename. This will give me my unique row.
But, the problem is that it downloads all tasks in the form, and if i click on the rows, they will start disappearing, except the one which is my unique row. To avoid downloading all tasks, I wrote code for FormEvents_Loading.
This is my
View Complete Post