Filter by Month

Get Help
1

Is there a way to filter by month or get month from date? For example I have a list of transactions with dates but I want to be able to see the monthly total for month selected.

2

Unfortunately there’s not a straightforward way to do this. But you could create a collection for Months, which would have properties for start date and end date. You could have a dropdown where users pick a months, and then filter your listed based on the selected month’s start date and end date.

3

Hi Guys,

I bumped into the same problem and came with this solution that works fine “in the Editor” to return 12 Month Names or number with a lighter config not using Month-start-date/Month-end-date…plus it works for all years to come, so No-code modif needed for next years… :yum:

Maybe @Ben can run test on REAL devices as well as test for other “countries Date time format” (Asian and else…)

So the idea was to TRY to locate the Month String in the Date value returned :
Using “Updates filters” and a field to convert this Date Picker value to a TEXT one, this can be achieved in the following way…
Results returned is the Month Name (Month Number)

  • It would be nice if ADALO could offer to use the DATE PICKER “directly” for Filters (not possible at this moment)
    *and
  • if they could make sure the String format will never change ie “-06-” “/06/”
    …for this would break this work arround.

*See pics : test made with “5 of June” and “6 of May” to make sure there is no confusion

Capture d’écran de 2020-06-29 21-07-04
Capture d’écran de 2020-06-29 21-07-04437×557 35 KB

Capture d’écran de 2020-06-29 21-06-31
Capture d’écran de 2020-06-29 21-06-31425×528 33.9 KB

Capture d’écran de 2020-06-29 21-07-22
Capture d’écran de 2020-06-29 21-07-22821×662 46.8 KB

:hugs: Loving Adalo each days more…

1 Like
4

I found a solution to this problem a little simpler

Screenshot_22
Screenshot_221289Ă—504 49.6 KB

5

Olá @Rodrigo tudo bem! Você Brasileiro?
vocĂŞ poderia passar mais detalhes dessas funcionalidades?
deu pra gerar fatura de vários meses? tipo 12 meses, 20 meses, 30 meses…!?

Estou quebrando a cabeça também para saber a data final de um contrato.
Exemplo: contrato inicia em 10/07/2022 e o prazo é de 26 meses. O Adalo não tem essa função de multiplicar meses.

6

Olá, sim sou do Brasil. Na verdade não criei várias faturas de uma vez, criei uma a uma. Isso te ajudaria?

1 Like
7

@Rodrigo você poderia passar como fez o lançamento de cada fatura?
Desde já, obrigado.