Generalhttps://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)How to Contatenate two columns on sharepoint site without changing infopath template?https://www.infopathdev.com:443/forums/thread/98593.aspxWed, 06 Aug 2014 13:17:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:98593Bruce0https://www.infopathdev.com:443/forums/thread/98593.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=98593<p>On my sharepoint list, there are two columns: student ID and student name. </p> <p>&nbsp;Student ID&nbsp;&nbsp;&nbsp;&nbsp; Student Name</p> <p>&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Kyle</p> <p>&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Bruce</p> <p>&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Tom</p> <p>I want to make a third column on the sharepoint list by concatenating the ID and name. The list will be after concatenation </p> <p>Student ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Student Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Student</p> <p>&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Kyle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01 - Kyle</p> <p>&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Bruce&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02 - Bruce</p> <p>&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tom&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;03 - Tom</p> <p>I don&#39;t want to change the infopath template to ask students to fill &quot;student&quot; cell. The &quot;student&quot; column should be automatically generated after a student submit the form. How to achive this? Thanks. </p>