"Row filter condition" disapears after I save it

[Tiger1]

I have a table that I am making a slice and every time I enter my “Row filter condition” - it disappears. Is this a bug?

Saved expression:

[Steve]

Did Expression Assistant open? Did you save your expression from within Expression Assistant?

[Tiger1]

Weird -you asked that. No the expression asst did not open. I did save it,

[Steve]

I suspect the behavior you’re getting is due to a recent enhancement to slice row filters. Did you get a dropdown that offered suggestions?

[Tiger1]

No. I had to type the expression in the area/field, then click enter. Then the suggestions popped up. However, once I clicked “Custom” - while inside the expression builder - it never showed the data (Column names etc…) It was weird.

[Steve]

@natalie, can you help here?

[nkadonaga]

@Tiger , sorry you’re getting some confusing behavior here. Yes, writing slice row filters was broken by an unrelated change. Please stay tuned for a fix. Thanks!

[nkadonaga]

@Tiger As a workaround, please type into the box first, then click “Create a custom expression,” then that should open Expression Assistant.

[Tiger1]

It does. But after I save- it doesn’t show the expression in there anymore?

[nkadonaga]

Oh my apologies, I misread the original problem. When you’re in the Expression Assistant, can you make sure you’re using the formula field, not the description field?

[Tiger1]

Now it is giving me an error?

[nkadonaga]

Ok good, we resolved the first issue. That error is expected. Let us know if following “More info” and reading the linked docs does not give you the info you need to resolve the error

[Tiger1]

How does mine differ from the one I find in appsheet help?

Mine:

Appsheet help:

[Steve]

MAXROW() returns a row reference, not a Yes/No value expected from a slice row filter expression.

[Tiger1]

Oh. Ok. Thanks

[Tiger1]

Steve - I must be using the wrong expression then. I am trying to email (auto) the latest rows depending on [Date]. In other words, I want the latest rows of data emailed based on [Date] column…

How do I do this?

[Steve · Accepted solution]

Try this as the slice row filter expression

([_THISROW] = MAXROW("DSO for all divisions", "Date"))

[Tiger1]

Steve:

([_THISROW] = MAXROW("DSO for all divisions", "Date"))

That worked. Thanks as always Steve…

[Tiger1]

Steve,
When the email ran this morning - no data was there? Meaning it did not show the latest rows of data:

This data should have been there, right?