Add Filter for Date fields of Not Set or Is Set

Planned

Comments

20 comments

  • Official comment

    We hope to add this functionality in the future! Cannot promise an ETA but it is planned for.

    Cheers,
    Sara - Podio

    Comment actions Permalink
  • Nathan Anderson

    We have a couple use cases where this will be important to have. 

    1) Just like the OP, we need a list of items that have not been scheduled yet.

    -- and --

    2) We build exception reports to identify items that are in an invalid state. I would like to see all items that have a "Follow-up" status, but are missing the date the follow-up is due to occur. Not all items require follow-up, so I can't set "Follow-up Date" as a required field.

    0
    Comment actions Permalink
  • Elia Malmsten

    I don't see why it dosn't exist?

    2
    Comment actions Permalink
  • Alexander Kaletsch

    +1

    Having the same problem with missing Follow-Up dates..

    any progress on that mater?

    0
    Comment actions Permalink
  • Andrew Bridges

    Adding this option would make a bid difference for us.

    0
    Comment actions Permalink
  • Sarah Boisvert

    Same problem, different application - we just added a "date request was made" field and I filled it in for most of our records. Now I want to view ONLY the records that do not have this "date request was made" field filled in, so I can then sort by client name and quickly compare to a list of requests. Unfortunately, I'm going to have to sort by "date request was made" (all the blank ones will go to the top) and do a lot of scrolling up and down to find particular clients.

    A date: not set filter would be ideal, but I could also work with the ability to sort two fields at once - first sort the date request was made column to get the not set records together, and second, sort within the results to alphabetize the client names. Currently, a second sort will overwrite the results of the first - all my 'not set' results get mixed back in with the rest.

    What's the prognosis on this feature (or similar)?

    0
    Comment actions Permalink
  • Sarah Boisvert

    @Nathan Thank you so much for your quick reply! Your workaround looks like it will work perfectly for my purposes - not pretty, but it will get the job done until the feature(s) are added. I only need the Date Not Set filter for certain small projects anyway.

    0
    Comment actions Permalink
  • Nathan Anderson

    @Sarah - I still think a "Date not set" filter should exist and "multiple sort" should exist, but I found a workaround that might help your situation. Create a calculation field like below:
    @Date Request Was Made == null
    The result is a number field (which is filterable) 1.0 means "not set" and 0.0 means a date is set.

    3
    Comment actions Permalink
  • Kees Nobel

    It seems this option still doesnt exists

    0
    Comment actions Permalink
  • Albert Ravn

    This is very much needed, and as far as I know it should be easy to integrate! How come this simple feature is still missing, Podio team?

    0
    Comment actions Permalink
  • Rudolf Troger

    We need this to filter tasks which have no deadline set and need to be planned. Please add the option to the filter for date fields like other types of fields have it already.

    0
    Comment actions Permalink
  • Laura Jean Rabiipour

    +1 Our app uses a date field for the day we activate a product but need to be able to filter on items without a date.

    0
    Comment actions Permalink
  • Mike Demunter

    +1

    0
    Comment actions Permalink
  • Kees Nobel

    After 4 years still not even a reaction from Podio. Do they read these wishes anyway? Podio where are you? Why is this simple feature still missing? Why is no one comment on these wishes? If I let my customers wait for four years, my company will be out of business a while ago. So please make sure you add this quickly.

    0
    Comment actions Permalink
  • Jacquelyn May

    Hi Kees,

    We are here :) We don't always reply to every single feature request but we do monitor closely. We also cannot promise to build every single feature request, but we do add quite a few as you can see here!

    https://help.podio.com/hc/en-us/community/topics/200071937-Completed-Feature-Requests

    That being said, we would definitely like to make some changes to how filters work in the future. We'll be sure to update everyone here if there are any changes.

    /Jacquelyn - Podio

    0
    Comment actions Permalink
  • Jack Kiperman

    Yes definitely need this! Trying to set up some workflows that show us when date data is missing from a field and can't seem to do it!

    1
    Comment actions Permalink
  • Stephen Revere

    There are some things it seems as if the Podio team deliberately avoids for almost ZERO reason. This is an easy fix that would make Podio much more useful. Why, Podio? Why? 

    1
    Comment actions Permalink
  • Mike Demunter

    Apart from Date field type, for most field types the "is not set" option is already available.

    However, an "is set" filter (especially for relationship & category field types) would be very beneficial as well

    0
    Comment actions Permalink
  • Kees Nobel

    Is there anyway we can speedup the process of future requests? We are waiting for years on this simple future, but never get any real response. 

    For now we need to use a very complex workarround:

    - Add a hidden field: date set: yes/no

    - Add a globiflow (not available in all versions)

    - Set dateset to yes or no

    - Use the dateset as filter

    - Add a second globiflow on update to set the dateset field

     

    Alternative:

    Write your own webhooks and host them, I will work this out later on. Using the API you won't need Globiflow.

     

    @podio: is it really so difficult to make this small change?

    0
    Comment actions Permalink
  • Яўген Барышнікаў

    Just in case, here is a simple workaround for filtering items with no date set. Let's say, we have a field "Date".

    1. Create a calculation field with any name you like and this formula: 

      @Date ? 1 : 0

      This will set the filed type to number and set value to 1 when the date is set and 0 when the date is not set. You can't filter items by string fields in Podio, but by number fields it is possible.

      To keep the output clean set this field to be "Always hidden" (this is optional)

    2. Now you can filter items by this number filed:
      To 0 → Date is not set
      From 1 → Date is set 
    2
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk