by eggsurplus

Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SugarCRM or SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.

Free 30 day trial
Try it Now

By clicking you consent to share your profile with the developer

#1332 - Show only team related values in dropdown menus

Closed General Question created by telintel 7 years ago

Hi

We have 3 teams, all of them must use a dropdown menu called product, but the values for each team are different in this menu: something like

Product a b c d e f

a, b and c are only for team 1 c and d for the team 2 a, e and f for the team 3

Is there a way to show only the info related for each team in this dropdown menu?

thanks

  1. eggsurplus member avatar

    eggsurplus Provider Affiliate

    7 years ago

    Hi there,

    There's a way to do anything with Sugar, but unfortunately this one would require some custom coding to filter out the unwanted products for each user/team. Basically you will need to have that field pull it's values from a function and in that function grab the main list from the app_list_strings and do your logic to remove the unneeded products on the fly. Here is how to do the hard part of setting up the function. The logic will need to be changed for your usage:

    http://www.eggsurplus.com/content/populate-a-dropdown-from-the-database/

    Hope that helps! -Jason

  2. eggsurplus member avatar

    eggsurplus Provider Affiliate

    7 years ago

    Other alternative is to have 3 separate fields all with the correct version of the list for each team. Then create a custom view in Studio for each team and show the correct product field for that team.

  3. telintel member avatar

    telintel

    7 years ago

    Hi, thanks for your answer... I think that we must use the 1st option, since the Product info is used in some charts.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating