Slushbucket table reference

gvye
Kilo Explorer

So i got a request to add a sluchbucket to our Change Request form.

What i did first was create a table and add a few records to it for the slushbucket to reference.
Example.
Tablename: Hair
Color: Brown
Blonde
Black

I then created a new column on the Change Request form through the Dictionary.
Table reference was "Change Request"
column name: "Hair Color"
Type: "Slushbucket"
Choice: "Dropdown - with no"
Choice Table: "Hair"
Choice Field: "Color"

When i add the slushbucket to the form, the available side is always empty. Even when i right click the Slushbucket field and go to Personalize Choices and manually add them in, the available side was still empty.

Im not sure if im missing something? I could use some help.

Thanks in advance

3 REPLIES 3

Michael Kaufman
Giga Guru

When you created the field on the Change Request, right click the change request form and use "Personalize Form > Create New Field". Then create a reference field to that "hair" table you created. That is an easier way to create a field.

The way you are creating a slushbucket isn't correct using the dictionary I believe.

Hope that helps,
Mike


gvye
Kilo Explorer

Hi Mike,
Thank you for your reply.

In this case a reference field wont work, i need to be able to select multiple values at once. I figured the slushbucket would be the cleanest looking way to set this up. There would only be about a dozen or so values id need to add to the slushbucket.

Any ideas on how to set this up properlY?


This might help you out:

If you are creating a 1 to Many Relationship.

1. On the "Hair Color" form. right click and use Personalize > Form Layout
2. Create New Field. "Change Request", Reference, Change Request
3. On Change Request Form, right click and Personalize > Related Lists
4. Add "Hair Color > Change Request"

For a Many to Many Relationship

I have an example:

http://community.servicenow.com/blog/mkaufman/many-many-list-creation-example

1. Type sys_m2m.list in the Navigation Filter Text
2. From Table: Hair Color
Many to Many Table: Change Request
3. Click "Create Many to Many"
4. On Change Request Form, right click and Personalize > Related Lists
5. Add Hair Color

Hope that helps,

Mike