how to populate values in a related list dynamically

[sohan_snow]

Hi All,

The requirement is that the values in the related list should change dynamically and show all records based on a value selected in the field 'Customer Ref'. I was able to achieve it partially via creating a Relationship, but need help in changing the values dynamically in related list.

Is there anyother way that this can done.

Relationship:L

Thanks & Regards,

[sohan_snow]

Hi Pradeep,

thanks a lot for your revert... the below is how I tried but it failed

Note:   My intention is to show the Users only the corresponding records in the related list in accordance to the value in the field 'Customer Ref' , they should not be saving\updating anything on the form. As of now, This entire thing is for display purpose only i.e the users will select a value in the 'Customer Ref' and the related list displays the records accordingly.

1. opened a record "Acme Australi" in a new tab

2. displayed in the related list were all the records related to "Acme Autralia"

3. Now changed the value in field:Customer Ref as "Adagio" and CLICKED on the UI Action : Refresh.   The Related list did not change.

Please note I did not save the form, had I saved the form then the record would have been updated and the related will show as per the value in the 'Customer Ref'.

[Pradeep Sharma · Accepted solution]

Thanks for the steps. I've made few changes in UI action and it is working fine now. Please test and let me know.

[sohan_snow]

Bingo... Thanks a ton Pradeep....on CLICKING the REFRESH button. the records in related list is indeed updating.

but its creating a new record as well... is it possible that no records are amended. End users should only be displayed the records in the related list based on the value changed in the field : 'Customer Ref'.

[Pradeep Sharma]

Hello Sohan,

Thanks for the update. I don't think you can get the records listed on the related list unless you save the value in the database. However, the alternate solution for your requirement is to create an additional field which can be filtered based on the referene qualifier. More info here.

Reference Qualifiers - ServiceNow Wiki

[Pradeep Sharma]

Let me know if that answered your question. If so, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list. Thank you

How To Mark Answers Correct From Community Inbox