{"id":3946,"date":"2017-08-21T15:28:14","date_gmt":"2017-08-21T15:28:14","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-access-multi-select-field-values-in-netsuite-formulas-2\/"},"modified":"2026-07-28T18:26:16","modified_gmt":"2026-07-28T18:26:16","slug":"comment-acceder-aux-valeurs-des-champs-a-selection-multiple-dans-les-formules-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-acceder-aux-valeurs-des-champs-a-selection-multiple-dans-les-formules-netsuite\/","title":{"rendered":"Comment acc\u00e9der aux valeurs des champs \u00e0 s\u00e9lection multiple dans les formules NetSuite"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"D\u00e9couvrez comment r\u00e9cup\u00e9rer et analyser les identifiants internes \u00e0 partir de champs \u00e0 s\u00e9lection multiple \u00e0 l\u2019aide des formules NetSuite.","ga_short_answer":"Les workflows NetSuite peuvent lire les champs \u00e0 s\u00e9lection multiple et g\u00e9n\u00e9rer une liste concat\u00e9n\u00e9e d\u2019identifiants internes utilisant le suffixe .id. Bien que des formules telles que REGEXP_SUBSTR et CASE WHEN puissent \u00eatre cr\u00e9\u00e9es pour \u00e9valuer ces identifiants, la prudence est de mise lorsque vous utilisez directement ces formules dans les conditions de workflow, en particulier avec plusieurs valeurs s\u00e9lectionn\u00e9es, en raison de limitations connues en mati\u00e8re de fiabilit\u00e9.","ga_scenario":"Les utilisateurs de NetSuite ont souvent besoin d\u2019\u00e9valuer les valeurs s\u00e9lectionn\u00e9es dans un champ \u00e0 s\u00e9lection multiple, par exemple pour v\u00e9rifier si un utilisateur sp\u00e9cifique figure dans une liste d\u2019approbateurs. L\u2019acc\u00e8s direct \u00e0 ces valeurs et leur comparaison au sein des conditions d\u2019un workflow peuvent poser des difficult\u00e9s, en particulier lorsque le champ contient plusieurs s\u00e9lections.","ga_solution":"Les champs \u00e0 s\u00e9lection multiple peuvent \u00eatre lus dans NetSuite, ce qui g\u00e9n\u00e8re une sortie concat\u00e9n\u00e9e de toutes les valeurs s\u00e9lectionn\u00e9es. Pour r\u00e9cup\u00e9rer les identifiants internes de ces valeurs, ajoutez \u00ab .id \u00bb \u00e0 l\u2019identifiant du champ \u00e0 s\u00e9lection multiple. Par exemple, si l\u2019identifiant du champ \u00e0 s\u00e9lection multiple est \u00ab custbody_gs_approvers \u00bb, ses identifiants internes sont accessibles sous la forme \u00ab {custbody_gs_approvers.id} \u00bb. Des formules utilisant les fonctions REGEXP_SUBSTR et CASE WHEN peuvent \u00eatre cr\u00e9\u00e9es pour \u00e9valuer ces identifiants internes concat\u00e9n\u00e9s. Voici un exemple de formule permettant de v\u00e9rifier si l\u2019identifiant de l\u2019utilisateur actuel figure dans un champ \u00e0 s\u00e9lection multiple \u00ab approbateurs \u00bb :\n\n```\nCASE WHEN REGEXP_SUBSTR({custbody_gs_approvers.id} ,{user.id}) = {user.id} THEN 1 ELSE 0 END = 1\n```\n\n. Cette formule peut int\u00e9grer des champs de workflow ou des champs joints selon les besoins.Consid\u00e9ration importante concernant les conditions de workflow : bien que la logique de la formule sous-jacente soit valable pour \u00e9valuer les identifiants internes, il est important de noter une limitation connue : les conditions de workflow peuvent \u00e9chouer de mani\u00e8re silencieuse lors de l\u2019\u00e9valuation de champs \u00e0 s\u00e9lection multiple contenant plus d\u2019une valeur s\u00e9lectionn\u00e9e. Par cons\u00e9quent, bien que la formule montre comment lire et \u00e9valuer les identifiants de champs \u00e0 s\u00e9lection multiple, son application directe au sein de conditions de workflow pour des champs comportant plusieurs s\u00e9lections doit \u00eatre abord\u00e9e avec prudence et faire l\u2019objet de tests approfondis.","ga_source_author":"Brian Stisser","ga_source_author_email":"","ga_date_original":"2017-08-21T11:28:14-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"How can you read a multi-select field with a workflow?","ga_ans_id":"ANS-0287","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"verify_soon","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The claim that multi-select fields can be read by workflow with the output being a concatenation of all values, and subsequently used in a workflow condition with REGEXP_SUBSTR, is problematic. While the field can output concatenated IDs, workflow conditions are known to silently fail when evaluating multi-select fields with multiple values, making the proposed formula unreliable in that specific context.","ga_final_category":"Custom Fields, Records & Forms","footnotes":""},"ga_category":[97,22,97],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-3946","qa_entry","type-qa_entry","status-publish","hentry","ga_category-champs-personnalises-enregistrements-et-formulaires","ga_category-custom-fields-records-forms","ga_audience-administrateur-netsuite","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":97,"label":"Champs personnalis\u00e9s, enregistrements et formulaires"},{"value":22,"label":"Custom Fields, Records & Forms"},{"value":97,"label":"Champs personnalis\u00e9s, enregistrements et formulaires"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":92,"label":"Niveau interm\u00e9diaire"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3946\/revisions"}],"predecessor-version":[{"id":5867,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3946\/revisions\/5867"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3946"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3946"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3946"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}