{"id":38000,"date":"2022-07-25T16:53:47","date_gmt":"2021-01-20T17:57:56","guid":{"rendered":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?p=38000"},"modified":"2023-11-24T11:03:31","modified_gmt":"2023-11-24T11:03:31","slug":"how-to-filter-entries-based-on-the-payment-status","status":"publish","type":"post","link":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/","title":{"rendered":"How to filter entries based on the payment status on 123FormBuilder?"},"content":{"rendered":"\n<p>You can filter your submissions to display form entries that meet specific criteria. Advanced filters allow you to view only the information that is of interest to you.<\/p>\n\n\n\n<p>We offer many filters, and you can add detailed filter criteria to narrow the entries. There is no need to manually check entries one by one.<\/p>\n\n\n\n<p>In this article, you will learn how to find out how many completed transactions you have received with your order form.<\/p>\n\n\n\n<p>Start by clicking the <b>Results<\/b> button in the Form Editor of your <a href=\"\/\">form builder<\/a> account.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-283.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"355\" src=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-283-1024x355.png\" alt=\"Results section\" class=\"wp-image-47973\" srcset=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-283-1024x355.png 1024w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-283-300x104.png 300w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-283-768x266.png 768w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-283-1536x532.png 1536w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-283.png 1915w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Navigate to Submissions tab and click on <b>Advanced Search<\/b> to open the filter options.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-284.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"187\" src=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-284-1024x187.png\" alt=\"\" class=\"wp-image-47975\" srcset=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-284-1024x187.png 1024w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-284-300x55.png 300w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-284-768x140.png 768w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-284-1536x280.png 1536w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-284.png 1915w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Type&nbsp;<b>YES<\/b>&nbsp;or&nbsp;<b>NO&nbsp;<\/b>as the word you\u2019re looking for, and choose&nbsp;<b>Payment Completed<\/b>&nbsp;as the submissions table\u2019s column where the search should be made.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/Advancedfilter.gif\" alt=\"filter entries\" \/><\/figure>\n<\/div>\n\n\n<div class=\"warningBox\"><span style=\"font-size: 16px\"><p><b>Important Note <\/b><\/p>Make sure that the Payment integration is enabled.<\/span><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<p>That&#8217;s it. Now, only the payment transactions that meet your criteria are displayed in the table!<\/p>\n<\/div><\/div>\n\n\n\n<p>What is great with this feature is that you can also export the filtered entries to <a href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-export-to-excel-web-form-submissions\/\">Excel<\/a> or to a <a href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-export-all-of-my-submissions-to-csv\/\">CSV file<\/a>.<\/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:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/view-filter-and-sort-submissions\/\">View, filter and sort submissions<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/can-i-filter-reports-based-on-payment-status\/\">Can I filter reports based on payment status?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-export-to-excel-web-form-submissions\/\">How to export form submissions to excel?<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>You can filter your submissions to display form entries that meet specific criteria. Advanced filters allow you to view only the information that is of interest to you. We offer many filters, and you can add detailed filter criteria to narrow the entries. There is no need to manually check entries one by one. In [&hellip;]<\/p>\n","protected":false},"author":49,"featured_media":-1,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[38],"tags":[144,1040,51],"class_list":["post-38000","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-submissions","tag-filterentries","tag-payment-status-submissions","tag-submissions-2"],"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>Filter entries based on payment status | 123FormBuilder<\/title>\n<meta name=\"description\" content=\"Filter submissions to display entries that meet specific criteria. Read this article to learn how to filter entries based on the payment status.\" \/>\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\/how-to-filter-entries-based-on-the-payment-status\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to filter entries based on the payment status on 123FormBuilder?\" \/>\n<meta property=\"og:description\" content=\"Filter submissions to display entries that meet specific criteria. Read this article to learn how to filter entries based on the payment status.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/\" \/>\n<meta property=\"og:site_name\" content=\"123FormBuilder Knowledge Base\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-20T17:57:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-24T11:03:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-283-1024x355.png\" \/>\n<meta name=\"author\" content=\"Julia\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julia\" \/>\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":"Filter entries based on payment status | 123FormBuilder","description":"Filter submissions to display entries that meet specific criteria. Read this article to learn how to filter entries based on the payment status.","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\/how-to-filter-entries-based-on-the-payment-status\/","og_locale":"en_US","og_type":"article","og_title":"How to filter entries based on the payment status on 123FormBuilder?","og_description":"Filter submissions to display entries that meet specific criteria. Read this article to learn how to filter entries based on the payment status.","og_url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/","og_site_name":"123FormBuilder Knowledge Base","article_published_time":"2021-01-20T17:57:56+00:00","article_modified_time":"2023-11-24T11:03:31+00:00","og_image":[{"url":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-283-1024x355.png","type":"","width":"","height":""}],"author":"Julia","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Julia","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/#article","isPartOf":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/"},"author":{"name":"Julia","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/cc469207f9fad9e280a743a5dc96a843"},"headline":"How to filter entries based on the payment status on 123FormBuilder?","datePublished":"2021-01-20T17:57:56+00:00","dateModified":"2023-11-24T11:03:31+00:00","mainEntityOfPage":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/"},"wordCount":219,"commentCount":0,"image":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-283-1024x355.png","keywords":["filterentries","payment status submissions","submissions"],"articleSection":["Submissions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/","url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/","name":"Filter entries based on payment status | 123FormBuilder","isPartOf":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/#primaryimage"},"image":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-283-1024x355.png","datePublished":"2021-01-20T17:57:56+00:00","dateModified":"2023-11-24T11:03:31+00:00","author":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/cc469207f9fad9e280a743a5dc96a843"},"description":"Filter submissions to display entries that meet specific criteria. Read this article to learn how to filter entries based on the payment status.","breadcrumb":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/#primaryimage","url":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-283-1024x355.png","contentUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-283-1024x355.png"},{"@type":"BreadcrumbList","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/how-to-filter-entries-based-on-the-payment-status\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/"},{"@type":"ListItem","position":2,"name":"How to filter entries based on the payment status on 123FormBuilder?"}]},{"@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\/cc469207f9fad9e280a743a5dc96a843","name":"Julia","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1b07bbd30c86170f8eb191468f69aaeab7b6cfddcd35ceaf4099ab76a5dccb06?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2FJulia%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1b07bbd30c86170f8eb191468f69aaeab7b6cfddcd35ceaf4099ab76a5dccb06?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2FJulia%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1b07bbd30c86170f8eb191468f69aaeab7b6cfddcd35ceaf4099ab76a5dccb06?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2FJulia%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","caption":"Julia"},"url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/author\/julia-unguras123formbuilder-com\/"}]}},"_links":{"self":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/38000","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\/49"}],"replies":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/comments?post=38000"}],"version-history":[{"count":27,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/38000\/revisions"}],"predecessor-version":[{"id":47976,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/38000\/revisions\/47976"}],"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=38000"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/categories?post=38000"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/tags?post=38000"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}