How to display data with condition?

[syahdan]

hi there, i want to ask for my problem

how to display all user with condition due dates expired?

this my application

for this apps, i want to display many users who have not paid dues fot this month

when a user makes a transaction, all transactions will be stored in the following table

this table for user management

Is it possible if I display all users who have not made a transaction this month?

[Aurelien]

Hi @syahdan 

You may benefit from using a slice, and create a view based on this slice.

Your slice will have these settings:

Source table : Users

Row filter condition:

ISBLANK(
  FILTER("Transaction",
    AND(
      [User]=[_THISROW],
      EOMONTH([dueDate],0)=EOMONTH(TODAY(),0)
    )
  )
)

For reference:

https://help.appsheet.com/en/articles/895302-slices-the-essentials

https://help.appsheet.com/en/articles/2357308-filter

[syahdan]

display error like this

[TeeSee1]

EOMONTH( when , offset-months ) requires an offset value. 

[Aurelien]

That's correct, my mistake. 

Thank you @TeeSee1 for spotting this !

I will correct this in my suggestion.

@syahdan use

 EOMONTH([Transaction],0)=EOMONTH(TODAY(),0) 

instead in the second part of the FILTER() expression.

Edit:

1) I corrected my previous suggestion in order to add the ,0 part in the EOMONTH() expression. @syahdan you can use it as it is now.

2) @syahdan you don't need to add one more MONTH() expression as it won't match EOMONTH expected input type.

For reference:

https://help.appsheet.com/en/articles/2430932-eomonth

[syahdan]

like this?

[Aurelien]

yes. But I don't know which column is correct in your case 😉

Just, remember [RIWAYATPEMBAYARAN] should be a Date or DateTime type, as said in the documentation.

[syahdan]

I just want to show which users haven't made a transaction this month

this my table "riwayatpembayaran"

and this table datauser

[Aurelien]

I got that.

You need to add a Date or DateTime column with every transaction.

I didn't notice you don't have it yet. If you don't have any date or datetime column, how would you expect to know which month it is ?

[syahdan]

ok i will add. because I think I can manage it with the moon on this day

[syahdan]

like this?

[Aurelien]

Yes. It could be anything, the important part is the Initial value expression.

If type is DateTime ==> NOW()

if type is Date ==> TODAY()

For reference:

https://help.appsheet.com/en/articles/961346-date-and-time-expressions

[syahdan]

ok done

what do i need to do next

[Aurelien]

...get back to my initial suggestion 🙂

[syahdan]

like this in user slice?

[Aurelien]

yes

[syahdan]

solved with formula

FILTER("readonlyuser",AND(
IF(ISBLANK(ANY(FILTER[BULAN])),FALSE,
[FILTER]=ANY(FILTER[BULAN])),

IF(ISBLANK(ANY(FILTER[STATUS])),TRUE,
[STATUS]=ANY(FILTER[STATUS]))))