{"id":13418,"date":"2014-11-18T14:19:21","date_gmt":"2014-11-18T14:19:21","guid":{"rendered":"http:\/\/www.123formbuilder.com\/docs\/?p=13418"},"modified":"2022-11-01T10:57:34","modified_gmt":"2022-11-01T10:57:34","slug":"can-i-filter-reports-based-on-payment-status","status":"publish","type":"post","link":"https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/","title":{"rendered":"Can I filter form reports based on payment status?"},"content":{"rendered":"<div class=\"defaultText\">\n<div class=\"text justify\">\n<p>Yes, you can filter reports based on payment status. In the <b>Reports<\/b> section of your form, click to edit or create a report. Next, click on <b>Report Filters<\/b> (on top) and hit <b>Add Filter<\/b>.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/addfilter.png\" alt=\"report filter\" width=\"335\" height=\"182\"><\/p>\n<p>In the lightbox, select <em>Payment Status<\/em> in the first dropdown and one of the available options in the next.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/filterchoice.png\" alt=\"report filter\" width=\"535\" height=\"182\"><\/p>\n<p>Use the <b>Is invoiced<\/b> option only if you have FreshBooks integrated on your online order form.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/reportfilterpayment.png\" alt=\"report filter\" width=\"635\" height=\"182\"><\/p>\n<p>For example: If you <em>Include only submissions where&nbsp;<\/em><b>Payment Status<\/b> is completed, submissions that haven&#8217;t completed payment will not be included in the report.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Yes, you can filter reports based on payment status. In the Reports section of your form, click to edit or create a report. Next, click on Report Filters (on top) and hit Add Filter. In the lightbox, select Payment Status in the first dropdown and one of the available options in the next. Use the [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":-1,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[39],"tags":[1086,1084],"class_list":["post-13418","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-reports","tag-filter-form-reports-based-on-payment-status","tag-filter-reports"],"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 reports based on payment status? |123FormBuilder Help<\/title>\n<meta name=\"description\" content=\"With 123FormBuilder you can filter reports based on payment status. This will exclude submissions that haven&#039;t completed payment from your custom report.\" \/>\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\/can-i-filter-reports-based-on-payment-status\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Can I filter form reports based on payment status?\" \/>\n<meta property=\"og:description\" content=\"With 123FormBuilder you can filter reports based on payment status. This will exclude submissions that haven&#039;t completed payment from your custom report.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/\" \/>\n<meta property=\"og:site_name\" content=\"123FormBuilder Knowledge Base\" \/>\n<meta property=\"article:published_time\" content=\"2014-11-18T14:19:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-01T10:57:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/addfilter.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\" \/>\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 reports based on payment status? |123FormBuilder Help","description":"With 123FormBuilder you can filter reports based on payment status. This will exclude submissions that haven't completed payment from your custom report.","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\/can-i-filter-reports-based-on-payment-status\/","og_locale":"en_US","og_type":"article","og_title":"Can I filter form reports based on payment status?","og_description":"With 123FormBuilder you can filter reports based on payment status. This will exclude submissions that haven't completed payment from your custom report.","og_url":"https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/","og_site_name":"123FormBuilder Knowledge Base","article_published_time":"2014-11-18T14:19:21+00:00","article_modified_time":"2022-11-01T10:57:34+00:00","og_image":[{"url":"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/addfilter.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/#article","isPartOf":{"@id":"https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/"},"author":{"name":"","@id":""},"headline":"Can I filter form reports based on payment status?","datePublished":"2014-11-18T14:19:21+00:00","dateModified":"2022-11-01T10:57:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/"},"wordCount":104,"commentCount":0,"image":{"@id":"https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/#primaryimage"},"thumbnailUrl":"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/addfilter.png","keywords":["filter form reports based on payment status","filter reports"],"articleSection":["Reports"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/","url":"https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/","name":"Filter reports based on payment status? |123FormBuilder Help","isPartOf":{"@id":"https:\/\/www.123formbuilder.com\/docs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/#primaryimage"},"image":{"@id":"https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/#primaryimage"},"thumbnailUrl":"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/addfilter.png","datePublished":"2014-11-18T14:19:21+00:00","dateModified":"2022-11-01T10:57:34+00:00","author":{"@id":""},"description":"With 123FormBuilder you can filter reports based on payment status. This will exclude submissions that haven't completed payment from your custom report.","breadcrumb":{"@id":"https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/#primaryimage","url":"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/addfilter.png","contentUrl":"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/addfilter.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.123formbuilder.com\/docs\/can-i-filter-reports-based-on-payment-status\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.123formbuilder.com\/docs\/"},{"@type":"ListItem","position":2,"name":"Can I filter form reports based on payment status?"}]},{"@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":"","url":"https:\/\/www.123formbuilder.com\/docs\/author\/"}]}},"_links":{"self":[{"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/posts\/13418","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\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/comments?post=13418"}],"version-history":[{"count":11,"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/posts\/13418\/revisions"}],"predecessor-version":[{"id":45210,"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/posts\/13418\/revisions\/45210"}],"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=13418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/categories?post=13418"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.123formbuilder.com\/docs\/wp-json\/wp\/v2\/tags?post=13418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}