# Filter data by selecting customer service name, start date and end date **URL:** \ **Category:** Ask for Help\ **Created:** [January 24, 2025, 5:08pm UTC](https://community.glideapps.com/t/filter-data-by-selecting-customer-service-name-start-date-and-end-date/79489 "2025-01-24T17:08:52Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Post date:** [January 24, 2025, 5:08pm UTC](https://community.glideapps.com/t/filter-data-by-selecting-customer-service-name-start-date-and-end-date/79489/1 "2025-01-24T17:08:52Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/9/99c5fe1b8695a8de1314a53cb13cae122bd021c7.jpeg) O I want to select the selected data based on customer service name, start date and end date, but I’m confused when I select one of the customer service data names in the if-date-admin column and it’s false, how do I make the data match what I selected? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 24, 2025, 5:17pm UTC](https://community.glideapps.com/t/filter-data-by-selecting-customer-service-name-start-date-and-end-date/79489/2 "2025-01-24T17:17:07Z")
If name IS NOT name, then false. If date is LESS THAN or GREATER THAN their respective start and end dates, then false. Your final Else should be true. ---
**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Post date:** [January 24, 2025, 5:28pm UTC](https://community.glideapps.com/t/filter-data-by-selecting-customer-service-name-start-date-and-end-date/79489/3 "2025-01-24T17:28:43Z")
Hi, thanks for the response, I have tried it, and it works… but there is one more problem, when I don’t select anything the data is empty, what I hope is that when I don’t select anything the data all appears ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/df23e5a664ebec2e40992f29f4d8ae9bfecc6741.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 24, 2025, 5:34pm UTC](https://community.glideapps.com/t/filter-data-by-selecting-customer-service-name-start-date-and-end-date/79489/4 "2025-01-24T17:34:08Z")
If two of the filters are filled, but not the third, what should happen? ---
**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Post date:** [January 24, 2025, 5:43pm UTC](https://community.glideapps.com/t/filter-data-by-selecting-customer-service-name-start-date-and-end-date/79489/5 "2025-01-24T17:43:42Z")
the data remains empty ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/f/ef1dcdb384fa23ec5722bb5e457fd077b598cd2c.jpeg) but if I just select the customer service name, the data appears, even though I don’t select the start and end dates ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cb39b323a05cf4efa0825cc69eea2e1ed0bb449f.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 24, 2025, 5:51pm UTC](https://community.glideapps.com/t/filter-data-by-selecting-customer-service-name-start-date-and-end-date/79489/6 "2025-01-24T17:51:35Z")
Is that what you want? So you want to be able to select a just dates, or select just a name, or select both? And if you select nothing, then everything shows? What if you select only one of the two dates? I just want to understand what you expect to helaooeb in all of those scenarios. Can you show how your IF column is currently set up? ---
**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Post date:** [January 24, 2025, 5:57pm UTC](https://community.glideapps.com/t/filter-data-by-selecting-customer-service-name-start-date-and-end-date/79489/7 "2025-01-24T17:57:32Z")
> [@Jeff\_Hager](#): > > just want to understand what you expect to helaooeb in all of those scenarios. expected scenario 1. When you don’t select anyone: the data will be displayed in its entirety 2. When selecting one of the filters (date or name): it will display the data according to what was filtered, if everything is filtered (date and name) the data will follow suit. ---
**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Post date:** [January 24, 2025, 5:58pm UTC](https://community.glideapps.com/t/filter-data-by-selecting-customer-service-name-start-date-and-end-date/79489/8 "2025-01-24T17:58:22Z")
> [@Jeff\_Hager](#): > > Can you show how your IF column is currently set up? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5c931e0054b12485c589e8fa6651619c38d61d2d.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 24, 2025, 6:07pm UTC](https://community.glideapps.com/t/filter-data-by-selecting-customer-service-name-start-date-and-end-date/79489/9 "2025-01-24T18:07:35Z")
Ok, first of all, change your date conditions to be \<= and \>=. Your dates are only filtering to the 19th and not including the 18th or 20th. You don’t have any data for the 19th. I think there is more to do, but start with that first to make sure it works with all 3 filters filled. ---
**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Post date:** [January 24, 2025, 6:19pm UTC](https://community.glideapps.com/t/filter-data-by-selecting-customer-service-name-start-date-and-end-date/79489/10 "2025-01-24T18:19:28Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/5/a544806b182e59727f03e641a6920f2626334fd2.jpeg) is this the setting like? I tried filtering the 17th and 18th with the name CS Risky, but it didn’t return true ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 24, 2025, 6:28pm UTC](https://community.glideapps.com/t/filter-data-by-selecting-customer-service-name-start-date-and-end-date/79489/11 "2025-01-24T18:28:32Z")
I may have been wrong with the \<= and \>=. Due to the complexity of the conditions, I’m thinking you may need to split this into two IF columns. One for just dates like this: ```auto If start date is empty then true ElseIf end date is empty, then true ElseIf date < start then false ElseIf date > end then false Else true ``` Then another just for name: ```auto If name is empty then true ElseIf name is not search name then false Else true ``` Change your collection filter to check if both IF columns are true for the row to be shown. Can I also ask why you are comparing to a name in the user profile instead of a single value in the table? ---
**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\ **Post date:** [January 24, 2025, 7:12pm UTC](https://community.glideapps.com/t/filter-data-by-selecting-customer-service-name-start-date-and-end-date/79489/12 "2025-01-24T19:12:56Z")
perfect, thank you very much, thanks to you I have achieved what I hoped for… thank you very much… ---
**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:** [January 31, 2025, 7:13pm UTC](https://community.glideapps.com/t/filter-data-by-selecting-customer-service-name-start-date-and-end-date/79489/13 "2025-01-31T19:13:29Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.