Good morning everyone.
I have a condition in a slice to filter all records that meet the OK condition in the [ESTCONTRATO] field, and a second condition to filter based on the user. The problem is, I don't know why the filter isn't only showing those that meet the OK condition.
The formula is the next:
AND(
([ESTCONTRATO] = "OK"),
(LOWER([EmailUser])=LOWER(USEREMAIL()))
)
Thanks in advance,
Javier
Please test in isolation with one condition each so that you would know if any one or both are failing. Also in general wrapping email columns with LOWER() should not be necessary.
So, please test with slice filter of
[ESTCONTRATO] = “OK”
first and then with a slice filter of
[EmailUser]=USEREMAIL()
What makes you think it isn’t working? How are you reviewing the results?
Hi Steve.
Thank you for your answer.
I´m testing in appsheet. I send you attached a screenshot. In this example, some of the conditions are false, but I can see in the slice.
Hi !!!
Thank you for your answer.
I tried onli with the slice filter [ESTCONTRATO] = “OK”, but I can see al the records: the records with OK and the records with NO.
Please share the possible values that the column [ESTCONTRATO] can have and has in the backend table. Is it an enum column?
Hi !!!
The values for this column can be: OK or NO.
I want to filter the records with OK value.
This column is in text format

Please post screenshots of the configurations of the views of the slice.
That’s the slice configuration. I’d like to see the view configurations from UX > Views. The detail view, at least.
I think Steve has asked for the detail view configuration.
Sorry!!
Is this the right view? The value that I want to filter is OK, but I get both values, OK and NO










