how to show reference field values based on other choice field

[AnilM99]

Hi Team,

I created one Choice field and Reference field. 

1. Select Day (Choice field)

a. Monday

b. Wednesday 

c. Friday

2. Select groups for Meeting (Reference field)

My requirement is show groups according to the selected days

e.g,

When manager selects Monday, it should show Only -- Service-desk, Hardware, ServiceNow

When manager selects Wednesday, it should show Only -- Cab-Approval 

When manager selects Friday, it should show Only -- HR 

Thanks,

Anil!

[Ashutosh C J · Accepted solution]

Hi @AnilM99 
Please use advanced reference qualifier for group field and create a function in scriptinclude
Use this function as reference :

    getGroups: function(day) {
		if (day == "monday") {
            return "name=Service Desk^ORname=Hardware";  // Use exact group names 
        } else if (day == "tuesday")
            return "name=Software^ORname=App Engine Admins"; 
    },

Please mark my solution as accepted or helpful to help the community better