https://netsuiteprofessionals.com logo
Join Slack
Powered by
does anyone know how to create a join or vlookup i...
# general
c
does anyone know how to create a join or vlookup in NetSuite? I have two lists of values Category and Commerce Category but I don't know how to have the Commerce Category automatically determined based on what the Category value is. For instance, when someone selects Winter Hats on an Item record, I want the Commerce Category of Hats, Visor, & Headbands to be automatically selected
a
workflow could solve that, I mean set one field value based on another field value. But it doesn't look a nice way by example if more categories are added in future. Maybe we could have one record type with several two or more columns instead of two very similar lists?
k
You can do this with dependent drop downs
Custom records and custom fields
Looked at this again after waking up - I see that it's always 1 for 1 - so what I would do is turn category into a custom record, add a custom field to that custom record called Commerece Category Assignment, then either script or workflow that commerce category gets automatically set based on the value assigned to the custom record assigned in the category box
This could be done on a scheduled basis, or could be done on a before user submit basis, either would be functional - of course if you have a website the answer might change a bit on what you want doing when
c
thank you both for the responses. @KevinJ of Kansas let me give it a try and see if I can get it to work. thanks again
do you mean custom record type or other record field?
k
So your category field or commerce category - are they custom lists in a custom field?
or are they standard NS fields?
c
neither are created yet. they can be whatever
k
Oh, then that is much easier
So what you'll do is create a new custom field - and create a new custom record type at the same time
for your category
and then once you have your custom record created, then you add a field to it to represent the commerce category
then you create a custom list for your commerce category and assign that to your commerce category field (I got these last two steps out of order) haha
c
awesome. let me give it a shot!
k
Once you do that - you can then workflow to say "if this doesn't equal this from this record join - set field value here"
c
actually one more question: if I needed the commerce category to be based on the values of two fields, how much more complicated would this get? For instance, if the commerce category was womens hats which was a combination of the fields gender and category
k
A little bit harder. And "Auto Setting" it might not be an option anymore, and instead you wind up back to my first response that I thought you were asking for which is to filter it down to only valid responses.
c
using dependent drop downs?
k
correct
c
I did figure this out by the way. thanks again
k
Glad to hear it, what did you wind up doing?
c
about 5 dependable lists together
Parent Product Category (Mens Women)>>Commerce Category (Tops, Bottom,)>>Category (short sleeve shirt)
7 Views
Open in Slack
PreviousNext
Powered by