Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 2144 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted (edited)

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 by 1FilemakerMan
Spelling
Posted

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......

Posted

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

 

 

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

This topic is 2144 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.