Slushbucket table reference
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2013 10:46 AM
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
- Labels:
-
Discovery
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2013 11:45 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2013 01:08 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2013 08:14 PM
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