Help counting number of fields with certain text!

Need help
1

Im building an airbnb type app. On the home page I want to list how many properties there are in each province dynamically.

The way my db is setup is as such:
Data Type: Properties
Field for properties: PropProvince as text

Is my db set up in such a way where I could count how many occurrences of each province there are? For instance, if there are 5 properties that state they are in Quebec, could the dynamic text on the home page reflect that and say “5 homes”? Or do i need to totally restructure my db?

Ive been stuck on this for a while. Any help is appreciated!

Thanks in advance!

2

I would restructure data a bit. Make province its own data type.
And in Properties → field with PropProvince as a Province type.

Do a search for Properties: constraint PropProvince = A Province : count

Hope this helps!

3 Likes
3

Depends how is your home page designed. Is there a RG of all provinces or how do you list them?

4

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