I have 2 collections for this:
Users
Commissions
Users can have multiple commissions, commissions belong to one user.
Commissions has 4 properties: Commission name (text), amount (number), paid (true/false), and user relationship (as stated above).
I want to be able to have a list of users where the commissions that are “Unpaid” (where paid = false) with a button that says “Pay Now”. When this “Pay Now” button is clicked, it checks the paid box as true for all of the unpaid commissions.
So the pay now button would grab all commissions belonging to user where paid = false and switch them to paid = true.
Is this possible?