# In-app filtering BUG **URL:** \ **Category:** Ask for Help\ **Tags:** tutorial\ **Created:** [December 25, 2023, 1:18pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998 "2023-12-25T13:18:31Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![Bunyod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bunyod/32/68110_2.png) [@Bunyod](https://community.glideapps.com/u/Bunyod)\ **Post date:** [December 25, 2023, 1:18pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/1 "2023-12-25T13:18:31Z")
_First time reporting a bug? [Refer to our Start Here post.](https://community.glideapps.com/t/start-here-reporting-platform-bugs-issues/40)_ * * * Glide Layout editor is showing All categories in In-app filter, but PWA is showing fewer, sometimes 3, sometimes 4 options. But not all. Rows are not empty, I showed in recording. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 25, 2023, 1:31pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/2 "2023-12-25T13:31:48Z")
Do you mind sharing the recording? ---
**Author:** ![Bunyod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bunyod/32/68110_2.png) [@Bunyod](https://community.glideapps.com/u/Bunyod)\ **Post date:** [December 25, 2023, 1:33pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/3 "2023-12-25T13:33:47Z")
Hey Darren, thanks for reply! Added (edited) my topic ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 25, 2023, 1:41pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/4 "2023-12-25T13:41:30Z")
Can you tell me more about that if-then-else column? You mentioned that it is based on a date value. My gut feeling is that might be where the source of the problem is. ---
**Author:** ![Bunyod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bunyod/32/68110_2.png) [@Bunyod](https://community.glideapps.com/u/Bunyod)\ **Post date:** [December 25, 2023, 2:00pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/5 "2023-12-25T14:00:06Z")
1. JS code is counting days between date of payment and today 2. if/then/else column taking that values and transforming to 6 options 👇 - 3 days till next payment - 2 days till next payment - 1 day till next payment - today - payment date passed - there is bunch of days till next payment ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 25, 2023, 2:07pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/6 "2023-12-25T14:07:23Z")
Okay, can you try the following please: - Replace your JavaScript column with a Math column using the following formula: ```auto Round(Now-Date) ``` Where `Now` is the current date/time value, and `Date` is the Payment Date. Then use that Math column in your if-then-else column. Tell me if that fixes the issue. Also, can you show me a screen shot of your Payment Date column? ---
**Author:** ![Bunyod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bunyod/32/68110_2.png) [@Bunyod](https://community.glideapps.com/u/Bunyod)\ **Post date:** [December 25, 2023, 2:10pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/7 "2023-12-25T14:10:27Z")
Payment date ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1a13eaeee64126d8ea41fc0bb77bd3880918d6d5.png) Today’s date ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/4/14b1764fc645354d16a237abbabf83355feff8fa.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 25, 2023, 2:10pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/8 "2023-12-25T14:10:55Z")
What columns types are they? ---
**Author:** ![Bunyod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bunyod/32/68110_2.png) [@Bunyod](https://community.glideapps.com/u/Bunyod)\ **Post date:** [December 25, 2023, 2:12pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/9 "2023-12-25T14:12:26Z")
Format date ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 25, 2023, 2:13pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/10 "2023-12-25T14:13:32Z")
Okay, that’s what I suspected. And I’m now 99% sure that’s what is causing your problem. Can you tell me why you are using the format date column? Is it just to get the date formatted how you want, or is there another reason? ---
**Author:** ![Bunyod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bunyod/32/68110_2.png) [@Bunyod](https://community.glideapps.com/u/Bunyod)\ **Post date:** [December 25, 2023, 2:17pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/11 "2023-12-25T14:17:04Z")
I used excel formula to count dates between. But it counted wrong days between, when dates were from different years. For example, 10.02.2024 - 10.10.2023 Then I moved to JS, JS asked for “format of dates should be the same”, then I used format dates. But I didn’t use math or date difference column. Seems I should check them ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 25, 2023, 2:23pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/12 "2023-12-25T14:23:24Z")
Yes, you should use a Math column. It is much more reliable. Use the formula that I gave you earlier, but make sure you use the raw date value that’s actually stored in a Datetime Type column. If you use the output of a Format Date column, you’ll get the same problem. Same for the current date, use the special `Now` or `Today` value, not something that comes from a Format Date column. So something like the below: ![CleanShot 2023-12-25 at 22.22.04@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8b43c868b81a25fed7f5855de0a6bd1baccd67d8.png) ![CleanShot 2023-12-25 at 22.22.18@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/0/3095dfbb60d26da556d2cfb3c3deb874c166c9e7.png) Do it that way, and it will work on your phone. Trust me 😉 ---
**Author:** ![Bunyod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bunyod/32/68110_2.png) [@Bunyod](https://community.glideapps.com/u/Bunyod)\ **Post date:** [December 25, 2023, 2:27pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/13 "2023-12-25T14:27:02Z")
> [@Darren\_Murphy](#): > > `Round(Now-Date)` Is “Now” getting date and time of Now? Or is it stored in Column? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 25, 2023, 2:39pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/14 "2023-12-25T14:39:15Z")
It’s a special value that’s available when you configure the math column: ![CleanShot 2023-12-25 at 22.38.02@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/4/b4c4e5a9bbeb1d48bfe77cb98fbde6e9fec3ec79.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 25, 2023, 4:06pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/15 "2023-12-25T16:06:24Z")
@Bunyod please let me know if the above solves your problem. I’m fairly certain that it will, but it will be good to have that confirmed. ---
**Author:** ![Bunyod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bunyod/32/68110_2.png) [@Bunyod](https://community.glideapps.com/u/Bunyod)\ **Post date:** [December 25, 2023, 6:31pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/16 "2023-12-25T18:31:58Z")
I will try both ways, and let you know Darren super Thank you ! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [June 22, 2024, 6:32pm UTC](https://community.glideapps.com/t/in-app-filtering-bug/68998/17 "2024-06-22T18:32:44Z")
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.