Jump to content
Sign in to follow this  

Script to create a password from a user's last name....

Recommended Posts

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

Share this post

Link to post
Share on other sites

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

Share this post

Link to post
Share on other sites

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



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

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By VapanPagan
      A little background
      I have a DB which keeps users logins/passwords for a business so they have all their login information for everything at work.
      My Issue
      I need the user to be able to click a button that creates a random password and places it into the password field when the button is clicked. I am making a button like this for each sections password field. I know I need to make a calculation, I have made these types of scripts before. However, how do I get to a calculation to perform this action with a button in filemaker? I am sure this is so obvious I will slap myself but right now I am at a loss. Maybe I have been working on these 5 solutions too long and need a break. LOL
      Any help, suggestions are very welcome...Thank you! =)
    • By Asu
      Hello - I opened a very simple file I have been using for years (originated as v12 now 15) and it presented me with a password window. It is a simple index card file containing study material  and it has never ever been password protected. 
      I tried with my computer account info and it did not work.  Admin-admin or blank-blank ditto. Again, it has never been password protected as it had no reason to be. Fortunately I could restore it from a backup drive, of course it was not password protected and it opened without a hitch. 
      How could this have happened? Has anyone ever heard about such thing? 
    • By troi
      Troi Automatisering releases Encryptor Plug-in 3.5 for FileMaker Pro 15

      Updated plug-in for FileMaker Pro 15 lets you store your encryption passwords in the keychain.

      July 5th, 2016, Alphen aan den Rijn, The Netherlands--Troi Automatisering today announced the availability of Troi Encryptor Plug-in 3.5 for FileMaker Pro 15.

      What is Troi Encryptor Plug-in?

      Troi Encryptor Plug-in is a very powerful tool for securing your FileMaker data, exporting or emailing your data without risk and importing safely back into FileMaker. All from within FileMaker you can:
      - encrypt text or container fields, using the powerful 256-bit AES encryption scheme, so that your sensitive data is secure
      - export encrypted data that can be sent safely across internet, for example via email. No risk that someone will read or change the data while in transit
      - use the decryption functions to restore the original information after you have imported the received email or export file back into FileMaker, with the assurance that nobody will have tampered with it
      - exchange AES-encrypted data with other systems (like for example PHP-mcrypt)
      - verify data integrity and sources with SHA-1 message digests
      - encode text in Base64
      - make conversions to and from binary
      - compress databases with large text fields

      What is new in version 3.5?

      Troi Encryptor Plug-in 3.5 has been made compatible with FileMaker 15:
      - Improved the multi-threading behavior of the plug-in when running in FileMaker Pro 15.
      - Added description and type-ahead information for all functions of the plug-in. This extra function description will be shown in FileMaker Pro 15 in the Specify Calculation dialog box when you type a function name and also as a text popup in the functions pane on the right. The type-ahead information is used by the auto complete functionality of FileMaker Pro 15.

      Troi Encryptor Plug-in 3.5 has the following new functionality:
      - Added three new functions to safely store, retrieve and delete passwords in the keychain. An account name and ID parameter are used to distinguish between passwords, so you can give acces to a user on a per database level, but also on a per field or even per record basis.

      Version 3.5 has several further improvements and an updated User Guide. More detailed information on all changes and improvements implemented in Troi Encryptor Plug-in 3.5 and earlier can be found at: http://www.troi.com/software/encryptorhistory.html

      Pricing & Availability

      A fully functional demo version of Troi Encryptor Plug-in 3.5 is available for downloading at Troi's Web site at: http://www.troi.com/software/encryptorplugin.html

      Troi Encryptor Plug-in 3.5 works with FileMaker Pro 12 to 15. The plug-in can also be used with runtimes created by FileMaker Advanced 12 to 15. The plug-in is available for OS X 10.6.8 or higher and Windows 7 to 10.

      Licenses cost US$ 79 per user. Details on developer licenses and multi-user discounts can be found on our web site. You can order licenses from our web site.

      FileMaker Server requirements

      Troi Encryptor Plug-in 3.5 also works with FileMaker Server 12 to 15 as a server-side plug-in and as a plug-in used by the web publishing engine and WebDirect. To use this, you need to purchase a special cross-platform server/web license which costs US$ 399.

      Upgrade information

      Product updates from earlier versions, bought on or after May 12th, 2015, are free: eligible users will be emailed a new registration string. Contact us if you have not received yours after July 7th, 2016. 

      Upgrades from licenses bought before May 12th, 2015, are available from US$ 39 per user.
      Upgrade prices for other licenses can be found on our web site. You can order upgrades from our web site.

      About Troi Automatisering

      Troi Automatisering has over 15 years experience in developing high quality cross platform plug-ins for FileMaker Pro and is winner of the FileMaker Pro Excellence Award. For more information, visit our web site at:

      Contact information  

      D. Budding
      Troi Automatisering

      Newsroom: http://www.troi.com/news/
    • By jockm
      I have been using FM 11 for Mac for the last couple of years. I have a couple of databases.
      Today, for the first time ever, my master database, which has always opened automatically when double clicked, is asking me for an Account and password.
      It is suggesting my home account, however the password for my home account is not working. I have tried all the possible passwords I can think of, but I cannot get into my file except as a guest and then I cant make any changes.
      I have no idea why this has suddenly happened. I never asked to password protect that file, I always just double clicked it and it opened right up. I have a second database and that one opens up correctly. When I look at the File/options, I see that it is checked not to require any password. So should the one I cant open.
      Can anybody help me?
      P.S. When open this database as a guest account I see that in File/options it says the Account is Admin with no password. Unfortuantely that also will not open it for modifying. 
    • By rivet
      An excellent example of how to create a password field that only shows bullets.
  • Create New...

Important Information

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