This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

how can i load the results of a saved search as the content of a custom field in a custom record? Is this possible?

Maybe this is not the same, but I have a Sublist in a Custom Record. The sublist is populated by a Saved Search.

yes but i dont want a sublist, i need a dropdown with options that come from a saved search

you could probably achieve this in a UserEvent Script

yes i know, just asking if this could be done withouth customization

Can’t you just use the Sourcing and Filtering when you are creating your custom field?

yes but how do i source a list instead of a unique value

what is the type of record for the custom field?

and what results do you get in the saved search

build the same filters in your field setup as you have in your saved search

i need all customer addresses (as text) in a dropdown of a customer record

I think the tab Validation and Defaulting has the option for a Search

i have a custom record, i need to add a custom field as dropdown where every option is in fact addresses from a customer

1 customer could have let’s say 3 addresses: a, b and c

so i need a dropdown that lists a, b or c as text that is all

and would prefer not to have to customize it

your best hope is to use the sourcing and filtering options of the field to get what you want

<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4449822161.html> This sounds messy but also an option.

thats the obvious suitescript solution, though michael has made the mistake of asking for the non suitescript solution in the suitescript channel

not the mistake, i asked just in case there existed a way i was not aware of. Anyway, I will have to create a UE and CS, thanks a lot