This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Logic with Last Rows

Posted on 05-18-2021 07:48 PM
Mas_Syahdan_Fil
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

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

why display for โ€œid_absensiโ€ not โ€œtgl_absensiโ€ can you help me?
my slice

my table

thanks

0 4 131
Topic Labels
  • UX
0 Likes
4 REPLIES 4

Posted on --/--/---- --:-- AM
Marc_Dillon
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

MAXROW() returns a Key value

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

Posted on --/--/---- --:-- AM
Mas_Syahdan_Fil
Silver 1
Silver 1
In response to Marc_Dillon
Reply posted on --/--/---- --:-- AM

3X_3_e_3e32a0db8647de01462193e79a0f391ad8c46e4f.png

but why not hide?

0 Likes

Posted on --/--/---- --:-- AM
Marc_Dillon
Platinum 1
Platinum 1
In response to Mas_Syahdan_Fil
Reply posted on --/--/---- --:-- AM

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

??

0 Likes

Posted on --/--/---- --:-- AM
Mas_Syahdan_Fil
Silver 1
Silver 1
In response to Marc_Dillon
Reply posted on --/--/---- --:-- AM

3X_5_4_540d5a357763f9de01306934068159fd60750d8e.png

not hide

0 Likes
Top Labels in this Space