My app is designed to store data long term.
So there are many rows with the same ID.
I just need it to only show the newest row of every ID, that has a specific status.
I can filter based on Status fine but I can’t think of a way to only show each ID’s latest entry
Do you have a date time column? Or if all else fails could you use row number for a MAX expression.
Yes I do have a DateTime column. I’ll look into the MAX expression, thanks
I understand I should use something like MAX(LIST(
But I’m unsure of what the expression would look like
could use expression like
Maxrow(“tablename”,_Rownumber) and it will pick the key column which could be the ID column this your case…