InfoPath Dev

Well thanks for the help. I have tested that formula using the calculated value with other forms and it works with them too. Thanks again for all your help.

I have figured out that the calculated value field has to be there for the text field to be populated. Out of curiosity why is that? I mean it works that's all that matters but still curious.

in the preview the eric tipton etipton columns were highlighted. when i published it and it worked so how can i do that without all the names and everything

This is a small portion of the data on the list. It was all i could fit on the screen.

yes to the first question, yes to them both being lower case. yes to the calculated value question, if i put the list data field on my form and then filter it i do not see anything. The etipton that shows on the screen shot is from me not from filtering. It is just from putting in substring-after(userName(), "i:0#.w|bhate\") as the ...

I did the data field and here is step by step what i have been doing. I create a rule condition firstname is blank. Run action. Set Field Value is Firstname. Value= i open my data connection which is employee data in the value field. I select Full Name because that's the column name. I filter the data. username which is a column name. ...

I added the substring-after several times to the formula. When i published it, it still showed nothing when I tried to do a new document in sharepoint. I thought it might be because of the list. So I created another SP list and tried it that way. Once published it would not show up the name even with the substring-after. The filter I have ...

It is very basic file. It's more/less a learning file for me to figure out how to do it.

This will just work for myself though. I need to autopopulate the field with the current user. I know when I put in the substring-after(username(), "i:0#.w|bhate\") it will bring up the current username ex: etipton in SP. I have an employee list that I need the username to reference. i have created a rule that the value is the fullname ...

I have tried that. when i do username=username() in preview it works. In sharepoint all the usernames have i:0#.w|bhate\ before the username so I tried adding that to the substring-after then the username(), "i:0##.w|bhate\ and it still didn't work in sharepoint. when Ii add the substring-after to it, it does not show in preview