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
-
Official comment
We hope to add this functionality in the future! Cannot promise an ETA but it is planned for.
Cheers,
Sara - PodioComment actions -
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.
-
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 - 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. -
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.
-
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
-
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?
-
Just in case, here is a simple workaround for filtering items with no date set. Let's say, we have a field "Date".
- 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)
- Now you can filter items by this number filed:
To 0 → Date is not set
From 1 → Date is set
- Create a calculation field with any name you like and this formula:
-
As calculations are not always accurate, I can not use the solution above. This issue is still not fixed after 10 years... A new customer is using TapeApp and here you can have a filter on an empty date (and many more). But I think Podio does not like me to tell this. Let's hope they improve soon and develop the product further and fix bugs
Please sign in to leave a comment.
Comments
21 comments