Set Dependent for Custom Fields

[Jaeik Lee]

I made 2 different custom fields in sc_task table.

field1 : 

u_zassignmentid

Reference(sys_user_group)

field2 :

u_zassigneeid

Reference(sys_user)

I set field2 dependent that lookup field1 value like Assignment Group and Assigned to.

But it did not work.

Why it does not work? How can i do?

Thank you for answer.

[Jaeik Lee]

Hi. there is screen shot of my works.

   

[Tai Vu · Accepted solution]

Hi @Jaeik Lee 

I see. Thanks for capturing the details.

The above behavior does not work if the dependent reference field (field 1 above in your case) does NOT include "group" in its name.

So just include the "group" word in your field1, which is referencing to the sys_user_group table. Then replace the dependent value with the new field name. And it should do the trick.

Ref: KB0998861 - Dependent field does not work as expected on task "Assigned to" field.

Cheers,

Tai Vu

[Stefan Reichelt]

Wow, would never have guessed that it works THIS way. What a weird design. Would have been too easy for ServiceNow to make the actual dependency setting an attribute of the field.