Search Thing with Field Count to Display Group

Need help
1

Thing has Fields A, B, C

I want to Display a Group, when Field A = X, and if the count of Field C >= 2

How do I write this conditional logic?

2

What do you mean by “count of Field C”? What are you counting exactly - the number of instances where field C has a value? Or are you after records where the value of field C >=2 (AND A is X)?

3

Good question… I was not clear enough.

The number of instances where field C has the same value, AND A is X, like you stated. @louisadekoya

4

Sorry, so I’m clear, do you mean records where A = X and C>=2 or do you mean where A = X and value of C is the same as the value of C for at least one other record?

The latter would be much trickier of course. I can’t immediately think how but it’s an interesting one.

5

Well i’m bummed I have you stumped :slight_smile: Yes, the latter.

How about this…

You have a thing - Test_Results

You have multiple fields (Test, Test Taker, Test Group):

How could I identify when the same Test Group has taken at least two different Tests.

6

I don’t have Bubble in front of me, but I’m thinking :filtered might help here.

7

Okay, it’s somewhat elaborate and inelegant but this kind of works: https://bubble.io/page?type=page&name=find_duplicate&id=louisforum&tab=tabs-1

Edit I have simplified it considerably

8

Thanks @louisadekoya I ended up figuring it out with filtering :slight_smile:

1 Like
9

This topic was automatically closed after 70 days. New replies are no longer allowed.