Jump to content

Get ( AccountName )

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

Recommended Posts

On the main layout I have "Get ( AccountName )" filling a field of who is logged in.


The calculation is simply Get ( AccountName ). How could I get that same field to say essentially "Welcome back, Admin".


I have tried "Welcome (Get ( AccountName ))" but the calculation doesn't like that...



Link to comment
Share on other sites


"Welcome, " & Get(AccountName)


@Lee, can someone tell the spell-check dictionary to leave "unstored" the heck alone, and not change it to "unstirred"?

Link to comment
Share on other sites

biggles1212.. I hope you were joking when you called the & a secret power. If you were NOT then please stop whatever you are developing and read everything you can on the field data types and all the text handling functionality in FM. Do not pass go. Do not collect $200.

Link to comment
Share on other sites

This topic is 2609 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

  • Similar Content

    • By Andreas T.
      I’m considering the solution bundle for a vertical market solution. One major issue looks to be the handling of user accounts.
      The various deployments all have lots of different internal Filemaker user accounts that are managed from within each solution by the local admins.
      How can one migrate those user accounts from the production version or is it something that can be recreated after the import?
      Advice welcomed.
    • By Stephen Murphy
      Hello All
      I have an excel spreadsheet with contact names, company names , email, phone etc.
      I imported the company details email & phone to the Accounts module and I imported the contact names & associated account name to the Contacts module
      How do I "relookup"  the account names so that the contact is assigned to the Account in the accounts module?
      Stephen Murphy
    • By Grundly
      Hello folks
      I am experiencing a peculiar behaviour, which is creating a user case problem, in a solution that is utilizing the Data Separation Model and WebDirect. I need to know if this behavior is normal, a bug, or if my implementation is incorrect.
      I've got an interface file and a data file. Each file has two Privilege Sets defined (in addition to [Full Access]); call them Floor and Manager. Floor has very restricted access, and Manager has more liberal access (but no where near Full Access).
      Scenario 1) I've made a script in the interface file which performs a re-login. A user logs in as Floor privileges via WEBDIRECT. User then performs the script and enters credentials for Manager. The interface file successfully performs the re-login and gains the privileges associated with Manager. However, the data file does NOT change, it does not re-login, and it still exhibits the behaviour of the Floor privileges. I know this is an incorrect implementation. Which brings me to:
      Scenario 2) I've made a script in the interface file which collects the account name and password from the user (show custom dialogue), stores them in temporary global fields and as local variables, clears the temporary global fields (keeps the variables), then performs the re-login using those variables (which works). The interface file gains the new privileges as expected. Then, that same interface script calls a re-login script in the data file, passes those login credentials to it, and then performs a re-login there in the data file as well. This works perfectly in FileMaker Pro Advanced, but it does not work in WebDirect. WebDirect still exhibits the same behaviors as described in Scenario 1: interface file does gain the new privileges, but the data file remains unchanged, retaining the original login's privilege set. 
      Thus, how can I make WebDirect act like FileMaker Pro in regards to getting both parts of data separation model to perform a re-login? 
      Thank you
    • By NewBoard
      I am currently working on a database that will score our company's suppliers.

      I have one table that contains all contact information for the suppliers (Suppliers), and another related table that contains the actual score entries (Scorecards). Suppliers are scored on pieces shipped on time and quality reports. We only ever send a scorecard to suppliers based on information from the current year, so I have a field in the Scorecards table for year. The layout I am working with is based on the Suppliers table, with a portal displaying the related entries from Scorecards in the specified year.

      Now, where I'm running into trouble is my attempt to retrieve a total for Shipped pieces for a specific Supplier in a Specific year. In other words, how do I get FMP to take many related records, and sum only related records based on data in a third field?
    • By liamob1
      HELP! I am trying to get my FM layout to have a self aware object. The object is named appropriately and the object (For example, a portal) would then use the name to filter with some form of get(name) method. Can this be done?
       In theory i want singular row portals with the name "Portal 1" to be copy an pasted. When pasting FM will automatically name this "Portal 2" (3,4,5,6 and so on). The filter will then use a "RightValue(Get(Name))" to filter down on this number.  
      CAN THIS BE DONE?   I am racking my brains trying to figure a way of doing this and making this layout dynamic >_<

  • Who Viewed the Topic

    5 members have viewed this topic:
    cjohnson  Ocean West  PCIPal  EdG  Wim Decorte 
  • Create New...

Important Information

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