How to update the field display value in List view upon field change using Business Rule

[Kevin McGartlan]

Hello, 

I am wondering how I can change the field display value for a field in list view whenever another field changes. The CSM field is dependent on the Company of the Project, which I am using a Business Rule to generate. The CSM field is getting the value from the Company on the Project, but the CSM field in list view will not change whenever the company changes. I have a client script running to do the same thing on the form, which is an OnChange script. 

Thank you!

[Ahmmed Ali]

If you can derive CSM  field values based on company field, you can use calculated script on CSM field and can have same script as BR.

It will automatically update the CSM field based on currrent company name. No need of client script or BR.

please go through below link for more details.

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/data-dictionary-tables/reference/r_DictionaryEntryForm.html

Note: after using calculated script, the CSM field will become read only.

Thanks,

Ali

[Kevin McGartlan]

Thank you for your reply. However, our requirements are to make this field not be read only. Is there a way to use the client script/Business Rule method?

[Ahmmed Ali]

Correct me if i misunderstood the requirement.

There is project field which is referencing to some table and the table has company field. you want the CSM field to set same as company of current project selected.

if yes, then best approach would be calculated script.

not understanding why the field should be editable when it is dependent on another field ?

also another best thing for above requirement would be, add dot walked company field from project table on the target form instead of creating new field for having the data which you already have on the form available.

please correct me if i missed anything.

Details on the requirement would be more helpful to suggest on best approach we can have for the requirement.

Thanks,

Ali

[Kevin McGartlan]

The CSM field points to the sys_user table, for which I created a script/business rule to grab the CSM field on the project level. The CSM is on the project record, so I created the script and business rule to grab that value since it is a single value. We don't want this field to be read-only because we want the user to still be able to create new CSM's from this form. Again, the field itself is working just fine. I'm just looking for a way to update the field value that displays in list view whenever the Company field changes when editing in list view. Thank you.