I would like to extract last 4 digits of a number column, First name first initial, last name first two initials, birthday MMDD and generate an ID from that (example 1234LLW0101). I would like to achieve this using Nintex form. Could someone help me with this?
Solved! Go to Solution.
Then to store the substrings in a single variable, and in the end insert that variable into a field you will then use for storing the ID.
In Nintex Forms You can use Calculated Value Control, e.g.
Try Calcuated column by using the following formula.
This was extremely helpful. I tried following the same approach you did but didn't calculate the sub-string start and length parameters correctly. I was able to achieve the desired result after correcting them based on your post.
Thank you for quick turn-around. This really helped in extracting the sub-string from First and Last Name.