Normal Topic custom field based on username (Read 494 times)
airjordan
Member
*
Offline



Posts: 13
Joined: Sep 11th, 2009
custom field based on username
Jul 14th, 2010 at 3:27am
Print Post Print Post  
Hi everyone,

wanting some advice whether the following is possible.

We have a current database which holds product information linked to PDF price lists.

Because our products have different names and aliases, each of our sales reps might call it a different name, therefore we want to add a field in the DB called 'aliases' where each user can enter their own 'distinguished' names they may have for the products in our library.

Is there a way to add a field to the current DB where an individual field data is customized depending on the user logged in?
ie. they only see the info they added themselves only for that particular field for each record.

thanks

Regards,
AJ

  
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: custom field based on username
Reply #1 - Jul 14th, 2010 at 4:16am
Print Post Print Post  
One way would be to add a custom field for each user, set all of them to be invisible, then only display one of them based on the @UserID variable.

The LEs on the form which are linked to the custom fields, can be stacked on top of each other (so they display in the same place on the form), or they can be relocated on-the-fly with programming.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged