If I were wanting to pre-populate a variable with multiple choices returned from a custom data lookup table (e.g. a list of positions based on country, company & business unit), I assume I would need to explore the GlideAjax route, right?
Thanks for your video, but one thing I didn't follow is the "who_s_ordering", where is this field come from? I look at the sys_user table -> personalize list columns, but cannot locate this field. Thanks 🙂
That field is a variable name..so a variable that is created and associated to the catalog item…check out my vid on variable sets I did a while back as may at some more context
Thanks for the comment. Take each scenario/requirement case by case I would. Would email be mandatory on the user record? What’s the impact of an empty email address? Etc etc
@@ServiceNerd I got item with user data fields: name, location, phone... Values are automaticly added to user when new item is opened. AND with Client Script values are changed in flight AND with Data Lookup if ie phone is empty I got value of last full record. AND it is not working with autopopulated value HINT: Test item on portal not using this "Try It" it can give You "false positive" result.
Mind... blown! How did I not know that!🤯 How many hours wasted doing GlideAjax calls!!! Loving the videos, no idea you had this channel! Would love a collab at some point :)
Don't worry..after this, ill be spending some time sorting out the mic audio...and some money on the camera.😂🎤🎥
Thank you! Just saved me from a headache!
Love this! 👆. Thanks.
Very Helpful! This saved me created a ton of unnecessary questions and ui policies.
Excellent!! These are the comments that make the endless hours editing these vids worth it :). Thanks
If I were wanting to pre-populate a variable with multiple choices returned from a custom data lookup table (e.g. a list of positions based on country, company & business unit), I assume I would need to explore the GlideAjax route, right?
Thanks for the comment!
The Cat data lookup is pretty simple in terms of "grab attribute off single table"...anything more complex then yeah I'd go for ye olde GlideAjax.
Did. Not. Know. Thanks!
Awesome!! Love it when I know I’ve added some value somewhere 😀👍
Thanks for your video, but one thing I didn't follow is the "who_s_ordering", where is this field come from?
I look at the sys_user table -> personalize list columns, but cannot locate this field.
Thanks 🙂
Hey! Thanks for the comment!
That field is a variable name..so a variable that is created and associated to the catalog item…check out my vid on variable sets I did a while back as may at some more context
What if the who's ordering variable type is not Reference but SelectBox? would it work?
Thanks for the comment. I dont a reason why not. The beauty of ServiceNow is you can play around on your PDI. Give it a go and let me know!
@@ServiceNerd Indeed it worked :D
OK. But what if email is empty??? Should I use Client Script to check it?
Thanks for the comment. Take each scenario/requirement case by case I would. Would email be mandatory on the user record? What’s the impact of an empty email address? Etc etc
@@ServiceNerd I got item with user data fields: name, location, phone... Values are automaticly added to user when new item is opened.
AND with Client Script values are changed in flight
AND with Data Lookup if ie phone is empty I got value of last full record.
AND it is not working with autopopulated value
HINT: Test item on portal not using this "Try It" it can give You "false positive" result.
why department is prepopulating with sys_id of user
Mind... blown! How did I not know that!🤯 How many hours wasted doing GlideAjax calls!!! Loving the videos, no idea you had this channel! Would love a collab at some point :)
Haha!..who doesnt love a sneaky GlideAjax!?! 😂 . As someone once not so famous said.."every days a school day"!
And sure...give me a shout sometime..would be good to catchup.