{"id":1365,"date":"2018-10-01T19:13:57","date_gmt":"2018-10-02T02:13:57","guid":{"rendered":"https:\/\/support.gwapps.com\/?post_type=ht_kb&p=1365"},"modified":"2023-02-22T14:30:17","modified_gmt":"2023-02-22T22:30:17","slug":"form-fields-components-multi-lookup","status":"publish","type":"ht_kb","link":"https:\/\/support.gwapps.com\/es\/knowledge-base\/form-fields-components-multi-lookup\/","title":{"rendered":"Form Fields & Components: Lookup Fields"},"content":{"rendered":"

A Lookup Fields field is like a List Selection field, except it allows you to look up more than one value in a single selection action. For example, you might have a help desk application, and when select the service rep’s first name you could also have the rep’s last name and phone number pulled into the record at the same time.<\/p>\n

Adding a Lookup Fields to a form will start a wizard to help you configure the field correctly. The wizard has 3 steps. In the steps below we will continue with the example of a help desk application, where you want to lookup the service rep’s first name, last name and phone number in a single selection action.<\/span><\/p>\n

Note: The Lookup Fields field type used to be called a Multi Lookup. In some properties and dialog boxes, it is still referred to as “Multi Lookup”. They are both the same field type.<\/p>\n

Step 1 – Lookup Source<\/h2>\n

In this step we tell GW Apps where to lookup information from, just like in List Selection fields. You select the desired app to lookup from, and the form in that app to lookup records for. The App to Lookup from will be pre-filled with the current application name.<\/p>\n\n\n\n\n\n\n
Wizard Step 1 – Starting look<\/b><\/td>\n<\/tr>\n
\"Multi<\/td>\n<\/tr>\n
Wizard Step 1 – With settings completed<\/b><\/td>\n<\/tr>\n
\"Multi<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n
Field<\/b><\/td>\nDescripci\u00f3n<\/b><\/td>\n<\/tr>\n
App to Lookup from<\/td>\nThe App to Lookup records from. (The field will be pre-filled with the current application name.)<\/td>\n<\/tr>\n
Form to Lookup from<\/td>\nThe form in the selected app to lookup records form.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Step 2 – Display in Dropdown<\/h2>\n

In this step we tell GW Apps what fields should display in the dropdown of the Lookup Fields field on the form when the user is making a selection. List Selection fields show only a single column of values, but the Lookup Fields can display multiple columns of values in the selection list.<\/p>\n\n\n\n\n\n\n
Wizard Step 2 – Starting look<\/b><\/td>\n<\/tr>\n
\"New<\/td>\n<\/tr>\n
Wizard Step 2 – With settings completed<\/b><\/td>\n<\/tr>\n
\"Multi<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n
Field<\/b><\/td>\nDescripci\u00f3n<\/b><\/td>\n<\/tr>\n
Field to add to the lookup dropdown<\/td>\nThis is a list of the fields on the selected form. Select the desired field from the list and click on the + symbol at the right side of the field to add it to the current list.<\/td>\n<\/tr>\n
Fields to display in the Multi Lookup dropdown<\/td>\nThe current list of field values that will be displayed while a user is making a selection in the Lookup Fields field. The up \/ down arrows can be used to change the order of the fields, and the minus sign at the left of the field name can be used to remove that field from the list.<\/p>\n

The first field in the list will also become the value actually stored directly in the Lookup Fields field.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Step 3 – Saved to Form<\/h2>\n

In this step we tell GW Apps which field values to add to the record after the user has completed their selection. We can add some or all of the fields displayed in the dropdown, and we can also add fields not displayed in the dropdown.<\/p>\n\n\n\n\n
Wizard Step 3<\/b><\/td>\n<\/tr>\n
\"Multi<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n
Field<\/b><\/td>\nDescripci\u00f3n<\/b><\/td>\n<\/tr>\n
Field to add to the form<\/td>\nThis is a list of the fields that will be added to the record after the user has completed their selection. Select the desired field from the list and click on the + symbol at the right side of the field to add it to the current list.<\/td>\n<\/tr>\n
Fields to be added to the form<\/td>\nThe current list of field values that that will be added to the record after the user has completed their selection in the Lookup Fields. The up \/ down arrows can be used to change the order of the fields, and the minus sign at the left of the field name can be used to remove that field from the list.<\/p>\n

The first field in the dropdown display list will always become the value actually stored directly in the Lookup Fields field. As this field is already taken care of, it is not displayed in the list of ‘Fields to be added to the form’.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Lookup Fields Field Properties<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n
Ajustes<\/b><\/td>\nDescripci\u00f3n<\/b><\/td>\n<\/tr>\n
Pesta\u00f1a b\u00e1sica \/ Configuraci\u00f3n general<\/strong><\/td>\n<\/tr>\n
Nombre visible<\/span>
\nTexto de ayuda de campo<\/span>
\nRequerido<\/span><\/td>\n		Ver <\/span>Caracter\u00edsticas Generales del Campo<\/span><\/a><\/td>\n<\/tr>\n
Options Tab \/ Lookup Options<\/strong><\/td>\n<\/tr>\n
<\/td>\nShows the selected app, form and field value stored in the Lookup Fields.<\/td>\n<\/tr>\n
Fields linked to this Multi Lookup<\/td>\nShows the additional fields added to the form by the Lookup Fields wizard.<\/td>\n<\/tr>\n
\u00a0 \u00a0 Unlink<\/strong><\/span><\/td>\nClicking on the Unlink option will turn that field in to an ordinary field of that type (Text, Number, etc). It will no longer have its value set when the user makes a selection in the Lookup Fields field.<\/td>\n<\/tr>\n
Options Tab \/ Lookup Filters<\/strong><\/td>\n<\/tr>\n
<\/td>\nAllows to you to filter which records will be displayed in the Lookup Fields selection list. For example, only showing Service Reps that work in the same state as listed in the “Customer Location State” field on the same record.<\/p>\n

Ver\u00a0<\/span>Form Fields & Components:\u00a0 Lookup Filters<\/span><\/a> for more details on setting a lookup filter.<\/span><\/td>\n<\/tr>\n

Pesta\u00f1a avanzada \/ Visibilidad condicional<\/strong> \u2013 Ve <\/span>Visibilidad condicional<\/span><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n
Properties – Lookup Options<\/b><\/td>\n<\/tr>\n
\"Lookup<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Lookup Fields Field Usage Example<\/h2>\n\n\n\n\n
\u00a0Multi Lookup usage example<\/b><\/td>\n<\/tr>\n
\"Ejemplo<\/td>\n<\/tr>\n<\/tbody>\n<\/table>","protected":false},"excerpt":{"rendered":"

A Lookup Fields field is like a List Selection field, except it allows you to look up more than one value in a single selection action. For example, you might have a help desk application, and when select the service rep’s first name you could also have the rep’s last…<\/p>","protected":false},"author":2,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"content-type":"","footnotes":""},"ht-kb-category":[25],"ht-kb-tag":[],"class_list":["post-1365","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-form-fields"],"yoast_head":"\nMulti Lookup Field - Form Fields & Components - GW Apps - Support<\/title>\n<meta name=\"description\" content=\"Form Fields & Components | Learn more about the Multi Lookup field, e.g., how to configure Multi Lookup field through it's properties.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/support.gwapps.com\/es\/knowledge-base\/form-fields-components-multi-lookup\/\" \/>\n<meta property=\"og:locale\" content=\"es_MX\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Multi Lookup Field - Form Fields & Components - GW Apps - Support\" \/>\n<meta property=\"og:description\" content=\"Form Fields & Components | Learn more about the Multi Lookup field, e.g., how to configure Multi Lookup field through it's properties.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/support.gwapps.com\/es\/knowledge-base\/form-fields-components-multi-lookup\/\" \/>\n<meta property=\"og:site_name\" content=\"GW Apps - Support\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/gwappsinc\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-22T22:30:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/support.gwapps.com\/wp-content\/uploads\/2018\/10\/Multi-Lookup-Dlg-P1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@GWApps_Inc\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/support.gwapps.com\\\/knowledge-base\\\/form-fields-components-multi-lookup\\\/\",\"url\":\"https:\\\/\\\/support.gwapps.com\\\/knowledge-base\\\/form-fields-components-multi-lookup\\\/\",\"name\":\"Multi Lookup Field - Form Fields & Components - GW Apps - Support\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/support.gwapps.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/support.gwapps.com\\\/knowledge-base\\\/form-fields-components-multi-lookup\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/support.gwapps.com\\\/knowledge-base\\\/form-fields-components-multi-lookup\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/support.gwapps.com\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/Multi-Lookup-Dlg-P1.png\",\"datePublished\":\"2018-10-02T02:13:57+00:00\",\"dateModified\":\"2023-02-22T22:30:17+00:00\",\"description\":\"Form Fields & Components | Learn more about the Multi Lookup field, e.g., how to configure Multi Lookup field through it's properties.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/support.gwapps.com\\\/knowledge-base\\\/form-fields-components-multi-lookup\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/support.gwapps.com\\\/knowledge-base\\\/form-fields-components-multi-lookup\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/support.gwapps.com\\\/knowledge-base\\\/form-fields-components-multi-lookup\\\/#primaryimage\",\"url\":\"https:\\\/\\\/support.gwapps.com\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/Multi-Lookup-Dlg-P1.png\",\"contentUrl\":\"https:\\\/\\\/support.gwapps.com\\\/wp-content\\\/uploads\\\/2018\\\/10\\\/Multi-Lookup-Dlg-P1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/support.gwapps.com\\\/knowledge-base\\\/form-fields-components-multi-lookup\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/support.gwapps.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Form Fields & Components: Lookup Fields\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/support.gwapps.com\\\/#website\",\"url\":\"https:\\\/\\\/support.gwapps.com\\\/\",\"name\":\"GW Apps - Support\",\"description\":\"Democratizing web app development for businesses\",\"publisher\":{\"@id\":\"https:\\\/\\\/support.gwapps.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/support.gwapps.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/support.gwapps.com\\\/#organization\",\"name\":\"GW Apps\",\"url\":\"https:\\\/\\\/support.gwapps.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/support.gwapps.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/support.gwapps.com\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/GWApps_logo_black.png\",\"contentUrl\":\"https:\\\/\\\/support.gwapps.com\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/GWApps_logo_black.png\",\"width\":745,\"height\":357,\"caption\":\"GW Apps\"},\"image\":{\"@id\":\"https:\\\/\\\/support.gwapps.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/gwappsinc\",\"https:\\\/\\\/x.com\\\/GWApps_Inc\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/gwapps\\\/posts\\\/?feedView=all\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCyN1tnP1Owrti0PYxEkQDaQ\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Multi Lookup Field - Form Fields & Components - GW Apps - Support","description":"Form Fields & Components | Learn more about the Multi Lookup field, e.g., how to configure Multi Lookup field through it's properties.","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:\/\/support.gwapps.com\/es\/knowledge-base\/form-fields-components-multi-lookup\/","og_locale":"es_MX","og_type":"article","og_title":"Multi Lookup Field - Form Fields & Components - GW Apps - Support","og_description":"Form Fields & Components | Learn more about the Multi Lookup field, e.g., how to configure Multi Lookup field through it's properties.","og_url":"https:\/\/support.gwapps.com\/es\/knowledge-base\/form-fields-components-multi-lookup\/","og_site_name":"GW Apps - Support","article_publisher":"https:\/\/www.facebook.com\/gwappsinc","article_modified_time":"2023-02-22T22:30:17+00:00","og_image":[{"url":"https:\/\/support.gwapps.com\/wp-content\/uploads\/2018\/10\/Multi-Lookup-Dlg-P1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@GWApps_Inc","twitter_misc":{"Tiempo de lectura":"6 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/support.gwapps.com\/knowledge-base\/form-fields-components-multi-lookup\/","url":"https:\/\/support.gwapps.com\/knowledge-base\/form-fields-components-multi-lookup\/","name":"Multi Lookup Field - Form Fields & Components - GW Apps - Support","isPartOf":{"@id":"https:\/\/support.gwapps.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/support.gwapps.com\/knowledge-base\/form-fields-components-multi-lookup\/#primaryimage"},"image":{"@id":"https:\/\/support.gwapps.com\/knowledge-base\/form-fields-components-multi-lookup\/#primaryimage"},"thumbnailUrl":"https:\/\/support.gwapps.com\/wp-content\/uploads\/2018\/10\/Multi-Lookup-Dlg-P1.png","datePublished":"2018-10-02T02:13:57+00:00","dateModified":"2023-02-22T22:30:17+00:00","description":"Form Fields & Components | Learn more about the Multi Lookup field, e.g., how to configure Multi Lookup field through it's properties.","breadcrumb":{"@id":"https:\/\/support.gwapps.com\/knowledge-base\/form-fields-components-multi-lookup\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/support.gwapps.com\/knowledge-base\/form-fields-components-multi-lookup\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/support.gwapps.com\/knowledge-base\/form-fields-components-multi-lookup\/#primaryimage","url":"https:\/\/support.gwapps.com\/wp-content\/uploads\/2018\/10\/Multi-Lookup-Dlg-P1.png","contentUrl":"https:\/\/support.gwapps.com\/wp-content\/uploads\/2018\/10\/Multi-Lookup-Dlg-P1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/support.gwapps.com\/knowledge-base\/form-fields-components-multi-lookup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.gwapps.com\/"},{"@type":"ListItem","position":2,"name":"Form Fields & Components: Lookup Fields"}]},{"@type":"WebSite","@id":"https:\/\/support.gwapps.com\/#website","url":"https:\/\/support.gwapps.com\/","name":"GW Apps - Soporte","description":"Democratizando el desarrollo de aplicaciones web para empresas","publisher":{"@id":"https:\/\/support.gwapps.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/support.gwapps.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/support.gwapps.com\/#organization","name":"GW Apps","url":"https:\/\/support.gwapps.com\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/support.gwapps.com\/#\/schema\/logo\/image\/","url":"https:\/\/support.gwapps.com\/wp-content\/uploads\/2021\/04\/GWApps_logo_black.png","contentUrl":"https:\/\/support.gwapps.com\/wp-content\/uploads\/2021\/04\/GWApps_logo_black.png","width":745,"height":357,"caption":"GW Apps"},"image":{"@id":"https:\/\/support.gwapps.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/gwappsinc","https:\/\/x.com\/GWApps_Inc","https:\/\/www.linkedin.com\/company\/gwapps\/posts\/?feedView=all","https:\/\/www.youtube.com\/channel\/UCyN1tnP1Owrti0PYxEkQDaQ"]}]}},"_links":{"self":[{"href":"https:\/\/support.gwapps.com\/es\/wp-json\/wp\/v2\/ht-kb\/1365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.gwapps.com\/es\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/support.gwapps.com\/es\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.gwapps.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.gwapps.com\/es\/wp-json\/wp\/v2\/comments?post=1365"}],"version-history":[{"count":18,"href":"https:\/\/support.gwapps.com\/es\/wp-json\/wp\/v2\/ht-kb\/1365\/revisions"}],"predecessor-version":[{"id":5807,"href":"https:\/\/support.gwapps.com\/es\/wp-json\/wp\/v2\/ht-kb\/1365\/revisions\/5807"}],"wp:attachment":[{"href":"https:\/\/support.gwapps.com\/es\/wp-json\/wp\/v2\/media?parent=1365"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.gwapps.com\/es\/wp-json\/wp\/v2\/ht-kb-category?post=1365"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.gwapps.com\/es\/wp-json\/wp\/v2\/ht-kb-tag?post=1365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}