How to show values in Service CI field ( dropdown)

[Supriya25]

Hi All,
kindly share your thoughts and suggestions on below issue

we have close to 30+ option values in Service CI .

Please let me know how can we do this, 
1. Do we have to create OnLOAD client script with using removeOption & addOption in script ? Without using addOption and removeOption  can we achieve in another way. ?
2. Without using script can't we achieve this ?
3. If I create a OnLoad client script ,  script crossing 100+ lines , don't we have other alternative way ?

While creating new request user able to select Service CI as per below , on existing record for everyone it should be readonly.

On new record : if Logged-In User belongs to below
For Admin's roles users :
Service CI field should be readonly and selected with "General"

For Apple support Group :
Show only Apple related values in Service CI

For Samsung Support Group
Show only Samsung related values in Service CI

For Realme Support Group
Show only Realme related values in Service CI

For OCI P2 Support group
Show only Realme & Samsung related values in Service CI

For OCI P1 Support group
Show only Google Pixel & Apple related values in Service CI

For Partner Groups
Show only Google Pixel & Apple & Samsung related values in Service CI


can't we achieve this with ZERO code ?  
Can't we achieve this without using Client scripts  ? without using addOption, removeOption ? ??

[Supriya25]

Hi @Its_Azar , thanks for your valuable reply.

we can't design it as Reference field. it should be Choice field/string type only.

can't we achieve this with ZERO code ?  
Can't we achieve this without using Client scripts  ? without using addOption, removeOption ? ??

[Its_Azar]

Hi again @Supriya25 

Not really. That works but becomes hard and messsyy with too many values. Instead, use a Reference Qualifier (advanced) with a Script Include that returns the right filter based on user group. Much efficientr and reusable.

Since your filtering logic depends on support group membership, you’ll need at least a small Script Include or reference qualifier script. Out-of-the-box configuration alone won't handle this dynamic logic

If this helps kindly accept the solution

[Supriya25]

Hi @Its_Azar ,

Sorry we can't design "Service CI " field as a Reference field. we must use it in dropdown only.

without using Reference qualifier , if there is any alternative solution that would be great helpful.

[Its_Azar]

Hi again! Got it  i understand how requirements can be with lot of restrictions— if we can’t use a reference field for “Service CI” and need to stick with a dropdown, one workaround could be using a dynamic choice list via a Scripted Choice or a Lookup Table that filters based on context. Another option is to create a custom Script Include that returns filtered values and populate the dropdown using a UI policy script or client script (onLoad). It won’t be as seamless as reference qualifiers, but still its a good option.

If this helps kindly accept the solution.

[Supriya25]

Please advice me the process if data lookup table works .
my condition is based on Logged in user , values has to be populated. so is that achievable from Datalookup ? if Yes suggest me process

if logged in user belongs For Apple support Group :
Show only Apple related values in Service CI(choice field)

if logged in user belongs For OCI P1 Support group
Show only Google Pixel & Apple related values in Service CI
....
etc