http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/8296.aspxThu, 22 Sep 2011 13:19:30 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:8296mlepitt0http://forums.method.me/cs/forums/thread/8296.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=8296<p>I found the answer. &nbsp;I will run a character function and take the left 5 of the last name and save it as an action. &nbsp;Then I will add another character function of the first of the first name and save it as an action. &nbsp;Then another character function to join those two actions, and one last character function to join the joined actions plus the account no. on the screen.</p>http://forums.method.me/cs/forums/thread/8295.aspxThu, 22 Sep 2011 13:03:13 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:8295mlepitt0http://forums.method.me/cs/forums/thread/8295.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=8295<p>I am trying to figure out how to make a formula field or calculate a value to place in field on screen. &nbsp;For examples, I would like the portal user name to automatically create itself. &nbsp;What I want to do is the first 5 letters of the last name, first letter of the first name and then followed by their account number. &nbsp;For example: smithj10.</p> <p>My thought is to collect the three field values, take the left 5 and 1 values of the first two and then concatenate the results of left(LastName,5) + left(FirstName,1) + AccountNumber. &nbsp;Can you give me insight if this will be possible and the recommend onscreenLoad functions I should use to achieve this?</p>