Multiple reference fields from the same ref table

[lzeke]

I am new to ServiceNow, so forgive me if I ask something stupid.

I have a "main" table and a reference table called "ref". The reference table has two string columns "column1" (the "display" column) and column2. I created a form for my main table and next to its columns, I also want to show these two columns from my reference table. Also, when I select a reference record using column1 on this form, I assume that the form's column2 field will also be updated from the selected "ref" record. Simple enough.

(I am using Fuji.) To show column1 on the form I just used "ref" (since column1 is the display column), and I used dot walking for column2 (ref.column2). Both of these fields became drop downs on my main form. (I hoped that column2 will be just a string. Anyway, this was still OK.) The surprise came when I selected a record in my "ref" field (that is column1), since I could also select a value for column2 and when I saved my main record my "ref" table record got also updated with the value combination that I selected.

Being able to select both reference fields is not bad (actually, quite nice for the user), but I assumed that when I select one of them, the other will be automatically updated. This is clearly not the case - selecting a value for column2 doesn't update the field for column1. So, I am looking for a solution that either achieves this, or gives me column2 just as a read-only string field. (And by all means, I would never want the user to be able to update the ref table through this form.)

How to achieve this? Clearly, I can define a string field for column2 and use scripting to populate this field whenever column1 is changing, but I hoped that there is some simple configuration solution instead of scripting.

Any ideas?

[lzeke]

Thanks, Deepak. It does have the admin overrides by default, but even when I am impersonating a regular user I experience the same behavior.

[Ahmed Drar]

this is problem on Fuji Version this has been fixed in Fuji patch 2. I think you got two options either to upgrade to Patch 2 or to use GlideAjax to fetch your data onChange http://wiki.servicenow.com/index.php?title=GlideAjax#gsc.tab=0

Thanks,

Ahmed

[lzeke]

Thanks, Ahmed, but I am running on "glide-fuji-12-23-2014__patch2-hotfix1-03-24-2015", so it seems patch2 doesn't solve the problem. Yes, I can use GlideAjax, but I thought this is a very typical scenario and this should be handled with straightforward configuration.

[Ahmed Drar · Accepted solution]

Hi Laszlo, I am running Fuji glide-fuji-12-23-2014__patch3-04-07-2015 i see this problem is fixed,hence if you manage to get the next patch the problem will be solved 🙂 as i told it is a known problem,check link below https://community.servicenow.com/thread/181577

[lzeke]

Thanks, Ahmed - I will get the patch and check.