Post

16 followers Follow
18
Avatar

Add Filter for Date fields of Not Set or Is Set

Right now you can do some basic filtering of dates, but I'd love to be able to find things either that have a date or don't.  This can be very useful in project planning.  We have a dev tasks app that we use to schedule our work.  Sometimes we want to track things but aren't ready to schedule them.  This would allow us to have a view of unscheduled items (Where start date is "Not Set")

 

Thanks

 

 

Wes

Wesley Rosner Planned

Official comment

Avatar

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

Cheers,
Sara - Podio

Sara Høeg Højlund-Rasmussen

Please sign in to leave a comment.

20 comments

0
Avatar

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.

Nathan Anderson 0 votes
0
Avatar

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)?

Sarah Boisvert 0 votes
0
Avatar

@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.

Sarah Boisvert 0 votes
3
Avatar

@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.

Nathan Anderson 3 votes
0
Avatar

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?

Albert Ravn 0 votes
0
Avatar

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.

Rudolf Troger 0 votes
0
Avatar

+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.

Laura Jean Rabiipour 0 votes
0
Avatar

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.

Kees Nobel 0 votes
0
Avatar

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

Jacquelyn May 0 votes
1
Avatar

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!

Jack Kiperman 1 vote
1
Avatar

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? 

Stephen Revere 1 vote
0
Avatar

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

Mike Demunter 0 votes
0
Avatar

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?

Kees Nobel 0 votes
0
Avatar

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 
Яўген Барышнікаў 0 votes