I have created an app to calculate users’ paychecks. This includes a total of six different sheets. One for pay type (there are so many pay categories like night shift, lead pay, International pay, Spanish qualified, etc.). A second for Pre Tax Deductions that may be unique to the user (401k, medical, dental, vision, etc). A third for Post Tax Deductions (Stock purchase, 401k Loan, STD, LTD, etc). A fourth fourth for Taxes (declare dependents and additional tax withholdings), a fifth for the first pay check of the month, and a sixth for the the second pay check of the month (both paychecks are based on different pay types).
The last two sheets contain rows that are not viewable in the app because they contain formulas to calculate federal tax withholdings. Basically all the sheets link together and rely on each other to communicate with one another to produce an accurate income estimate.
I noticed that when I update my app with my pay information, it updates the Google Sheets spreadsheet as well. The problem is that if I share this app with other users, they will see my data and if there are multiple users logged in at the same time, they will change each others’ data.
I want each user to own their own information, so I set the the tables to non shareable, but this caused them to stop communicating with one another. It completely broke the calculations. For example, if I change the number of hours worked in the Pay Type tab, it doesn’t change it in the spreadsheet, which is good. However, it also doesn’t produce an accurate 1st or 2nd pay check tab…like the formulas no longer work.
Is there a way to deploy the app, but to create an entire file with the 6 sheets for each user? Or to just keep all the user data private, but for the formulas to work independently of other users? I am quite impressed with this app and it works perfectly for just me, but I would love to share it with my colleagues!