Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

Two-part question here. I'm working on a layout scheme which has a two text fields ("User Name" and "Password") and a button. I also have two value lists..."UserNames" and "Passwords." I'm hung up on figuring out the button script calculation which says if the value of "User Name" matches a custom value in the value list "UserNames" and the value of "Password" matches a custom value in the value list "Passwords" then go to layout "Success."

I've messed around with the ValueListItems function, but that either isn't what I need or I'm not getting how to use it properly. This is really just a way for me to allow certain users access to a particular layout so I don't think using Accounts & Privledges is the way to go, unless of course I'm not fully understanding it's features.

Second part of the question is is there a way to format a text field so it works like a standard html-like password field? By this I mean when the user enters a password the visible result is "

Posted

I don't think value lists are appropriate for users to select a user name and password. It kind of defeats the purpose if they can choose those from a list.

You could use a custom dialog box (this is a script step,) and have an input field for username and an input field for password (with the bullet font option selected,) but you'd still need to do comparisons of this input with something in the database to know if the script can proceed to the target layout.

It is probably easier to have an account created for each user (in Accounts and Privileges,) attached to specific privilege sets. Each user then logs in to the database with their own account and password. With this setup, you can simply have your scripts branch based on the Get(CurrentPrivilegeSet) function. You can also restrict access on a layout by layout bases (within the privilege set definition,) to block users from seeing layouts that they shouldn't see, like if they select a layout from the layout menu instead of using your navigation scripts.

Posted

Turns out while I was waiting to see if someone would respond I figured out how to do what I needed with a custom dialog box. Thanks for that idea as well as the others.

This topic is 7204 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.