https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/118308.aspxWed, 07 Feb 2018 20:43:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118308etipton0https://www.infopathdev.com:443/forums/thread/118308.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118308Well 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.https://www.infopathdev.com:443/forums/thread/118307.aspxWed, 07 Feb 2018 20:29:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118307Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118307.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118307The calculated value field should not have to be there for the text field to be populated. I've never run into that before.https://www.infopathdev.com:443/forums/thread/118302.aspxWed, 07 Feb 2018 19:35:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118302etipton0https://www.infopathdev.com:443/forums/thread/118302.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118302I 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.https://www.infopathdev.com:443/forums/thread/118301.aspxWed, 07 Feb 2018 18:26:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118301etipton0https://www.infopathdev.com:443/forums/thread/118301.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118301in 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 everythinghttps://www.infopathdev.com:443/forums/thread/118300.aspxWed, 07 Feb 2018 17:29:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118300Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118300.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118300Try this one. Save locally, right click and select design to preview - First Name won't get set because of the user name differences, but you can at least see the results of the user name function and the substring-after function. I also added some row highlighting - do any rows highlight in preview? Publish, open in the browser. Do any rows highlight in the browser? Does First Name get set to your name in the browser?https://www.infopathdev.com:443/forums/thread/118299.aspxWed, 07 Feb 2018 17:16:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118299etipton0https://www.infopathdev.com:443/forums/thread/118299.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118299This is a small portion of the data on the list. It was all i could fit on the screen.https://www.infopathdev.com:443/forums/thread/118298.aspxWed, 07 Feb 2018 17:03:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118298Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118298.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118298Drag the list data fields onto your form. Don't filter it. Publish your form. Open your form in the browser. Can you send a screenshot of that data?https://www.infopathdev.com:443/forums/thread/118297.aspxWed, 07 Feb 2018 16:32:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118297etipton0https://www.infopathdev.com:443/forums/thread/118297.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118297yes 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 value. The screen includes step by step how I have been trying it.https://www.infopathdev.com:443/forums/thread/118295.aspxWed, 07 Feb 2018 15:40:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118295Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118295.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118295So the substring-after formula results in "etipton". The list has "etipton". Both are all lower case? In the browser, if you put a calculated value on your form with the substring after formula, you get "etipton"? If you put the list data fields on your form, you see "etipton"? Can you post a screenshot?https://www.infopathdev.com:443/forums/thread/118294.aspxWed, 07 Feb 2018 15:30:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118294etipton0https://www.infopathdev.com:443/forums/thread/118294.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118294I 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. username = username(). This does it correctly in my preview but not SP. I created a second rule and changed the filter data to UserName = substring-after(userName(), "i:0#.w|bhate\"). With both these rules it brings up the preview correctly but still will not populate it in sharepoint. whenever i just put in substring-after(username(), "i:0#.w|bhate\ then it will bring up etipton on SP. I need it to bring up the full name of the user using the username and comparing it to the list because the username on the list is ex: etipton. i hope all this makes sense. If it would be easier maybe I could speak to you on the phone if possible.https://www.infopathdev.com:443/forums/thread/118293.aspxWed, 07 Feb 2018 01:33:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118293Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118293.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118293I'm sorry I'm having so much trouble understanding the issue you are having. Perhaps this will help you - put the data fields from your list on the form. Add a formatting rule for what you think should select the right row (i.e. - username = substring-after, etc). Add another for the preview version. Then you can make sure the right row is highlighting in filler and the browser. Remember XPath is case sensitive.https://www.infopathdev.com:443/forums/thread/118291.aspxTue, 06 Feb 2018 23:07:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118291etipton0https://www.infopathdev.com:443/forums/thread/118291.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118291I 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 attempted to use is username equal to substring-after(username(), "i:0#.w|bhate\"). The username on my list is etipton and so forth. The i:0#.w\bhate\ is what is associated with the user in our sharepoint.https://www.infopathdev.com:443/forums/thread/118290.aspxTue, 06 Feb 2018 22:54:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118290Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118290.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118290So - I don't see the substring-after function in your filter. I still don't really understand what the issue is, outside of that - I'd expect once you've added the substring-after function, when you open the form in the browser, you would see your first name. If someone else opened the form who was in your list, they would see their first name. If someone opened the form who was NOT on the list, they would see nothing, because the formula would return no data.https://www.infopathdev.com:443/forums/thread/118288.aspxTue, 06 Feb 2018 18:59:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118288etipton0https://www.infopathdev.com:443/forums/thread/118288.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118288It is very basic file. It's more/less a learning file for me to figure out how to do it.https://www.infopathdev.com:443/forums/thread/118287.aspxTue, 06 Feb 2018 18:54:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118287Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118287.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118287Can you attach a copy of your form under the Options tab in a reply?