LinkedIn
Twitter
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:
- Can I have 2 Tabs on my App, one for Expenses and one for Income?
- Can the EXPENSES tab have it's own form ("+" thing) which enters data into the EXPENSES sheet only
- Can the INCOME tab have it's own form ("+" thing) which enters data into the INCOME sheet only
- OR, should I only be working in one sheet, and thus, have only one form ("+" thing) for entry?
- If so, then how do I differentiate between income and expense (debit/credit)? (I did have a drop-down saying choosing Payment / Receipt, however, that was just text and didn't calculate a debit and credit.
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
