how to dot walk string field to choice field which are on the same form?

[Rajeev ponuguma]

we have a custom table for cyberark safe,where safe name is String type field and safe install status is  a choice type field.

And in a catalog form we need to auto populate safe install status based on safe name given on the form.

Can someone please help me how we can i get the install status based on safe name given? since safe name is not reference field is dot walking possible in client script or business rule ?

[RaghavSh]

Dot walk is not possible in string fields, but you can glide that table with safe name as query (in BR) or use GliideAjax ( in client script) and populate the install_status value

[Rajeev ponuguma]

Thanks Raghav,

we need to auto populate install status based on safe value given which is dynamic,can you please help me  what is the query i need to use on safe table?

[RaghavSh]

since it is a catalog form you will need to use glideajax, you can pass the value of safe variable using newValue , your client script should be an on chage.

Refer : https://docs.servicenow.com/en-US/bundle/tokyo-application-development/page/script/ajax/topic/p_AJAX...