I have a table that we are going to use to create a users password and store some information in.

I would simply like to take the first for digits of the user's last name and add that onto a word to create their password.
I have been searching and can't seem to find a way of doing this?  The data column that has the user's name has both their 
First and Last name in it.

So simply put.
John Smith   would have a password of smitWelcome1!

How can this be done??
And thanks a lot for your help!

Edited December 27, 20187 yr by 1FilemakerMan
Spelling

I have figured out how to narrow it down to only the last name, 

RightWords ( Software_Inventory::FullName ; 1 )

 

Now I just need the first four letters of the right name......

I FIGURED IT OUT!  I feel like I just won the lottery!

 

 

Left ( RightWords ( Software_Inventory::FullName; 1) ; 4 ) & "Welcome1!"