Expences_accounter

Installation instructions

• Create google sheet
• Create a tab 'Categories'
• Populate it with your expences categories
• Go to Extensions -> Apps script
• Create files Code.gs and index.html
• Paste contents of corresponding files from this project
• Click Deploy -> New deployment
• Select type Web app
• Set:
  • Execute as: Me
  • Who can access: Only myself
• Deploy the app and authorize
• Use provided URL
• Confirm access of this project to your google drive:

In some cases it takes time for the script to start working properly: https://support.google.com/docs/thread/99474963

TODO

• Use case 'a category is added':
  • insert row with new category
  • add total formula for this row
  • assure all other formulas consider new row
  • redraw backgrounds for categories rows
• Use case a category is removed