2 Replies Latest reply on Jan 7, 2014 10:02 AM by AppGuy

    Auto Enter on Creation

    schmity

      Title

      Auto Enter on Creation

      Post

           I see there are 2 options as far as a user name in the auto enter on creation field...name and account name. 

           One seems to be the username used to actually login to the database, the other seems to be the username set under the FileMaker application preferences.

            

           Is there a way to run a script to pull the account description and use this instead of the username?  We use employee numbers as usernames, but have the employees real name entered in the account description field.

           Using employee numbers makes it easier to login, but with 100 employees, its difficult for everyone to remember everyone else's employee numbers.  Setting the user name under preferences is also not an option because many people share 1 computer login.

        • 1. Re: Auto Enter on Creation
          philmodjunk

               We use employee numbers as usernames, but have the employees real name entered in the account description field.

               If this field is accessible via a relationship, then you can use either the calculation or looked up value auto-enter options to copy the data into a text field in your new record. You can auto-enter the username into one field and use a second field to auto-enter the name. Or you can just link to that record in a related table.

               But account names might be a better option than user names--which are specific to a given user account on a given computer. An employee could log in with their account name on a different employee's work station--perhaps during an emergency, and the work will be logged under the wrong employee ID if you use a user name.

          • 2. Re: Auto Enter on Creation
            AppGuy

                 Are your users entered in the filemaker security, LDAP, or in a database table?