{"id":28327,"date":"2022-07-25T16:53:00","date_gmt":"2022-07-25T16:53:00","guid":{"rendered":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?p=28327"},"modified":"2024-12-05T15:44:30","modified_gmt":"2024-12-05T15:44:30","slug":"lookup-fields","status":"publish","type":"post","link":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/","title":{"rendered":"[AppExchange \u2013 123FormBuilder] Lookup fields"},"content":{"rendered":"\n

You can use a lookup to search for specific information within a Salesforce record or object and return the content to the form for further use. This can be done in two ways:<\/p>\n\n\n\n

    \n
  1. To map the information to another Salesforce record (use it in the Object Mapping);<\/li>\n\n\n\n
  2. To prefill form fields (use it in Prefill Section).<\/li>\n<\/ol>\n\n\n\n

    How to Set Up a Lookup in 123FormBuilder<\/b><\/p>\n\n\n\n

    1. First, go to the Lookup<\/b> section on the left menu and click Create lookup.<\/b><\/p>\n\n\n

    \n
    \"Create<\/a><\/figure>\n<\/div>\n\n\n

    2. Afterward, select the Salesforce object where the search should be made to find a record. <\/p>\n\n\n\n

    In this case, the object will be Lead.<\/p>\n\n\n

    \n
    \"Select<\/a><\/figure>\n<\/div>\n\n\n

    3. Give a name to your lookup. You might create more than one.<\/p>\n\n\n\n

    4. The lookup can be based on an entry (or multiple entries) made on the form. You need to add a filter and select the form field(s) that will be used to search in the Lead object.<\/p>\n\n\n

    \n
    \"Select<\/a><\/figure>\n<\/div>\n\n\n

    Note<\/strong>: If you want to return information from all records in a specific object, there’s no need to add a filter. For example, if you want to display a list of all company names from Salesforce on the form, simply create a Lookup in the Account object without applying a filter, and select the Company Name field to return.<\/mark><\/p>\n\n\n\n

    5. You can add multiple filters by clicking on Add new filter<\/em>. By default, between the two filters, the AND logic operator is chosen, but you can change it to OR.<\/p>\n\n\n

    \n
    \"\"<\/a><\/figure>\n<\/div>\n\n\n

    6. If multiple records match the filters, you can select which one should be returned from your object. This option is helpful if there are duplicate records in your ORG:<\/p>\n\n\n

    \n
    \"\"<\/a><\/figure>\n<\/div>\n\n\n

    7. Once you’ve set up the filters and defined what happens if multiple records match, proceed to the Salesforce fields to return <\/b>section. Here, you can choose the Salesforce fields you want to retrieve from the record. These fields can then be used to prefill form fields or sent back to Salesforce as information for another object<\/p>\n\n\n

    \n
    \"\"<\/a><\/figure>\n<\/div>\n\n\n

    7. Lastly, save the settings by selecting the Apply Changes<\/b> button.<\/p>\n\n\n\n

    How to use<\/b> the lookup results in the Object Mapping:<\/b><\/p>\n\n\n\n

    1. Go to the Object Mapping<\/b> section and select the object where the field from Leads will be returned, in this case, Account.<\/p>\n\n\n\n

    2. Select the Salesforce field where the data should be returned and match it with the lookup object you created.<\/p>\n\n\n

    \n
    \"\"<\/a><\/figure>\n<\/div>\n\n\n

    How to use the Lookup results for Prefilling form fields<\/b><\/p>\n\n\n\n

    The lookup data can also be used to populate form fields with information from Salesforce.<\/p>\n\n\n\n

    1. Navigate to the Prefill Connector.<\/p>\n\n\n\n

    2. Click Add prefill connector<\/b>.<\/p>\n\n\n\n

    3. Go to the Prefill Connector section and select your Lookup:<\/p>\n\n\n

    \n
    \"\"<\/a><\/figure>\n<\/div>\n\n\n

    4. Define Prefill Triggers (if any).<\/p>\n\n\n\n

    5. Map your Salesforce returned fields to your Form Fields:<\/p>\n\n\n

    \n
    \"\"<\/a><\/figure>\n<\/div>\n\n\n

    Form fields will now be prefilled with the existing Salesforce data retrieved through your lookups.<\/p>\n\n\n\n

    Note<\/em><\/strong>: Ensure that the field types in your form match the corresponding field types in Salesforce. This includes aspects like input types, date formats, and character or value limitations.<\/mark><\/p>\n\n\n\n

    There are different types of prefill, each with its own setup process. To learn more, read the articles on this topic:<\/p>\n\n\n\n

      \n
    1. URL prefill setup<\/a> (when the form is shared\/used from the Salesforce side – eg: form link is sent in an email).<\/li>\n\n\n\n
    2. Dynamic Prefill<\/a> (used when you need input from the form visitor to trigger the lookup & prefill).<\/li>\n\n\n\n
    3. Experience Prefill<\/a> (the form is published on an Experience page).<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      You can use a lookup to search for specific information within a Salesforce record or object and return the content to the form for further use. This can be done in two ways: How to Set Up a Lookup in 123FormBuilder 1. First, go to the Lookup section on the left menu and click Create […]<\/p>\n","protected":false},"author":13,"featured_media":-1,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[134],"tags":[],"class_list":["post-28327","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-123formbuilder-appexchange"],"yoast_head":"\nHelp: Lookup fields in Salesforce objects | 123FormBuilder<\/title>\n<meta name=\"description\" content=\"By using a lookup field, you can search specific information within a Salesforce object. Find out more by reading our 123FormBuilder guide.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[AppExchange \u2013 123FormBuilder] Lookup fields\" \/>\n<meta property=\"og:description\" content=\"By using a lookup field, you can search specific information within a Salesforce object. Find out more by reading our 123FormBuilder guide.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/\" \/>\n<meta property=\"og:site_name\" content=\"123FormBuilder Knowledge Base\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-25T16:53:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-05T15:44:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/09\/Screenshot-2023-09-22-at-11.41.27.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1165\" \/>\n\t<meta property=\"og:image:height\" content=\"457\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Help: Lookup fields in Salesforce objects | 123FormBuilder","description":"By using a lookup field, you can search specific information within a Salesforce object. Find out more by reading our 123FormBuilder guide.","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:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/","og_locale":"en_US","og_type":"article","og_title":"[AppExchange \u2013 123FormBuilder] Lookup fields","og_description":"By using a lookup field, you can search specific information within a Salesforce object. Find out more by reading our 123FormBuilder guide.","og_url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/","og_site_name":"123FormBuilder Knowledge Base","article_published_time":"2022-07-25T16:53:00+00:00","article_modified_time":"2024-12-05T15:44:30+00:00","og_image":[{"width":1165,"height":457,"url":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/09\/Screenshot-2023-09-22-at-11.41.27.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/#article","isPartOf":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/"},"author":{"name":"admin","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/ac765b93d6689ec0f4ee6f6e040d66ea"},"headline":"[AppExchange \u2013 123FormBuilder] Lookup fields","datePublished":"2022-07-25T16:53:00+00:00","dateModified":"2024-12-05T15:44:30+00:00","mainEntityOfPage":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/"},"wordCount":563,"commentCount":4,"image":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/09\/Screenshot-2023-09-22-at-11.41.27-1024x402.png","articleSection":["AppExchange"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/","url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/","name":"Help: Lookup fields in Salesforce objects | 123FormBuilder","isPartOf":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/#primaryimage"},"image":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/09\/Screenshot-2023-09-22-at-11.41.27-1024x402.png","datePublished":"2022-07-25T16:53:00+00:00","dateModified":"2024-12-05T15:44:30+00:00","author":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/ac765b93d6689ec0f4ee6f6e040d66ea"},"description":"By using a lookup field, you can search specific information within a Salesforce object. Find out more by reading our 123FormBuilder guide.","breadcrumb":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/#primaryimage","url":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/09\/Screenshot-2023-09-22-at-11.41.27-1024x402.png","contentUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/09\/Screenshot-2023-09-22-at-11.41.27-1024x402.png"},{"@type":"BreadcrumbList","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/lookup-fields\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/"},{"@type":"ListItem","position":2,"name":"[AppExchange \u2013 123FormBuilder] Lookup fields"}]},{"@type":"WebSite","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#website","url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/","name":"123FormBuilder Knowledge Base","description":"Search our documentation platform for answers, service specifications and 3rd-party integrations.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/ac765b93d6689ec0f4ee6f6e040d66ea","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/41383a571ede8f1257b128aa53a410cc1ea4c1901ac8cea3776cba5438d24843?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2Fadmin%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/41383a571ede8f1257b128aa53a410cc1ea4c1901ac8cea3776cba5438d24843?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2Fadmin%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/41383a571ede8f1257b128aa53a410cc1ea4c1901ac8cea3776cba5438d24843?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2Fadmin%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","caption":"admin"},"url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/28327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/comments?post=28327"}],"version-history":[{"count":47,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/28327\/revisions"}],"predecessor-version":[{"id":49575,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/28327\/revisions\/49575"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/media?parent=28327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/categories?post=28327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/tags?post=28327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}