{"id":2974,"date":"2022-07-25T16:53:32","date_gmt":"2013-02-28T08:00:13","guid":{"rendered":"http:\/\/www.123formbuilder.com\/docs\/?p=2974"},"modified":"2024-05-09T10:55:59","modified_gmt":"2024-05-09T10:55:59","slug":"how-to-prevent-duplicate-values-for-a-field","status":"publish","type":"post","link":"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/","title":{"rendered":"How to prevent duplicate values for a form field on 123FormBuilder?"},"content":{"rendered":"\n<p>If you want to make sure that respondents&#8217; input is unique and you don\u2019t end up with duplicated info between submissions, you can enable <b>Don\u2019t allow duplicate values<\/b>. Select the field you are interested in applying this validation to and in the right-side panel under <b>Validation<\/b>, you can find the <b>Don\u2019t allow duplicate values option.<\/b><\/p>\n\n\n\n<p>Only the following fields have this option:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Short answer<\/li>\n\n\n\n<li>First\/Last name<\/li>\n\n\n\n<li>Email address<\/li>\n\n\n\n<li>Number<\/li>\n\n\n\n<li>Formula<\/li>\n\n\n\n<li>Link<\/li>\n<\/ul>\n\n\n\n<p><b>Use case:<\/b> the most relevant use case is for the <b>Email address<\/b> field. There are cases in which you might want to have unique email addresses and by enabling this option, you won\u2019t end up with duplicate input. If one email address has been used once, it can\u2019t be used again. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-21-at-10.16.28.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"487\" src=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-21-at-10.16.28-1024x487.png\" alt=\"Duplicate values\" class=\"wp-image-47268\" style=\"aspect-ratio:2.102669404517454;width:840px;height:auto\" srcset=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-21-at-10.16.28-1024x487.png 1024w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-21-at-10.16.28-300x143.png 300w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-21-at-10.16.28-768x365.png 768w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-21-at-10.16.28-1536x731.png 1536w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-21-at-10.16.28.png 1906w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>When respondents provide input that already exists in your form submissions, they get the following field validation error:<\/p>\n\n\n<div class=\"wp-block-image is-resized\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/duplicatevalue.png\"><img loading=\"lazy\" decoding=\"async\" width=\"619\" height=\"174\" src=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/duplicatevalue.png\" alt=\"Duplicate value error\" class=\"wp-image-40626\" srcset=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/duplicatevalue.png 619w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2021\/09\/duplicatevalue-300x84.png 300w\" sizes=\"auto, (max-width: 619px) 100vw, 619px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity is-style-wide\" \/>\n\n\n\n<p><b>Related articles<\/b><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.123formbuilder.com\/docs\/how-can-i-request-matching-input-in-two-different-fields\/\">How can I request matching input in two different fields?<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>If you want to make sure that respondents&#8217; input is unique and you don\u2019t end up with duplicated info between submissions, you can enable Don\u2019t allow duplicate values. Select the field you are interested in applying this validation to and in the right-side panel under Validation, you can find the Don\u2019t allow duplicate values option. [&hellip;]<\/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":[35],"tags":[62,522,520,519,521],"class_list":["post-2974","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formeditor","tag-aaa_formeditor","tag-dont-allow-duplicate-values","tag-email","tag-email-address","tag-prevent-duplicate-values"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Help: Prevent duplicate values in fields | 123FormBuilder<\/title>\n<meta name=\"description\" content=\"Learn how to prevent duplicate values for a form field by following our guide, here on the 123FormBuilder Knowledge Base platform.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to prevent duplicate values for a form field on 123FormBuilder?\" \/>\n<meta property=\"og:description\" content=\"Learn how to prevent duplicate values for a form field by following our guide, here on the 123FormBuilder Knowledge Base platform.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/\" \/>\n<meta property=\"og:site_name\" content=\"123FormBuilder Knowledge Base\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-28T08:00:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-09T10:55:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-21-at-10.16.28-1024x487.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=\"2 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Help: Prevent duplicate values in fields | 123FormBuilder","description":"Learn how to prevent duplicate values for a form field by following our guide, here on the 123FormBuilder Knowledge Base platform.","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:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/","og_locale":"en_US","og_type":"article","og_title":"How to prevent duplicate values for a form field on 123FormBuilder?","og_description":"Learn how to prevent duplicate values for a form field by following our guide, here on the 123FormBuilder Knowledge Base platform.","og_url":"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/","og_site_name":"123FormBuilder Knowledge Base","article_published_time":"2013-02-28T08:00:13+00:00","article_modified_time":"2024-05-09T10:55:59+00:00","og_image":[{"url":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-21-at-10.16.28-1024x487.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/#article","isPartOf":{"@id":"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/"},"author":{"name":"admin","@id":"https:\/\/www.123formbuilder.com\/docs\/#\/schema\/person\/ac765b93d6689ec0f4ee6f6e040d66ea"},"headline":"How to prevent duplicate values for a form field on 123FormBuilder?","datePublished":"2013-02-28T08:00:13+00:00","dateModified":"2024-05-09T10:55:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/"},"wordCount":169,"commentCount":5,"image":{"@id":"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-21-at-10.16.28-1024x487.png","keywords":["aaa_formeditor","don&#039;t allow duplicate values","email","email address","prevent duplicate values"],"articleSection":["Form Editor"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/","url":"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/","name":"Help: Prevent duplicate values in fields | 123FormBuilder","isPartOf":{"@id":"https:\/\/www.123formbuilder.com\/docs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/#primaryimage"},"image":{"@id":"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-21-at-10.16.28-1024x487.png","datePublished":"2013-02-28T08:00:13+00:00","dateModified":"2024-05-09T10:55:59+00:00","author":{"@id":"https:\/\/www.123formbuilder.com\/docs\/#\/schema\/person\/ac765b93d6689ec0f4ee6f6e040d66ea"},"description":"Learn how to prevent duplicate values for a form field by following our guide, here on the 123FormBuilder Knowledge Base platform.","breadcrumb":{"@id":"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/#primaryimage","url":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-21-at-10.16.28-1024x487.png","contentUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/Screenshot-2023-11-21-at-10.16.28-1024x487.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.123formbuilder.com\/docs\/how-to-prevent-duplicate-values-for-a-field\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.123formbuilder.com\/docs\/"},{"@type":"ListItem","position":2,"name":"How to prevent duplicate values for a form field on 123FormBuilder?"}]},{"@type":"WebSite","@id":"https:\/\/www.123formbuilder.com\/docs\/#website","url":"https:\/\/www.123formbuilder.com\/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:\/\/www.123formbuilder.com\/docs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.123formbuilder.com\/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:\/\/www.123formbuilder.com\/docs\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/posts\/2974","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/comments?post=2974"}],"version-history":[{"count":22,"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/posts\/2974\/revisions"}],"predecessor-version":[{"id":48773,"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/posts\/2974\/revisions\/48773"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/media?parent=2974"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/categories?post=2974"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/tags?post=2974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}