Setter Field for Data Lookup Definition issue

[luisesparza]

Hi! I'm practicing Data Lookup. I've been able to follow the process as it appears in Data Lookup and Record Matching Support - ServiceNow Wiki . When I get to the "Create Data Lookup Definition Record" section I am able to create the new Matcher Field Definitions succesfully, but I can't do the same with the new Setter Field Definition since ServiceNow does not display the dropdown list for either the Source Table Field or the Matcher Table Field (no choices displayed).

I also tried with the out of box Priority Lookup Definition regarding the Priority and it didn't work either when I tried to add a new Setter Rule.

I'm currently working with an free developer instance and the version is Fuji. I'm working with admin rights.

Thanks!

[DrewW]

Sounds like some how something did not get created correctly.

Can you post some screen shots?

[luisesparza]

Thanks for replying, Drew West. Here are some screenshots:

Here's the Color Lookup I created at Data Lookup Definitions. As you can see I already set the Matcher Field Definitions for two fields that I'm considering (by the way: they are defined as choice items, and they are primary colors).

As you can see in the screenshot below I can't create the Setter Field Definitions. When I try to display the options nothing happens. It's like the choice fields do not make communication to the corresponding tables containing those fields (but then why does it work correctly for Matcher Field Definitions?).

The following screenshot shows the fields for the Color Preference table, which I use a the Source Table, and it is where the user will choose two primary colors (Likes color 1 & 2); the intention is to fill the Ideal color field automatically based on the color the user chooses. The options (Red, Blue, Yellow) display correctly.

This is the Color Lookup Rules table (used as Matcher Table) where I have defined the different color combinations (Color 1 & 2 are the input colors, Color 3 should be the output).

Finally, for the record, this is the Setter Field Definition for Priority Lookup. The weid thing is that even when it is an out of box feature, it behaves just like the one I defined myself (it does not allow to display the corresponding options). Something else I should mention is that two of my co-workers tried by themselves as well, and we all have the same situation, which got us quite confused by now.

[fredklein · Accepted solution]

Workaround:

In the form of the Setter Field Definition, right-click on the header to configure the form layout.

Add the two following fields

- Source table

- Matcher table

NB: these two fields will NOT show up, but seem to be needed there for properly populating Source table field drop-down and Matcher table field drop-down.

Credits CGE!!! 🙂

[luisesparza]

It works! Thanks a lot!!!!