Looking for help with payment list

[Krawol]

I'm trying to make app for payment list. Could anyone help me with an idea how to solve something like this one:

When adding records I would need such items:

PAYMENT LIST Tables:

1. Month

2. Description

3. Amount

On first page I would like to have list of months with summary of all amounts.

When I click on specific month I would like to see all added payments with description and amount.

Would be really greatful for any advices.

[Marc_Dillon]

https://help.appsheet.com/en/articles/2357307-sum

https://help.appsheet.com/en/articles/2357314-select

[Krawol]

Thanks, that seems helpful. 

Could you give me another hint?

Is it okay to make month in database as date with selecting exact date if I want to select whole months? Which way would be easier? Should I make list with possibilites as Jan, Feb, ect?

Thanks in advance

[Marc_Dillon]

Simple numbers 1 through 12 would be easiest, because you'd be comparing to MONTH([date]).

[Tommy62]

Hier mal ein kurzes Video dazu: So zeigen Sie den Monat einfach in Ihrer App an 

[WillowMobileSys]

An Interactive Dashboard, I think would work well.  You can setup a view such that clicking on the Month/Year will filter a second view with rows matching that same Month/Year.

There are several tutorials on Youtube.  Just search for AppSheet Interactive Dashboard.

Interactive Dashboard App Example