In-App filter doesn't work for booleans generated by formula

Report a Bug
1

My App/Pages support link:

  • It’s in a personal app so it won’t let me generate a link, but this happened to me in every single project.

Describe the bug:

  • When using In-App filter in a collection, boolean columns that are a result of a formula (e.g. if then else) always show an empty list when turned on. “Normal” boolean columns work as expected.

Expected behavior:

  • When turned on, I expect filters based on formula to show “true” values.

How to replicate:

  • Create a table, add an if then else column with any random rule, then try to use it as an in-app filter.

Link to demo recording (optional):

2

I can confirm this. Please submit a ticket.

1 Like
3

Done. Thanks

1 Like
4

Same problem here, I’m available to help if needed.

2 Likes
5

Was this solved? do you mind sharing the solution? I’m having the same issue…

Thanks!

7

i see same problem.

addition: single value - does not recognise as empty. it behaviour like it not exist: it’s not affect if choice “empty” or “not empty”

8

Can you show us the behaviour in a video or some screenshots?

9

10

What row is your tab built on? Do you have any filters on the tab level?

11

Remove this.

Screenshot_20240728-083707~2

3 Likes
12

oh… this time i’m so much wrong…

sorry

1 Like
13

Found a solution! when i use lowercase for the boolean options “true/false” instead of uppercase “True/False” it works

14

That’s just weird.

However, I hardly ever use booleans for filters anymore. I think there are 3 states that can be presented:

  • No filters
  • False
  • True

However as I understand it, there’s no way to know if it’s “no filters” or “false”. Is that still correct?

15

I believe that’s correct. I find Booleans to be an effective filter when you are only interested in “true” conditions

1 Like