I use a Form the user needs to fill out to state his location. out of that I get the owner id as well. I send this data to googlesheets via zapier and there I use a pivot table to sum up all informations and points and send this to my PunkteKonto collection thru Zapier via Jason backend function. Whenever a new column is created or modfied in googlesheets, Zapier post the data to the wix database.
I thought about solving this in googlesheets directly, but I use a pivot table there to sum up the Users points. So its only one row for the same CopyOwner & Location.