# Count For Products Approved From Products Submitted **URL:** \ **Category:** Need help\ **Created:** [February 14, 2019, 8:27pm UTC](https://forum.bubble.io/t/count-for-products-approved-from-products-submitted/49557 "2019-02-14T20:27:46Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![i.naseem.in24](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/i.naseem.in24/32/36693_2.png) [@i.naseem.in24](https://forum.bubble.io/u/i.naseem.in24)\ **Post date:** [February 14, 2019, 8:27pm UTC](https://forum.bubble.io/t/count-for-products-approved-from-products-submitted/49557/1 "2019-02-14T20:27:47Z")
Hey BCommunity Can anyone help me to rectify the following. 1 Products are submitted and I have a count for them 2. Products needs approving and have a database field under Products \> Product\_Approved = YES / NO How can i get it to do a count from the following seeing as YES / No is not directly a number, Can anyone help where I am going wrong? ![image](https://us1.discourse-cdn.com/bubble/original/3X/4/6/468058a74c7e1eeb3db7dee91a5b7a10f1c7f328.png) ![image](https://us1.discourse-cdn.com/bubble/original/3X/b/a/bae61e0335edfaf85e4a220199b1398e6d7d4b35.png) ![image](https://us1.discourse-cdn.com/bubble/original/3X/1/4/1450cc1ce08ade0fb51d9daf2ae882c4190a2497.png) ---
**Author:** ![andrewgassen](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/andrewgassen/32/44248_2.png) [@andrewgassen](https://forum.bubble.io/u/andrewgassen)\ **Post date:** [February 14, 2019, 9:33pm UTC](https://forum.bubble.io/t/count-for-products-approved-from-products-submitted/49557/2 "2019-02-14T21:33:15Z")
I would typically do something like…“Do a Search for Products” where User = Parent Group’s User and Product\_Approved = Yes. Then, after the “Do a Search for Products” in the expression composer, click the “More” button and select “Count” ---
**Author:** ![i.naseem.in24](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/i.naseem.in24/32/36693_2.png) [@i.naseem.in24](https://forum.bubble.io/u/i.naseem.in24)\ **Post date:** [February 15, 2019, 2:05pm UTC](https://forum.bubble.io/t/count-for-products-approved-from-products-submitted/49557/3 "2019-02-15T14:05:51Z")
Thanks @andrewgassen ill give that a whirl ---
**Author:** ![i.naseem.in24](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/i.naseem.in24/32/36693_2.png) [@i.naseem.in24](https://forum.bubble.io/u/i.naseem.in24)\ **Post date:** [February 15, 2019, 3:47pm UTC](https://forum.bubble.io/t/count-for-products-approved-from-products-submitted/49557/4 "2019-02-15T15:47:41Z")
Hey @andrewgassen Tried this, but getting the response back as yes/no In My Database Product has a field Product Approved Yes No ![image](https://us1.discourse-cdn.com/bubble/original/3X/9/e/9e0d6447a0c811b448d8f3df5272ed309345b102.png) For Products Submitted it works it seems ![image](https://us1.discourse-cdn.com/bubble/original/3X/b/1/b162d5401fbe8e882cb5b56ae51ff0a6b4562d7c.png) ![image](https://us1.discourse-cdn.com/bubble/original/3X/9/5/95de14db4a659d291a791de25b88d73b26be6526.png) For Products Approved I tried ![image](https://us1.discourse-cdn.com/bubble/original/3X/f/3/f3f4dbcd12491dbf9f9f2c31d24ee77a6ba5da42.png) ![image](https://us1.discourse-cdn.com/bubble/original/3X/5/f/5f4480421815674eba75a0eeb415a6c24dd1dde3.png) ![image](https://us1.discourse-cdn.com/bubble/original/3X/8/6/86481ce88f2f6135048a34917190980e9b130311.png) what do you think mate ---
**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\ **Post date:** [April 25, 2019, 8:27pm UTC](https://forum.bubble.io/t/count-for-products-approved-from-products-submitted/49557/5 "2019-04-25T20:27:48Z")
This topic was automatically closed after 70 days. New replies are no longer allowed.