I would like to extract last 4 digits of a 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 values are in separate fields? What is the date format? If the values are separated, then the easiest way would be to use native javascript function: substring (https://www.w3schools.com/jsref/jsref_substring.asp).

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.

Regards,

Tomasz 

In Nintex Forms You can use Calculated Value Control, e.g.

Hi Monica,

Try Calcuated column by using the following formula.

Thanks,

Lakshmi

Hello Lakshmi, 

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!

Regards,

Monica

Hello Lauer, 

Thank you for quick turn-around. This really helped in extracting the sub-string from First and Last Name. 

Regards,

Monica