Is there a table built for US States and Canadian provinces?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2017 10:23 AM
I am looking to add a State field to a field - I have the City and Zip field as these are just strings but I was hoping to use a choice based field for the State or Province. Is there a table in ServiceNow where this is kept or do you have a resource where the best table can be downloaded and loaded into ServiceNow?
Thank you for any guidance!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2021 01:24 PM
How did you get the states to list in your drop-down?? Even using parent=United States of America isn't giving me any list of states.
Thanks,
Brandon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2021 02:25 PM
Have you tried using the sys_id for the United States of America record in your qualification something like parent=6ee51951d7320200bd4a4ebfae610354 (your sys id will be different)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2021 02:51 PM
Duh!! That did it! Total brain fart for not thinking to use that. Thanks!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-19-2021 01:45 PM
This worked great when adding a reference qualifier for Parent is United States of America. Thanks so much.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-22-2021 07:56 PM
Thanks David! Total time saver!
