I would appreciate some help please
I am working on an app and am having difficulty in taking individual cell information from one sheet “APP: Sales” and updating a row and specific cells in another sheet based upon the users email address.
But am struggling to get my head around the app script code to manipulate the data in arrays ?
The data I need from the “APP: Sales” sheet is the ‘Item SKU#’ and the ‘Paid at’ cells
these need to match the email address with the email address in the “AuthUsers” sheet
and then update the columns for each of the modules purchased for that user.
This update needs to happen everytime a purchase occurs.
In my example sheet I have included an exmaple of the desired output.
My example spreadsheet is accessible via this link