locked
Filter Form Library View using promoted columns from InfoPath RRS feed

  • Question

  • Hi
    I have a form that requires two levels of approval. This is published to a form library on SharePoint 2007. I only want users to see their own forms as there are monetary values involved. I can achieve this using the view filter “Created by” & “Modified by” = [Me], however the line approvers can only see the forms after they have interacted with them. Once the next person in the workflow edits, they cannot see the form.

    I have tried using columns I promoted where I have stored the username of the approvers and using the [Me] filter, I get a “Filter value is not a valid text string”. I created two more calculated columns in SharePoint making them equal to my InfoPath fields, and I still get the same error.

    Can anyone tell me how I can set a filter so that these line managers can at all times see any forms that have required their approval?

    Many thanks in advance.

    Cheers

    Bill

    Thursday, February 4, 2010 9:49 AM