I have an requirement to create a reason code field with 6 choice value for 50 fields

SivaranjaniR
ServiceNow Employee
ServiceNow Employee

How to achieve it without creating 50+ field on my table, the requirement is when value changes in one of the field  from yes to no they have to give a reason for it ,we have 11 language in our record with 6 field each  in total there is 66 field  each field may have different reason for changing value from yes to no.

reason code-1.PNG

 create new reason code field with choices under each field which is visible when the field value change from yes to no., is there possiblity to create a reason code field with depency of all 66 fields  when one of the field value changes then  ask for reason code why they whant  change this field value from yes to no .when changes happen reason code visible under that field only or log as related list under the table.

 

thank you in advance .

2 REPLIES 2

ShubhamGarg
Kilo Sage

Hello @SivaranjaniR ,

Have you tried Decision tables? This can also help you in achieving the required goal and without new field creation & scripting.

If my response helps you in any way, kindly mark this as Accepted Solution/Helpful and help in closing this thread.

Regards,

Shubham

Hello @ShubhamGarg  , Thank you for your response sound perfect solution, am not sure it gonna work for my requirement because  all 6 field in each language arenot having same backend value