Custom Fields to SFSUser table


Author
Message
Guillermo Vilas
Guillermo Vilas
StrataFrame User (294 reputation)StrataFrame User (294 reputation)StrataFrame User (294 reputation)StrataFrame User (294 reputation)StrataFrame User (294 reputation)StrataFrame User (294 reputation)StrataFrame User (294 reputation)StrataFrame User (294 reputation)StrataFrame User (294 reputation)
Group: StrataFrame Users
Posts: 112, Visits: 2.3K
Hello

What is the best way to extend the SFSUser Table to add custom user fields (eg. EmployeeID, Title, Phone Numbers)

Thanks

------------------------------------------------------------------------
I would like to change the world, but they don´t give me the source code.
MS Windows 7 Ultimate 64-Bit
Intel(R) Core(TM)2 Quad CPU Q9300 2.50 GHz
6.00 GB of RAM, NVIDIA GeForce 9800 GT

MacBook Pro i5 OSX Lion
Reply
Larry Caylor
Larry Caylor
StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)
Group: Awaiting Activation
Posts: 592, Visits: 3.7K

I don’t know what others are doing, but as Ben suggests, I started out by adding a table to the data base to hold the additional user fields that contained a foreign key from SFSuser.  As Ben would probably not recommend, I modified the SF user maintenance dialog by adding a tab to maintain the added info along with a BO that mapped to my new table. It looked and worked great, however keeping my version of Role Based Security in sync the SF release quickly got old. I ended up building my own “Additional User Info” maintenance screen that has the same look and feel of the SF user maintenance dialog. On my main form I have a User maintenance menu with “Security” and “User Info” sub menus to bring up the proper dialog.

 

I also added some logic to AppMain that checks to make sure the additional user info fields are populated when the user logs in and exposes those fields via public properties of a static class.  

 

-Larry

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search