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
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.
Try:
([_ROWNUMBER] = MAX(MyTable[_ROWNUMBER]))
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |