Update a value in Table B when row is added to Table A

[tahafanaswala]

I'm making a dummy stock trading app. Every week, I distribute dividends to users, and I record how many dividends each user got from each stock they own in a table called Dividends (Table B). When I create a record in Dividends, I want to update the user's cash reserves, which is recorded in the Users table. Both tables are linked together via an email column. How could I implement this functionality in Appsheet? Note that I am using an Appsheet database, so I cannot use Appscript.