On my sharepoint list, there are two columns: student ID and student name.
Student ID Student Name
01 Kyle
02 Bruce
03 Tom
I want to make a third column on the sharepoint list by concatenating the ID and name. The list will be after concatenation
Student ID Student Name Student
01 Kyle 01 - Kyle
02 Bruce 02 - Bruce
03 Tom 03 - Tom
I don't want to change the infopath template to ask students to fill "student" cell. The "student" column should be automatically generated after a student submit the form. How to achive this? Thanks.