is it possible to use SuiteQL to source the values...
# ask-stanley-ai
m
is it possible to use SuiteQL to source the values in a multi-select field?
c
AI generated answer (using internal Slack threads):
Based on the conversations, it appears that it is not directly possible to use SuiteQL to source the values in a multi-select field. However, you can achieve this in a roundabout way by performing a search and adding select options where the record id is the id in the list and the text value is another column from your search. This can be done in a Suitelet form using SuiteScript. Here is an example of how you can create a select field sourced from a specific record type (e.g., 'customer'):
Copy code
javascript
form.addField({
 id: 'custpage_customer_list', 
 label: 'Customer List', 
 type: serverWidget.FieldType.SELECT, 
 source: 'customer'
})
In this example, the 'source' attribute is set to 'customer', which means the select field will be populated with all the customers in the system. However, this method does not directly use SuiteQL and the source is limited to NetSuite record types. Please note that the options for sourcing and filtering fields via the UI are generally more limited than a saved search. If you need more complex filtering, you might need to create a custom sublist or field and use the
Field.addSelectOption
method to add your own options. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.867997825
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.860356629
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.85259521
Please provide your feedback on this answer.