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).
Example
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)
Christoph