# Count Fields where "Yes"

**URL:** <https://forum.bubble.io/t/count-fields-where-yes/285320>\
**Category:** App Organization\
**Created:** [September 25, 2023, 9:36pm UTC](https://forum.bubble.io/t/count-fields-where-yes/285320 "2023-09-25T21:36:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dduncan](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/dduncan/32/148426_2.png) [@dduncan](https://forum.bubble.io/u/dduncan)\
**Post date:** [September 25, 2023, 9:36pm UTC](https://forum.bubble.io/t/count-fields-where-yes/285320/1 "2023-09-25T21:36:05Z")

</div>

Hey all,  
Looking for some help:  
I have a set of 12 fields on a ‘thing’ (can we please start calling them “Objects” or “Tables”?!?)  
all 12 fields are “yes/no” types. In an expression I want to count how many of them are “Yes”

Anyone have any brilliant ideas? Thanks!

---

<div class="post-metadata">

**Author:** ![adamhholmes](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/adamhholmes/32/100510_2.png) [@adamhholmes](https://forum.bubble.io/u/adamhholmes)\
**Post date:** [September 25, 2023, 9:54pm UTC](https://forum.bubble.io/t/count-fields-where-yes/285320/2 "2023-09-25T21:54:53Z")

</div>

> [@dduncan](#):
>
> can we please start calling them “Objects” or “Tables”?!?

You’re free to call them whatever you like…

…but thinking of Bubble ‘things’ as being synonymous with database ‘Tables’ is incorrect (in fact, they’re _certainly_ NOT Tables… I’ve heard people suggest they be called ‘Rows’, but even that is missing some crucial understanding of what Things actually are in Bubble terms.)…

Objects _might_ be a better choice of word, but in Bubble ‘Things’ are _not_ synonymous with Objects either… they are a specific _type_ of object, and there really isn’t a more appropriate or succinct word in the English language to describe them than ‘Things’…

But…to answer your question…

> I have a set of 12 fields on a ‘thing’ (can we please start calling them “Objects” or “Tables”?!?)  
> all 12 fields are “yes/no” types. In an expression I want to count how many of them are “Yes”

Seeing as you’re using 12 individual fields for this, you’ll have to count them individually…

So, I would suggest using a series of Boolean statements formatted as a Number (1 for true, 0 for false)…

e.g.

`Field 1 is yes: formatted as number [true=1, false=0] + field 2 is yes: formatted as number [true=1, false=0] + Field 3 is yes: formatted as number [true=1, false=0]`…

and so on, for all 12 fields.

That will give you the count of the Yes values.

---

<div class="post-metadata">

**Author:** ![dduncan](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/dduncan/32/148426_2.png) [@dduncan](https://forum.bubble.io/u/dduncan)\
**Post date:** [September 25, 2023, 10:58pm UTC](https://forum.bubble.io/t/count-fields-where-yes/285320/3 "2023-09-25T22:58:52Z")

</div>

Thanks for the answer, and sending me down a rabbit hole learning about object-oriented and relational data (objects vs tables) 🙂
