My problem I have a DB of weeks, all of which are in date sequence. I want to have a window of 4 weeks (tagged as Last week, This week, Next week, 2nd next) that automatically updates every Monday. The point is to link tasks to weeks, and lookup the week tag, allowing us to have a kanban board of t…

Hi @Mikkling I think there might be some clever tricks you can use to make things easier/simpler, but before I suggest them, can I check something: what fields does a Week entity have (apart from the one(s) you added to get the sequence working)? I might guess that a date field is one of them (Sta…

Also, can you explain what [image] Mikkling: entity-level named links means and/or would entail…

I’m actually using the Dates template space you posted a while back, and the weeks are the year-week DB from that template. Also, “entity-level named links” is just my wish for graph DB edges in Fibery. Now that i think about it, i realize that those would not mean much without the power of a graph…

In that case, here’s what I would do: create a Tag database (with entities Last week, This week, Next week and 2nd week) add a number field called Offset and set the value to the number of days difference from today (e.g. -7, 0, +7, +14) use a formula field to get a date based on the offset: Toda…

[image] Chr1sG: use a formula field to get a date based on the offset: Today() + Days(Offset) Cool, thanks! And to make the week tags autoupdate, i’d change the formula field to a regular date field and update those dates with an automation, right? I still think Fibery needs a way to sort a…

The week tags will auto-update if set up like I describe. This is because the calculated Date field in the Tag database will change every day, and this will change the auto-related Linked date, and this will be reflected in the lookup. No automations needed! :slight_smile:

Seriously? I thought all functions in formula fields were passive. The information that Today() automatically runs itself should definitely go in the Formulas Reference! Is that why Now() is not available in formula fields?

So yes, Today() will return the current date (which will be a different value tomorrow than it is today) so in that sense it ‘runs automatically’. Perhaps our user guide should be more explicit about this. And correct, we can’t allow Now() in formula fields, since it would recalculate every second…

Hi @Chr1sG ! Would you mind sharing the Dates DB again? I have a similar use case and would like to see how you’ve set it up.

I think I found it, for anyone else looking. [image] Template for date grouping News & Announcements UPDATE: this (static) template is being superseded by an integration template: At the moment, Fibery only natively supports the standard date field, which requires the u…

Enumeration of sequential entities

Ideas & Features

aoe January 8, 2023, 11:12am 11

I think I found it, for anyone else looking.

Topic		Replies	Views
How to create an entity Queue/Sequence/Chain/Book with previous next button Get Help	5	325	July 3, 2023
How to create a Daily and Weekly Journal (Newbie Question) Get Help	4	679	January 15, 2026
Weekly view using relations, automations, and board view Fibery Showcase	0	90	September 21, 2025
Weekly overview of workspace Get Help	2	90	April 8, 2025
Sequential Name Formula? Get Help	24	455	August 27, 2025

Enumeration of sequential entities

Related topics