Link a record to another record — a user, owner, document, or project — and show it as a clickable reference.
A lookup field links one record to another instead of storing plain text. For example, a lookup field on an account can point to a project, so the account shows that project as a clickable link you can open directly.
A lookup field stores a reference to the linked record, not a copy of it. The field always shows the linked record’s current name — rename the project, document, or person and the lookup updates to match automatically.
When you create a lookup field, you choose what it points at. Each lookup field links to exactly one record of its chosen type:
Type
Links to
Shows
Lookup – User
a Statisfy user (a member of your team)
the user’s name
Lookup – Owner
an account owner
the owner’s name
Lookup – Document
a collaboration document
the document title, linked to the document
Lookup – Project
a project
the project title, linked to the project
For User and Owner lookups, you search for a person by name and select them.
For Document and Project lookups, you search for the document or project by name and link it; the linked record then appears as a clickable link that opens it directly.
Looking for a Contact lookup? Linking to a contact (person record) isn’t available yet — use a User or Owner lookup for team members.
Once a lookup field has a value, the linked record shows up — as the record’s name, and as a clickable link for Document and Project lookups — everywhere the field is displayed:
On the account, contact, or opportunity detail page, when viewing or editing the field.
In list views — the Accounts, People, and Opportunities tables, both when viewing and when editing them directly in the table.
In bulk edit, when you set the field across multiple records at once.
Step 1: Go to Settings → Object Manager, or use Create Fields from an account, contact, or opportunity.Step 2: Enter a name for the field, and choose one of the lookup types above (for example, Lookup – Project) as the field type.Step 3: Save the field. It’s now available on those records, ready for users to search for and link a record.
Open the field, search for the record by name, and select it to create the link. To remove the link, clear the selection and the field returns to empty.
You can set a lookup field in bulk: select multiple records, choose the lookup field, and link them all to a single record at once.
Every account includes a built-in Onboarding Project field — a Lookup – Project field that designates which project is the account’s onboarding project. Set it the same way as any other lookup field: it shows the linked project as a clickable link and stays empty until you choose a project.This field isn’t only a label. If you publish a customer portal that shows a project, the portal reads this field on the signed-in customer’s account to decide which project to show them — so an empty field means the portal’s project area renders with nothing in it. The value is read live at sign-in, so correcting the field takes effect immediately, with no republish. See Setting Up Portals. To have this field filled in automatically rather than by hand, see Project Template Automations.
Was this page helpful?
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Statisfy","description":"Statisfy is an agentic platform for customer intelligence, supporting both pre-sales and post-sales workflows with unified customer context across the entire customer lifecycle.","colors":{"primary":"#6366F1","light":"#818CF8","dark":"#4F46E5"},"logo":{"light":"https://mintcdn.com/statisfy/-mEFnxVd9s5kL3ir/resources/logo-light.svg?fit=max\u0026auto=format\u0026n=-mEFnxVd9s5kL3ir\u0026q=85\u0026s=c42ea5d3e828945c05d618cdb0f658b9","dark":"https://mintcdn.com/statisfy/-mEFnxVd9s5kL3ir/resources/logo-dark.svg?fit=max\u0026auto=format\u0026n=-mEFnxVd9s5kL3ir\u0026q=85\u0026s=252d43adf6de24dd1079dcd2cd276f72","href":"https://statisfy.com"},"favicon":"https://mintcdn.com/statisfy/-mEFnxVd9s5kL3ir/favicon.svg?fit=max\u0026auto=format\u0026n=-mEFnxVd9s5kL3ir\u0026q=85\u0026s=d8936b2ddf2ff2af5ad66c7673c2a97e","navbar":{"links":[{"href":"mailto:support@statisfy.com","label":"Support"}]},"footer":{"socials":{"linkedin":"https://linkedin.com/company/statisfy"}},"styling":{"latex":true},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"statisfy","hasAudioNarration":false,"actualSubdomain":"statisfy","customDomains":["help.statisfy.com"],"gitSource":{"type":"github","owner":"statisfy-us","repo":"repo","deployBranch":"main","contentDirectory":"help-docs","isPrivate":true,"mountPath":"","label":""},"feedback":{"thumbs":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6af45ec89ab9c7bf98cbd4a9","clientVersion":"0.0.4102","searchFilterCounts":[{"language":"default","tag":"Documentation","count":125},{"language":"default","tag":"Integrations","count":59},{"language":"default","tag":"Admin","count":24},{"language":"default","tag":"Portals","count":21},{"language":"default","tag":"Settings","count":18},{"language":"default","tag":"API Reference","count":14},{"language":"default","tag":"sdk","count":14},{"language":"default","tag":"Agent Studio","count":13},{"language":"default","tag":"Analytics","count":13},{"language":"default","tag":"Projects","count":11}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableAskAiSearchBar":true,"deflection":{"enabled":true,"email":"support@statisfy.com","showHelpButton":true}},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"custom-fields/lookup_fields","slug":"/custom-fields/lookup_fields","pageMetadata":{"title":"Lookup Fields","description":"Link a record to another record — a user, owner, document, or project — and show it as a clickable reference.","href":"/custom-fields/lookup_fields"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Link a record to another record — a user, owner, document, or project — and show it as a clickable reference.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,em:`em`,li:`li`,p:`p`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,ul:`ul`,..._provideComponents(),...props.components},{Heading,Note,Table,Tip}=_components;if(!Heading)_missingMdxReference(`Heading`,true);if(!Note)_missingMdxReference(`Note`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Tip)_missingMdxReference(`Tip`,true);return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[`A `,_jsx(_components.strong,{children:`lookup field`}),` links one record to another instead of storing plain text. For example, a lookup field on an account can point to a `,_jsx(_components.strong,{children:`project`}),`, so the account shows that project as a clickable link you can open directly.`]}),`\n`,_jsx(Note,{children:_jsxs(_components.p,{children:[`A lookup field stores a `,_jsx(_components.em,{children:`reference`}),` to the linked record, not a copy of it. The field always shows the linked record’s current name — rename the project, document, or person and the lookup updates to match automatically.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`supported-lookup-types`,children:`Supported lookup types`}),`\n`,_jsx(_components.p,{children:`When you create a lookup field, you choose what it points at. Each lookup field links to exactly one record of its chosen type:`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Type`}),_jsx(_components.th,{children:`Links to`}),_jsx(_components.th,{children:`Shows`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Lookup – User`})}),_jsx(_components.td,{children:`a Statisfy user (a member of your team)`}),_jsx(_components.td,{children:`the user’s name`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Lookup – Owner`})}),_jsx(_components.td,{children:`an account owner`}),_jsx(_components.td,{children:`the owner’s name`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Lookup – Document`})}),_jsx(_components.td,{children:`a collaboration document`}),_jsx(_components.td,{children:`the document title, linked to the document`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Lookup – Project`})}),_jsx(_components.td,{children:`a project`}),_jsx(_components.td,{children:`the project title, linked to the project`})]})]})]}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`For `,_jsx(_components.strong,{children:`User`}),` and `,_jsx(_components.strong,{children:`Owner`}),` lookups, you search for a person by name and select them.`]}),`\n`,_jsxs(_components.li,{children:[`For `,_jsx(_components.strong,{children:`Document`}),` and `,_jsx(_components.strong,{children:`Project`}),` lookups, you search for the document or project by name and link it; the linked record then appears as a clickable link that opens it directly.`]}),`\n`]}),`\n`,_jsx(Note,{children:_jsxs(_components.p,{children:[`Looking for a `,_jsx(_components.strong,{children:`Contact`}),` lookup? Linking to a contact (person record) isn’t available yet — use a User or Owner lookup for team members.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`where-lookup-fields-appear`,children:`Where lookup fields appear`}),`\n`,_jsx(_components.p,{children:`Once a lookup field has a value, the linked record shows up — as the record’s name, and as a clickable link for Document and Project lookups — everywhere the field is displayed:`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:`On the account, contact, or opportunity detail page, when viewing or editing the field.`}),`\n`,_jsx(_components.li,{children:`In list views — the Accounts, People, and Opportunities tables, both when viewing and when editing them directly in the table.`}),`\n`,_jsx(_components.li,{children:`In bulk edit, when you set the field across multiple records at once.`}),`\n`]}),`\n`,_jsx(Heading,{level:`2`,id:`create-a-lookup-field`,children:`Create a lookup field`}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Step 1:`}),` Go to `,_jsx(_components.strong,{children:`Settings → Object Manager`}),`, or use `,_jsx(_components.strong,{children:`Create Fields`}),` from an account, contact, or opportunity.`]}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Step 2:`}),` Enter a name for the field, and choose one of the lookup types above (for example, `,_jsx(_components.strong,{children:`Lookup – Project`}),`) as the field type.`]}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Step 3:`}),` Save the field. It’s now available on those records, ready for users to search for and link a record.`]}),`\n`,_jsx(Heading,{level:`2`,id:`set-or-clear-a-value`,children:`Set or clear a value`}),`\n`,_jsx(_components.p,{children:`Open the field, search for the record by name, and select it to create the link. To remove the link, clear the selection and the field returns to empty.`}),`\n`,_jsx(Tip,{children:_jsx(_components.p,{children:`You can set a lookup field in bulk: select multiple records, choose the lookup field, and link them all to a single record at once.`})}),`\n`,_jsx(Heading,{level:`2`,id:`the-onboarding-project-field`,children:`The Onboarding Project field`}),`\n`,_jsxs(_components.p,{children:[`Every account includes a built-in `,_jsx(_components.strong,{children:`Onboarding Project`}),` field — a Lookup – Project field that designates which project is the account’s onboarding project. Set it the same way as any other lookup field: it shows the linked project as a clickable link and stays empty until you choose a project.`]}),`\n`,_jsxs(_components.p,{children:[`This field isn’t only a label. If you publish a `,_jsx(_components.a,{href:`/portals/overview`,children:`customer portal`}),` that shows a project, the portal reads this field on the signed-in customer’s account to decide which project to show them — so an empty field means the portal’s project area renders with nothing in it. The value is read live at sign-in, so correcting the field takes effect immediately, with no republish. See `,_jsx(_components.a,{href:`/portals/setting_up_portals#step-3-point-each-account-at-its-onboarding-project`,children:`Setting Up Portals`}),`. To have this field filled in automatically rather than by hand, see `,_jsx(_components.a,{href:`/projects/project_template_automations`,children:`Project Template Automations`}),`.`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Lookup Fields","description":"Link a record to another record — a user, owner, document, or project — and show it as a clickable reference.","href":"/custom-fields/lookup_fields"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Supported lookup types","slug":"supported-lookup-types","depth":2,"children":[]},{"title":"Where lookup fields appear","slug":"where-lookup-fields-appear","depth":2,"children":[]},{"title":"Create a lookup field","slug":"create-a-lookup-field","depth":2,"children":[]},{"title":"Set or clear a value","slug":"set-or-clear-a-value","depth":2,"children":[]},{"title":"The Onboarding Project field","slug":"the-onboarding-project-field","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"statisfy","siteName":"Statisfy","title":"Lookup Fields - Statisfy","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-09-03T14:42:12.433Z","originalFileLocation":"custom-fields/lookup_fields.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Link a record to another record — a user, owner, document, or project — and show it as a clickable reference.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Statisfy\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/statisfy/ZxOxPYgd4D__ShIN/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/statisfy/ZxOxPYgd4D__ShIN/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/statisfy/ZxOxPYgd4D__ShIN/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/statisfy/ZxOxPYgd4D__ShIN/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/statisfy/ZxOxPYgd4D__ShIN/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/statisfy/ZxOxPYgd4D__ShIN/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/statisfy/ZxOxPYgd4D__ShIN/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/statisfy/ZxOxPYgd4D__ShIN/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/statisfy/ZxOxPYgd4D__ShIN/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Lookup Fields - Statisfy\">\u003cmeta data-mint-head property=\"og:description\" content=\"Link a record to another record — a user, owner, document, or project — and show it as a clickable reference.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Statisfy\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://help.statisfy.com/custom-fields/lookup_fields\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://statisfy.mintlify.site/_mintlify/api/og/v2?division=Filters+%26+Custom+Fields\u0026amp;title=Lookup+Fields\u0026amp;description=Link+a+record+to+another+record+%E2%80%94+a+user%2C+owner%2C+document%2C+or+project+%E2%80%94+and+show+it+as+a+clickable+reference.\u0026amp;theme=d0d553b77df82a6b94d02599\u0026amp;signature=2e6e98f92c384a846e06cefd945cbc61843b33a0e2ba3471d8e7740c78b37b0b\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Lookup Fields - Statisfy\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Link a record to another record — a user, owner, document, or project — and show it as a clickable reference.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://statisfy.mintlify.site/_mintlify/api/og/v2?division=Filters+%26+Custom+Fields\u0026amp;title=Lookup+Fields\u0026amp;description=Link+a+record+to+another+record+%E2%80%94+a+user%2C+owner%2C+document%2C+or+project+%E2%80%94+and+show+it+as+a+clickable+reference.\u0026amp;theme=d0d553b77df82a6b94d02599\u0026amp;signature=2e6e98f92c384a846e06cefd945cbc61843b33a0e2ba3471d8e7740c78b37b0b\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/statisfy/ZxOxPYgd4D__ShIN/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Statisfy\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#6366F1\">\u003clink data-mint-head rel=\"canonical\" href=\"https://help.statisfy.com/custom-fields/lookup_fields\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/custom-fields/lookup_fields.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://help.statisfy.com/#organization\",\"name\":\"Statisfy\",\"url\":\"https://help.statisfy.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/statisfy/-mEFnxVd9s5kL3ir/resources/logo-light.svg?fit=max\u0026auto=format\u0026n=-mEFnxVd9s5kL3ir\u0026q=85\u0026s=c42ea5d3e828945c05d618cdb0f658b9\"}},{\"@type\":\"WebSite\",\"@id\":\"https://help.statisfy.com#website\",\"name\":\"Statisfy\",\"url\":\"https://help.statisfy.com\",\"publisher\":{\"@id\":\"https://help.statisfy.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://help.statisfy.com/custom-fields/lookup_fields#webpage\",\"url\":\"https://help.statisfy.com/custom-fields/lookup_fields\",\"name\":\"Lookup Fields\",\"description\":\"Link a record to another record — a user, owner, document, or project — and show it as a clickable reference.\",\"dateModified\":\"2026-09-03T14:42:12.433Z\",\"isPartOf\":{\"@id\":\"https://help.statisfy.com#website\"},\"breadcrumb\":{\"@id\":\"https://help.statisfy.com/custom-fields/lookup_fields#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://help.statisfy.com/custom-fields/lookup_fields#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Filters \u0026 Custom Fields\",\"item\":\"https://help.statisfy.com/filters/how_to_use_the_new_filter_and_do_updates_on_account_fields\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Lookup Fields\",\"item\":\"https://help.statisfy.com/custom-fields/lookup_fields\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://help.statisfy.com/custom-fields/lookup_fields#article\",\"headline\":\"Lookup Fields\",\"name\":\"Lookup Fields\",\"description\":\"Link a record to another record — a user, owner, document, or project — and show it as a clickable reference.\",\"url\":\"https://help.statisfy.com/custom-fields/lookup_fields\",\"mainEntityOfPage\":{\"@id\":\"https://help.statisfy.com/custom-fields/lookup_fields#webpage\"},\"dateModified\":\"2026-09-03T14:42:12.433Z\",\"publisher\":{\"@id\":\"https://help.statisfy.com/#organization\"},\"isPartOf\":{\"@id\":\"https://help.statisfy.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Statisfy\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Statisfy\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/custom-fields/lookup_fields.md","siteName":"Statisfy","nav":{"global":null,"tabs":[{"tab":"Documentation","groups":[{"group":"Getting Started","pages":[{"title":"Introduction","href":"/getting-started/introduction"},{"title":"Quickstart","href":"/getting-started/quickstart"},{"title":"Key Concepts","href":"/getting-started/key-concepts"},{"title":"Global Search","href":"/getting-started/global_search"}]},{"group":"Accounts","pages":[{"title":"Section Overview Of Accounts","href":"/accounts/section_overview_of_accounts"},{"title":"Account Page Navigation","href":"/accounts/account_page_navigation"},{"title":"Managing Files","href":"/accounts/managing_files"},{"title":"Account Management Additional Filtering Guide","href":"/accounts/account_management_additional_filtering_guide"},{"title":"Export Account Data","href":"/accounts/export_account_data"},{"title":"Renewals","href":"/accounts/renewals"},{"title":"Renewal Forecast","href":"/accounts/renewal_forecast"},{"title":"Account Health \u0026 Hierarchy","href":"/accounts/account_health_and_hierarchy"},{"title":"Merging Duplicate Accounts","href":"/accounts/merging_duplicate_accounts"},{"title":"Refresh from CRM","href":"/accounts/refresh_from_crm"}]},{"group":"People \u0026 Contacts","pages":[{"title":"Section Overview Of People Contact","href":"/people/section_overview_of_people_contact"},{"title":"Managing People","href":"/people/managing_people"},{"title":"People Custom Fields","href":"/people/people_custom_fields"}]},{"group":"Opportunities","pages":[{"title":"Section Overview Of Opportunity","href":"/opportunities/section_overview_of_opportunity"},{"title":"Creating A New Opportunity","href":"/opportunities/creating_a_new_opportunity"},{"title":"Create And Edit Custom Opportunity Fields","href":"/opportunities/create_and_edit_custom_opportunity_fields"}]},{"group":"Activities","pages":[{"title":"Add Manual Activity","href":"/activities/add_manual_activity"},{"title":"Viewing Activities","href":"/activities/viewing_activities"},{"title":"Managing Activities","href":"/activities/managing_activities"},{"title":"Activity AI Fields","href":"/activities/activity_ai_fields"},{"title":"Activity Sharing","href":"/activities/activity_sharing"}]},{"group":"Views","pages":[{"title":"Creating New View And Exporting The Data","href":"/views/creating_new_view_and_exporting_the_data"},{"title":"Creating A New People Contact View And Exporting It","href":"/views/creating_a_new_people_contact_view_and_exporting_it"},{"title":"Set Default View In Accounts","href":"/views/set_default_view_in_accounts"},{"title":"Marking Views As Global","href":"/views/marking_views_as_global"},{"title":"Sharing A View","href":"/views/sharing_a_view"},{"title":"Renaming A View Tutorial","href":"/views/renaming_a_view_tutorial"},{"title":"Deleting A View","href":"/views/deleting_a_view"}]},{"group":"Filters \u0026 Custom Fields","pages":[{"title":"How To Use The New Filter And Do Updates On Account Fields","href":"/filters/how_to_use_the_new_filter_and_do_updates_on_account_fields"},{"title":"Creating Custom Fields","href":"/custom-fields/creating_custom_fields"},{"title":"Display Labels for Picklist Options","description":"Show friendly labels for dropdown options while keeping the underlying value unchanged.","href":"/custom-fields/option_display_labels"},{"title":"Lookup Fields","href":"/custom-fields/lookup_fields"},{"title":"Formula Fields","description":"Create calculated fields using formulas, rollups, cross-object references, and time calculations.","href":"/custom-fields/formula_fields"},{"title":"AI-Managed Custom Fields","href":"/custom-fields/ai_managed_fields"}]},{"group":"Projects","pages":[{"title":"Project Management Overview","href":"/projects/project_management_overview"},{"title":"Create Project From Template","href":"/projects/create_project_from_template"},{"title":"Create Project Using Blank Template","href":"/projects/create_project_using_blank_template"},{"title":"Project Template Creation Guide","href":"/projects/project_template_creation_guide"},{"title":"Per-task Custom Fields","href":"/projects/per_task_custom_fields_in_templates"},{"title":"Project Template Automations","href":"/projects/project_template_automations"},{"title":"Task Dependencies \u0026 Auto-Cascade Dates","href":"/projects/task_dependencies_and_cascading"},{"title":"Milestones \u0026 Task Hierarchy","href":"/projects/milestones_and_task_hierarchy"},{"title":"Reorder \u0026 Reparent Tasks with Drag and Drop","href":"/projects/drag_drop_task_ordering"},{"title":"Export Project Tasks Guide","href":"/projects/export_project_tasks_guide"},{"title":"External sharing","href":"/projects/external_sharing"}]},{"group":"Tasks","pages":[{"title":"Task Management UI Navigation","href":"/tasks/task_management_ui_navigation"},{"title":"Adding Tasks Manually Tutorial","href":"/tasks/adding_tasks_manually_tutorial"},{"title":"Editing Tasks And Comments","href":"/tasks/editing_tasks_and_comments"},{"title":"Manage Task Status Tutorial","href":"/tasks/manage_task_status_tutorial"},{"title":"Task Followers","href":"/tasks/task_followers"}]},{"group":"Reports","pages":[{"title":"Reports Overview","href":"/reports/basics_of_reports"},{"title":"Creating Dashboards","href":"/reports/creating_dashboards"},{"title":"Viewing Dashboards","href":"/reports/viewing_dashboards"},{"title":"Using Filters","href":"/reports/using_filters"},{"title":"Managing Pinned Dashboards","href":"/reports/managing_pinned_dashboards"},{"title":"Churn Analysis Report Guide","href":"/reports/churn_analysis_report_guide"}]},{"group":"Workflows","pages":[{"title":"Workflows Overview","href":"/workflows/workflows_overview"},{"title":"Sample Workflow Queries","href":"/workflows/sample_workflow_queries"}]},{"group":"Dashboard","pages":[{"title":"Dashboard Overview","href":"/dashboard/overview"},{"title":"My Meetings","href":"/dashboard/my_meetings"},{"title":"My Emails","href":"/dashboard/my_emails"},{"title":"Documents","href":"/dashboard/documents"},{"title":"Activity Report","href":"/dashboard/activity_report"}]},{"group":"Workbench","pages":[{"title":"Workbench Overview","tag":"Alpha","href":"/workbench/overview"},{"title":"What's new in the Workbench","href":"/workbench/whats_new"}]},{"group":"Stella AI","pages":[{"title":"Stella AI Overview","href":"/stella-ai/overview"},{"title":"Navigating Stella AI Features","href":"/stella-ai/navigating_stella_ai_features"},{"title":"Stella AI - Command Prompt Examples","href":"/stella-ai/stella_ai___command_prompt_examples"},{"title":"Using Prompts","href":"/stella-ai/using_prompts"},{"title":"Personalized Suggestions","href":"/stella-ai/personalized_suggestions"},{"title":"Advanced Features","href":"/stella-ai/advanced_features"},{"title":"Approving Stella's Actions","href":"/stella-ai/approving_actions"}]},{"group":"Campaigns","pages":[{"title":"Campaigns Overview","href":"/campaigns/overview"},{"title":"Creating Campaigns","href":"/campaigns/creating_campaigns"},{"title":"Managing Audiences","href":"/campaigns/managing_audiences"},{"title":"Email Templates","href":"/campaigns/email_templates"},{"title":"Surveys","href":"/campaigns/surveys"},{"title":"Personalization \u0026 Merge Tags","href":"/campaigns/personalization"},{"title":"Campaign Analytics","href":"/campaigns/campaign_analytics"},{"title":"Campaign Unsubscribe","href":"/campaigns/campaign_unsubscribe"}]},{"group":"Knowledge Base","pages":[{"title":"Knowledge Base Overview","href":"/knowledge-base/overview"},{"title":"Managing Datasets","href":"/knowledge-base/managing_datasets"},{"title":"Uploading Documents","href":"/knowledge-base/uploading_documents"},{"title":"Knowledge Base Citations","href":"/knowledge-base/citations"}]},{"group":"Approvals","pages":[{"title":"Approvals Overview","href":"/approvals/overview"},{"title":"Working with Approvals","href":"/approvals/working_with_approvals"},{"title":"Tracking Approvals","href":"/approvals/tracking_approvals"}]},{"group":"Portals","tag":"Alpha","pages":[{"title":"Portals Overview","href":"/portals/overview"},{"title":"How To Set Up Your Customer Portals","href":"/portals/setting_up_portals"},{"title":"Creating a Portal","href":"/portals/creating_a_portal"},{"title":"Building \u0026 Publishing","href":"/portals/building_and_publishing"},{"title":"Access \u0026 Impersonation","href":"/portals/access_and_impersonation"},{"title":"Portal SDK: Project API","href":"/portals/sdk_project_api"},{"title":"Portal MCP Server","href":"/portals/portal_mcp_server"},{"group":"API Reference","pages":[{"group":"sdk","pages":[{"title":"Get Account","deprecated":null,"version":null,"openapi":"/api/portal-sdk.openapi.json get /sdk/v1/account","href":"/api-reference/sdk/get-account"},{"title":"Patch Account","deprecated":null,"version":null,"openapi":"/api/portal-sdk.openapi.json patch /sdk/v1/account","href":"/api-reference/sdk/patch-account"},{"title":"Get Me","deprecated":null,"version":null,"openapi":"/api/portal-sdk.openapi.json get /sdk/v1/me","href":"/api-reference/sdk/get-me"},{"title":"Patch Me","deprecated":null,"version":null,"openapi":"/api/portal-sdk.openapi.json patch /sdk/v1/me","href":"/api-reference/sdk/patch-me"},{"title":"Get My Accounts","deprecated":null,"version":null,"openapi":"/api/portal-sdk.openapi.json get /sdk/v1/me/accounts","href":"/api-reference/sdk/get-my-accounts"},{"title":"Get Config","deprecated":null,"version":null,"openapi":"/api/portal-sdk.openapi.json get /sdk/v1/config/{module}","href":"/api-reference/sdk/get-config"},{"title":"Get Project","deprecated":null,"version":null,"openapi":"/api/portal-sdk.openapi.json get /sdk/v1/projects/{project_id}","href":"/api-reference/sdk/get-project"},{"title":"Patch Project","deprecated":null,"version":null,"openapi":"/api/portal-sdk.openapi.json patch /sdk/v1/projects/{project_id}","href":"/api-reference/sdk/patch-project"},{"title":"Patch Task","deprecated":null,"version":null,"openapi":"/api/portal-sdk.openapi.json patch /sdk/v1/projects/{project_id}/tasks/{task_id}","href":"/api-reference/sdk/patch-task"},{"title":"List Project Comments","deprecated":null,"version":null,"openapi":"/api/portal-sdk.openapi.json get /sdk/v1/projects/{project_id}/comments","href":"/api-reference/sdk/list-project-comments"},{"title":"Add Project Comment","deprecated":null,"version":null,"openapi":"/api/portal-sdk.openapi.json post /sdk/v1/projects/{project_id}/comments","href":"/api-reference/sdk/add-project-comment"},{"title":"List Task Comments","deprecated":null,"version":null,"openapi":"/api/portal-sdk.openapi.json get /sdk/v1/projects/{project_id}/tasks/{task_id}/comments","href":"/api-reference/sdk/list-task-comments"},{"title":"Add Task Comment","deprecated":null,"version":null,"openapi":"/api/portal-sdk.openapi.json post /sdk/v1/projects/{project_id}/tasks/{task_id}/comments","href":"/api-reference/sdk/add-task-comment"},{"title":"Edit Comment","deprecated":null,"version":null,"openapi":"/api/portal-sdk.openapi.json patch /sdk/v1/projects/{project_id}/comments/{comment_id}","href":"/api-reference/sdk/edit-comment"}]}]}]},{"group":"Statisfy SDK","pages":[{"title":"Statisfy SDK Overview","href":"/sdk/overview"},{"title":"Getting Started with the Statisfy SDK","href":"/sdk/getting_started"},{"title":"Digital Worker Chat","href":"/sdk/digital_worker_chat"},{"title":"Project Module","href":"/sdk/projects"},{"title":"Theming the Statisfy SDK","href":"/sdk/theming"},{"title":"Portal Runtime Config","href":"/sdk/portal_config"},{"title":"Statisfy SDK API Reference","href":"/sdk/api_reference"},{"title":"SDK Documentation Index","href":"/sdk/llms"}]},{"group":"Digital Workers","pages":[{"title":"Configuring a Digital Worker","href":"/digital-workers/configuring_a_worker"},{"title":"The Digital Workers Pool","href":"/digital-workers/worker_pool"},{"title":"Digital Worker Email","href":"/digital-workers/email_surface"},{"title":"Digital Worker Slack","href":"/digital-workers/slack_surface"},{"title":"Trying Out Digital Workers","href":"/digital-workers/trying_out_digital_workers"}]}]},{"tab":"Integrations","pages":[{"title":"Integrations","href":"/integrations/salesforce"}]},{"tab":"Agent Studio","pages":[{"title":"Agent Studio","href":"/agent-studio/overview"}]},{"tab":"Admin","pages":[{"title":"Admin","href":"/admin/user_management_and_roles_guide"}]},{"tab":"Resources","pages":[{"title":"Resources","href":"/resources/faq"}]},{"tab":"AI Sales","hidden":true,"pages":[{"title":"AI Sales","href":"/ai-sales/overview"}]},{"tab":"Statisfy API","hidden":true,"pages":[{"title":"Statisfy API","href":"/rest-api/overview"}]},{"tab":"AI Support","hidden":true,"pages":[{"title":"AI Support","href":"/ai-support/overview"}]},{"tab":"Changelog","pages":[{"title":"Changelog","href":"/changelog/overview"}]}]},"basePath":"","title":"Lookup Fields - Statisfy","buildId":"dpl_596ePT575z4qnAFksq1biRW97aLY","deploymentId":"dpl_596ePT575z4qnAFksq1biRW97aLY","dynamics":[],"chunks":[]}