Dataset filter question

Ask the community
, ,
1

I’ve a database collection named Regular Member. The total number of members is 67.
It consisted of New Members (16) and Renewal Members (60). When I filtered the dataset
to New Members, my total is still 67 instead of 16. I’m not good with code and any
help will be greatly appreciated. Here is my code shown below

wixData.query(“paymentForm01”)
.count()
.then( (num) => {
let TotalRegularMembers= num;

2

First you should provide the database fields

3

Not sure what you meant?

4

I was thinking how you categorize members as ’ New Members’ and ‘Renewal Members’ ???

For example-> My database is ’ paymentForm01’.
In my database I have the field called ’ membertype ’
The field stores which type of member they are respectively.

So, in my page, I want to get the new Members only…

wixData.query("paymentForm01")
.eq("memberType", "New Member")
.find()
.then((res) => {
 let resultCount = res.totalCount;
});

For this I asked you about your database structure…