Logic with Last Rows

[Mas_Syahdan_Fil]

Hi dear,
i want to make attedance user with appsheet but my logic don’t work
i want to get date last for the slice “absensi_usermail” my logic is

Lightshot

Screenshot

Captured with Lightshot

why display for “id_absensi” not “tgl_absensi” can you help me?
my slice

Lightshot

Screenshot

Captured with Lightshot

my table

Lightshot

Screenshot

Captured with Lightshot

thanks

[Marc_Dillon]

Mas_Syahdan_Filsafan:

why display for “id_absensi” not “tgl_absensi”

MAXROW() returns a Key value

Maybe you need just MAX()?
Maybe:
MAX( absensi [tanggal_Absensi] )

help.appsheet.com

MAX()

Highest item in list

help.appsheet.com

MAXROW()

Row with greatest value in column

[Mas_Syahdan_Fil]

Marc_Dillon:

MAX( absensi [tanggal_Absensi] )

but why not hide?

[Marc_Dillon]

Maybe you’re wanting to use an inequality instead of equality.
<> TODAY()
instead of
= TODAY()

??

[Mas_Syahdan_Fil]

not hide