{"id":3050,"date":"2019-04-02T00:15:22","date_gmt":"2019-04-02T06:15:22","guid":{"rendered":"https:\/\/wpsheeteditor.com\/es\/?post_type=snippets&#038;p=3050"},"modified":"2019-07-01T21:50:37","modified_gmt":"2019-07-02T03:50:37","slug":"mostrar-celdas-como-desplegables","status":"publish","type":"snippets","link":"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/","title":{"rendered":"Mostrar Celdas como Desplegables"},"content":{"rendered":"<p>En este tutorial te mostraremos c\u00f3mo mostrar una celda de texto como desplegable, para que los usuarios puedan seleccionar valores de una lista predefinida.<\/p>\n<p>Ejemplo:<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/04\/26213542\/cell-dropdown.png\" alt=\"\" width=\"450\" height=\"216\" class=\"aligncenter size-full wp-image-3051\" srcset=\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/04\/26213542\/cell-dropdown.png 450w, https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/04\/26213542\/cell-dropdown-300x144.png 300w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"php\">add_action('vg_sheet_editor\/editor\/before_init', 'wpse_modify_column_settings', 999);\r\n\r\nfunction wpse_modify_column_settings($editor) {\t\t\r\n  \/\/ spreadsheet key. For example, \"user\" for the users spreadsheet, post, page, or a post type key\r\n  $post_type = 'post';\r\n  \/\/ column key that you are editing\r\n  $meta_key = '_expiration-date';\r\n  \/\/ Options for the dropdown. The array key is saved in the database and the value is displayed as label for the user.\r\n  $options = array(\r\n     'no' =&gt; __('Do not allow', 'woocommerce'),\r\n     'notify' =&gt; __('Allow, but notify customer', 'woocommerce'),\r\n     'yes' =&gt; __('Allow', 'woocommerce'),\r\n  );\r\n\r\n  $editor-&gt;args['columns']-&gt;register_item($meta_key, $post_type, array(\r\n    'formatted' =&gt; array(\r\n        'data' =&gt; $meta_key, \r\n        'editor' =&gt; 'select',\r\n        'selectOptions' =&gt; $options\r\n     )\r\n  ), true);\r\n}<\/pre>\n","protected":false},"featured_media":0,"template":"","meta":{"_acf_changed":false,"_custom_body_class":"","_custom_post_class":"","_links_to":"","_links_to_target":""},"class_list":["post-3050","snippets","type-snippets","status-publish","hentry","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Mostrar Celdas como Desplegables - WP Sheet Editor en Espa\u00f1ol<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mostrar Celdas como Desplegables - WP Sheet Editor en Espa\u00f1ol\" \/>\n<meta property=\"og:description\" content=\"En este tutorial te mostraremos c\u00f3mo mostrar una celda de texto como desplegable, para que los usuarios puedan seleccionar valores de una lista predefinida. Ejemplo: add_action(&#039;vg_sheet_editor\/editor\/before_init&#039;, &#039;wpse_modify_column_settings&#039;, 999); function wpse_modify_column_settings($editor) { \/\/ spreadsheet key. For example, &quot;user&quot; for the users spreadsheet, post, page, or a post type key $post_type = &#039;post&#039;; \/\/ column key that [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/\" \/>\n<meta property=\"og:site_name\" content=\"WP Sheet Editor en Espa\u00f1ol\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-02T03:50:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wpsheeteditor.com\/es\/wp-content\/uploads\/sites\/3\/2019\/04\/cell-dropdown.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/\",\"url\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/\",\"name\":\"Mostrar Celdas como Desplegables - WP Sheet Editor en Espa\u00f1ol\",\"isPartOf\":{\"@id\":\"https:\/\/wpsheeteditor.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/wpsheeteditor.com\/es\/wp-content\/uploads\/sites\/3\/2019\/04\/cell-dropdown.png\",\"datePublished\":\"2019-04-02T06:15:22+00:00\",\"dateModified\":\"2019-07-02T03:50:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/#primaryimage\",\"url\":\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/04\/26213542\/cell-dropdown.png\",\"contentUrl\":\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/04\/26213542\/cell-dropdown.png\",\"width\":450,\"height\":216},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/wpsheeteditor.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Snippets\",\"item\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Mostrar Celdas como Desplegables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/wpsheeteditor.com\/es\/#website\",\"url\":\"https:\/\/wpsheeteditor.com\/es\/\",\"name\":\"WP Sheet Editor en Espa\u00f1ol\",\"description\":\"Edita miles de posts y p\u00e1ginas r\u00e1pidamente\",\"publisher\":{\"@id\":\"https:\/\/wpsheeteditor.com\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/wpsheeteditor.com\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/wpsheeteditor.com\/es\/#organization\",\"name\":\"WP Sheet Editor\",\"url\":\"https:\/\/wpsheeteditor.com\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/wpsheeteditor.com\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2016\/06\/26203459\/logo-248x102.png\",\"contentUrl\":\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2016\/06\/26203459\/logo-248x102.png\",\"width\":248,\"height\":102,\"caption\":\"WP Sheet Editor\"},\"image\":{\"@id\":\"https:\/\/wpsheeteditor.com\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mostrar Celdas como Desplegables - WP Sheet Editor en Espa\u00f1ol","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/","og_locale":"es_ES","og_type":"article","og_title":"Mostrar Celdas como Desplegables - WP Sheet Editor en Espa\u00f1ol","og_description":"En este tutorial te mostraremos c\u00f3mo mostrar una celda de texto como desplegable, para que los usuarios puedan seleccionar valores de una lista predefinida. Ejemplo: add_action('vg_sheet_editor\/editor\/before_init', 'wpse_modify_column_settings', 999); function wpse_modify_column_settings($editor) { \/\/ spreadsheet key. For example, \"user\" for the users spreadsheet, post, page, or a post type key $post_type = 'post'; \/\/ column key that [&hellip;]","og_url":"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/","og_site_name":"WP Sheet Editor en Espa\u00f1ol","article_modified_time":"2019-07-02T03:50:37+00:00","og_image":[{"url":"https:\/\/wpsheeteditor.com\/es\/wp-content\/uploads\/sites\/3\/2019\/04\/cell-dropdown.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/","url":"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/","name":"Mostrar Celdas como Desplegables - WP Sheet Editor en Espa\u00f1ol","isPartOf":{"@id":"https:\/\/wpsheeteditor.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/#primaryimage"},"image":{"@id":"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/#primaryimage"},"thumbnailUrl":"https:\/\/wpsheeteditor.com\/es\/wp-content\/uploads\/sites\/3\/2019\/04\/cell-dropdown.png","datePublished":"2019-04-02T06:15:22+00:00","dateModified":"2019-07-02T03:50:37+00:00","breadcrumb":{"@id":"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/#primaryimage","url":"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/04\/26213542\/cell-dropdown.png","contentUrl":"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/04\/26213542\/cell-dropdown.png","width":450,"height":216},{"@type":"BreadcrumbList","@id":"https:\/\/wpsheeteditor.com\/es\/snippets\/mostrar-celdas-como-desplegables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wpsheeteditor.com\/es\/"},{"@type":"ListItem","position":2,"name":"Snippets","item":"https:\/\/wpsheeteditor.com\/es\/snippets\/"},{"@type":"ListItem","position":3,"name":"Mostrar Celdas como Desplegables"}]},{"@type":"WebSite","@id":"https:\/\/wpsheeteditor.com\/es\/#website","url":"https:\/\/wpsheeteditor.com\/es\/","name":"WP Sheet Editor en Espa\u00f1ol","description":"Edita miles de posts y p\u00e1ginas r\u00e1pidamente","publisher":{"@id":"https:\/\/wpsheeteditor.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wpsheeteditor.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/wpsheeteditor.com\/es\/#organization","name":"WP Sheet Editor","url":"https:\/\/wpsheeteditor.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/wpsheeteditor.com\/es\/#\/schema\/logo\/image\/","url":"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2016\/06\/26203459\/logo-248x102.png","contentUrl":"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2016\/06\/26203459\/logo-248x102.png","width":248,"height":102,"caption":"WP Sheet Editor"},"image":{"@id":"https:\/\/wpsheeteditor.com\/es\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/wpsheeteditor.com\/es\/wp-json\/wp\/v2\/snippets\/3050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpsheeteditor.com\/es\/wp-json\/wp\/v2\/snippets"}],"about":[{"href":"https:\/\/wpsheeteditor.com\/es\/wp-json\/wp\/v2\/types\/snippets"}],"wp:attachment":[{"href":"https:\/\/wpsheeteditor.com\/es\/wp-json\/wp\/v2\/media?parent=3050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}