AnsweredAssumed Answered

Get the logged in user and company name?

Question asked by jackmac on Feb 15, 2018
Latest reply on Feb 15, 2018 by Johan Hedman

Hi all,

 

I have a front end file which the user logs in to.  I have a simple text box which displays the name of the user (Welcome g:AccountName which when user the user sees it they see Welcome Jane if Jane logs in) who logs in and that works fine. It uses a global AccountName field.

 

I now need to display the department name too. Say John works in Sales, Jane in Accounts and Joe in Engineering.  When Jane logs in I need it to show 'Welcome Jane - Engineering'.

 

I have a table in the back end file with all users in there but I need it to look at the name of the logged in user and extract Name and Department.  I can get one or the other, any ideas?

 

FM Pro Adv 15

Mac High Sierra

 

TIA

 

Jack

Outcomes