for data table go to Google drive and create new folder such as My Daily expense and then inside the folder click new Google sheet and name the sheet as "Money app"
then add the column name as follow
ID
Date
Time
Type :Enum as income and expense
Topic
Amount
document
image
email user
go to Appsheet.com
new App and select the data table from the previous
then
go to data tab and set the data type for each column
add 3 virtual column :
sum income : SUM(Select(My expense[Amount],[Type]="Income"))
sum expense : SUM(Select(My expense[Amount],[Type]="expense"))
Total balance: [Sum income]-[Sum Expense]
on UX view
Add primary view and name "Add income-expense"
view type :table
column as follow
Date
Type
amount
Then Add another menu view "Sum income-Expense"
view type : table
group by type
sum : Amount
column as follow
Date
amount
Total balance
ไม่มีความคิดเห็น:
แสดงความคิดเห็น