Link entity within a date-range to other enity (year)

I know that there are several workarounds out there to achieve this tasks but I was wondering if by now there was a direct way through automation and generic use of formula-code?

I want to link an entity A (EVENTS) to a parent entity B (table name YEARS).
The matching criteria would be a single date field (A) which should be within a date-range (B).

The event “Christmas party” (Table A) has the date “24 Dez 2024”
Table B holds several entities: 2022, 2023, 2024 - each entity with a date-range-field set to 01. Jan 20xx - 31. Dez 20xx
I now want to link the EVENT “Christmas party” to the correct entity from YEARS (in this case the date-range-field set 01. Jan 2024 - 31. Dez 2024).

To me this looks like quite a common thing to do…

Looking forward to hearing some great ideas on how to do this (the easiest way) :slight_smile:

Hi Christoph,
you can achieve this with a formula and a auto-relation.

First, create a formula (let’s say Year) on the Event DB. Here, you need to extract the year from the date like so: Year(Date.Start).
Now you can create a relation to the Year DB. When you do this, please select “Automatically link Events to Years”. Then select the Years Field of the Event DB and the (I guess) Name field of the Year DB.

E voilà, the events should be linked to the respective years automatically.

I hope this helps.


1 Like