cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
monica25
Nintex Newbie

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

Jump to solution

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?

Labels: (1)
0 Kudos
Reply
5 Replies
Automation Master
Automation Master

Re: 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

Jump to solution

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 

Reply
mlauer
Nintex Newbie

Re: 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

Jump to solution

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

Reply
lakshminarayana
Nintex Newbie

Re: 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

Jump to solution

Hi Monica,

Try Calcuated column by using the following formula.

Thanks,

Lakshmi

View solution in original post

Reply
monica25
Nintex Newbie

Re:    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

Jump to solution

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

0 Kudos
Reply
monica25
Nintex Newbie

Re:    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

Jump to solution

Hello Lauer, 

 

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

Regards,

Monica

0 Kudos
Reply