Hi, I'm very new to Appsheet and coding etc. A total beginner. And have been setting up the app watching tutorials.
I want to make a basic Income & Expenses App for me and my wife to share and enter.
I've set the App, and it works like a charm for my expenses, with drop-down for categories, etc. (Images attached).
My Google Sheets has a sheet for Expenses and another sheet for income. (And I have a separate sheet that calculates income - expenses to show my balance)
The App is only taking the data from the "Expense" sheet (even though I've added the income Table).
However, I need to figure out a solution for the App to track/enter/calculate my income.
The App, only lets me input (through the "+" sign form) only into the "Expense" sheet.
My question:
Would really appreciate your help, and hope whatever is suggested, is something simple enough for me to manage. (I have tried looking for similar app templates, but they don't seem to be as simple as the one I want.) Even a link to a Youtube tutorial would be helpful.
Thank you
Welcome to the community!
You have to manually add every desired sheet in your Google Sheets workbook as a table in your app. To do this, in the app's editor, go to Data, and in the top you'll find a big "+" sign with "New Table" caption. Click on this, choose "Sheets on Google Drive", browse to your Google Sheet, choose it, and you'll be able select any sheet inside that is not already added to your app.
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |