auto populated value not visible in list view after updating the value in referencing table

venkata2023
Tera Contributor

on table 'x' customer name field is referencing to customer table and auto populating vendor number field value, we created the record by selecting the customer to whom the vendor number is empty, after some days we are updating the vendor number in customer table, the same is reflecting in form, but the vendor field value is not visible on list view, its still showing empty in list view, for auto populating we used after business rule and following code is used in servicenow : (function executeRule(current, previous /*null when async*/) {

// Add your code here
current.account_number = current.customer_name.account_number;
current.region=current.customer_name.region;
current.vendor_number=current.customer_name.vendor_no;
current.company_code=current.customer_name.company_code;
current.account_currency=current.customer_name.customer_currency;
current.update();

})(current, previous);

 

Note: we are updating the vendor number is customer table after creating the record for the same customer.

first screen shot is on form, vendor showing number: 20, where as vendor number is not showing in list view, 

 

venkata2023_0-1734039699957.png

venkata2023_1-1734039903869.png

 

5 REPLIES 5

Runjay Patel
Giga Sage

Hi @venkata2023 ,

 

Try double click on list view to check whether value is there or not. If while double click value shows it means ACL issue if not then value didnt updated properly.

 

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.


Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

When i double clink the field on list view am getting the following error message :

'Security prevents writing to this field'

 

Hi @venkata2023 ,

 

It means filed level read acl is getting failed. check the read acl.

 

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.


Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

when I manually save the record, the vendor number field value is reflecting in list view