Make action available on last row

[Pratyay_Rakshit]

I want an action to be available / not available on the last row.

While this is achievable using MAXROW as one component, I’m not sure how I can put them all together?

If the rownumber in the table is maximum, then make the action unavailable.

I used the following yes/no expression:

MAXROW(“MyTable”, “_ROWNUMBER”) = MAX(MyTable[_ROWNUMBER])

But cant seem to make it work.

Please help

[Suvrutt_Gurjar]

if I have understood your requirement correctly, please try

[My Table Key Column]<> MAXROW(“MyTable”, “_ROWNUMBER”) in the action condition for the action to be unavailable for the last row in the table.

I believe in general the action needs to be of row type action and presume by maximum row number, you mean the last row in the “My Table” where data has been entered through AppSheet app and not the empty last row of the back end table.

[Steve]

Try:

([_ROWNUMBER] = MAX(MyTable[_ROWNUMBER]))