"Row filter condition" disapears after I save it

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:

1 Like

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

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

1 Like

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?

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.

1 Like

@natalie, can you help here?

@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!

1 Like

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

1 Like

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

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?

1 Like

Now it is giving me an error?

1 Like

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

2 Likes

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

Mine:
image

Appsheet help:
image

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

2 Likes

Oh. Ok. Thanks

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?

Try this as the slice row filter expression

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

That worked. Thanks as always Steve…

2 Likes

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?
image