AnsweredAssumed Answered

Matching user name to user in table

Question asked by colindunn on Nov 28, 2017
Latest reply on Nov 29, 2017 by wimdecorte

I have a table of users, each with a __pkUserID field that corresponds to their Account Name that I created in the File > Manage > Security pane. Each user also has an __fkTeamID. When a user creates a new record I would like to set the __fkTeamID to the same __fkTeamID as the currently logged in user.

 

Said another way, I need to get the currently logged in user's account name and match it to a user in my user's table. Then I want to get that user's associated Team ID.

 

What's the best way to accomplish this?

 

Screen Shot 2017-11-28 at 2.43.43 PM.png

Outcomes