Date before now

Can I filter by Do Date is on before now? If I have a task scheduled for today at 5pm I don’t want to see it at 10am.

1 Like

Like this?

1 Like

The filters (and formulas) in Fibery have maximum resolution of a day, so you can’t achieve it directly.
This is because any calculations/filtering that had greater resolution would result in so frequent recalculation that it would create a massive load on the service.

1 Like

No, that only accounts for day, not time.

Well dang. Unfortunately that’s a deal breaker for me using Fibery. :sweat: I need that for my task defer dates.

How do you/would you use that feature, if it were available? What are you trying to visualize?

I want to create a view that is filtered to only show incomplete tasks with a do date before now.

I understand that part - I was just wondering what your work process is that needs such a view –
I’m having a hard time imagining how I would need such a view, where I would see rows disappear before my eyes as the minutes tick by…

You actually could accomplish this with a simple Formula, BUT a view that filters on a dynamically changing value like this would not automatically refresh - it would only update when the page is manually refreshed or some other process causes it to re-fetch the records (which could be automated).

1 Like

Actually, I don’t think you can do it even with a formula, you would probably need to use a scheduled automation (every hour) but it is correct that…

Oh sorry, I misunderstood.

On any given day I might have 60-200 tasks and I need to be able to see only what is actionable at that moment. If I come to my daily tasks and see all 200… that’s unmanageable.

1 Like

I suggest using a formula that runs on a schedule and sets a flag based on the required criteria, since automations can compare date-time field values with Now()
Then set a view to filter on this flag.

1 Like

You can create a view that is Sorted by DateTime-Due, and filtered to only show incomplete items that are due before or after today/yesterday/tomorrow/etc.

@Chr1sG - will a view like this automatically update when one of its displayed rows changes status? I.e. when a Task is completed, and the View is filtering on Task status?

Also, a scheduled page refresh can easily be automated via a small browser script.

1 Like

I usually group tasks into projects, so a straight sort by date/time wont really help.

I’m sensing a theme here. That Fibery is powerful and can do a lot. But it takes so many weird and complicated workarounds to do things that should just work.

2 Likes

LOL Yes, depending on your expectations – the product can come off as a bit “young” compared to more mature tools, and it is still under heavy development. OTOH it also offers a lot of ways to customize/work around missing features.

For example, the Fibery team has prioritized implementing basic (and advanced) features over having a highly polished and consistent “professional level” UI. There are some die-hard Fibery fans (like myself) who think this decision scares off a lot of potential customers. :cry:

Another example: a lot of scripting is necessary to implement some of the more “creative” awesome things that Fibery can do, but there is no centralized management for scripts, which makes script maintenance a nightmare :scream: – 100+ scripts scattered about, with no good way to find out where they exist or what’s in them, no script libraries or globals, very difficult debugging, etc.

3 Likes

One way of looking at it is like a box of Lego.
If you want a toy car, you’re going to have to do a bit of work to get something usable, and even then it won’t look as pretty as an off-the-shelf toy car.

Or it’s a swiss army knife, which means you will be able to chop branches, file your nails and open a bottle of wine, but for none of these activities will the experience be as good as if you had a chainsaw, manicure set and corkscrew.
Some people want a shed full of tools, some people like to travel light :slightly_smiling_face:

With that in mind, you will always be able to find a tool that does some particular thing more easily/better/prettier than Fibery. But if there are a dozen processes you need to manage, you may find that a Fibery-based setup does all of them at a level you can live with.

There’s a lengthy discussion here in the community about what constitutes an acceptable level for any given function.

For me, part of the problem lies in that each user will have a different idea of what are the specific

“You can please all of the people some of the time, or some of the people all of the time, but…”

2 Likes

Are there any plans for more global/centralized automation management? It would make waiting longer for more native features a LOT more bearable and less chance of eventual abandonment of the platform for people I think.

1 Like