Hi
I am trying to make a slice show the row with the lowest number in the priority-coloumn, and with โventerโ (waiting) in the status-column. The expression assistant accepts it, but when I save it crashes the appโฆ
I have tried to use the third examble on https://help.appsheet.com/en/articles/2357311-minrow
Should I use another expression or is there something wrong i the validation in appsheet?
Thanks,
Glenn
Solved! Go to Solution.
It appears you updated the expression but havenโt yet saved. The error displayed reflects the original expression youโd tried, and wonโt disappear until you Save the new configuration.
MINROW() expression returns the key column value and therefore a ref, so the return value type is TEXT, not a boolean (TRUE/FALSE). For a row filter condition, your expression shall evaluate to TRUE/FALSE.
In a sliceโs row filter, the row filter expression is evaluated once for each row of the table. The expression you want to construct needs to answer the question, โis this row the row that contains the minimum column value?โ Your MINROW() expression identifies โthe row that contains the minimum column valueโ, so you need to compare that with โthis rowโ:
([_THISROW] = MINROW("Opgaver", "Prioritering", ([Status] = "venter")))
Thank you. The expression does do the trick and the app dont crash any more. But I do get this warning:
It appears you updated the expression but havenโt yet saved. The error displayed reflects the original expression youโd tried, and wonโt disappear until you Save the new configuration.
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |