InfoPath Dev

Hi everybody, i've run into a roadblock and need some help. Here's the situation, I created a form in Infopath and have everything working pretty good there. When a form is submitted it is sorted by "Clinician" (the person's name) in sharepoint. My problem is that their are several clinicians and I want to filter the data so they only see the forms that pertain to them. I can't filter with "created by" becuase the clinician will not always be the person entering and submiting the form.

I've tried filtering the view by using "Clinician" is equal to [Me] but get "filter is not a valid text string". I've also tried filtering by "Name", but i get a "render failed" message. 

Here's a Screen shot, all I want to do is when Lee Westwood is logged in, I want him to see only Lee Westwood forms.

You will need to add a column to your sharepoint list, type : people. That is the only way to add the filter on [Me] because [Me] is of people type. If you set this value with the good format of name (like Smith, Robert for instance) it should recognize the person.

Hope that helps

 I created the column, but im confused on how you would get the person's name typed/submitted in the infopath form into the "people" column.

In your form, add a hidden field that you will publish. Set the default value of this field to concat(Last name, ", ", First Name). I don't know if it will work though... if it doesn't, maybe you could try to add a field to your form that the user can fill with the username of the clinician (something like domain\rsmith) or with his email.

 Thanks for you help, I tried your 2 solutions but no success. The frustrating part is I created a new field called username, but in Sharepoint it will not let me filter by this:

 ^That was suppose to be a table, but its "Username" is equal to [Me]

Pretty much the only time i can filter is when its created by, but i cannot use that!!! All i want to do is filter by sharepoint username!

Try this

http://www.infopathdev.com/blogs/greg/archive/2005/09/08/Use-the-SharePoint-_27005B00_Me_5D002700_-Filter-with-a-Promoted-Property.aspx

maybe it will work for you

Try this as well

http://www.sharepointdev.net/sharepoint--infopath-forms-services/use-the-sharepoint-me-filter-with-a-promoted-property-36654.shtml