#1332 - Show only team related values in dropdown menus
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
9 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
9 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.
9 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.