Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Get user from file NOT computer....

Featured Replies

Hello!

Im trying the function Get(UserName) but I only get the name of the user on the computer not in the database? How do I get it from the database?

Regards Jocke

Edited by Guest

There is no "user" per se in the database. The value from Get(UserName) is taken from the name in application preferences.

You can use Get(AccountName) to return the name of the active Account, i.e. the Account that opened the file.

If you want the value in some field that you created that is called "User" then you have to extract that in the normal manner through the calculation engine.

HTH

Steven

  • Author

Works fine but the field doesnt update if I change the user, but thats probbably some setting I have to change :

From experience, using the Get(UserName) is a pretty unsecure way of providing credentials. Because any user can change this info at any time, with or without having your program open. Unless they are using a runtime, then that changes things.

Make relog a scripted process. Then assign the field needed with the AccountName desired as part of the last script step.

Works fine but the field doesnt update if I change the user, but thats probbably some setting I have to change

That's because there is no connection between the Account Name and the User Name from preferences.

Steven

Set the calculation field to be unstored in Storage Options, if you want it to update automatically.

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.