How to write items with a particular key value from Firebase Realtime database

Question

User{
Aby12fvjg7ngf89jtd4Rf6ubu6dc{
Referralcode : afchdeww12,
Refercode : Fhb0VP7xje97,
referno : 0,
}
}

Am trying to get how many users "referralcode" match any users "refercode", For example, this first user "refercode:" is "Fhb0VP7xje97" I want to know how many users from the whole database has this referral code in their "referralcode" value, and save the number to the "referno" value, so that the number of people referred by users would be visible to the user,

Answer 1

I don't think there's need to update the referno everytime.In this case it's a redundant key. You could just use a filter function to find how many users have "Fhb0VP7xje97" as their refercode

Example:
let referrals = users.filter(user => user.Refercode === "Fhb0VP7xje97")

console.log(referrals.length);

Answer 2

Let me try this

Answer 3

Would it work regardless of the user id

Answer 4

Yes it should