# Last Project Meeting

**URL:** <https://community.fibery.io/t/last-project-meeting/1429>\
**Category:** Get Help\
**Created:** [March 6, 2021, 10:34pm UTC](https://community.fibery.io/t/last-project-meeting/1429 "2021-03-06T22:34:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![cannibalflea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cannibalflea/32/318_2.png) [@cannibalflea](https://community.fibery.io/u/cannibalflea)\
**Post date:** [March 6, 2021, 10:34pm UTC](https://community.fibery.io/t/last-project-meeting/1429/1 "2021-03-06T22:34:48Z")

</div>

Hi everyone,

I have an app where I manage projects and project meetings:

![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/0/0ec64c58b865ee97fc13d15b06de8e3ddcbc3452.png)

I am trying to see if it is possible to use a formula field to display a link to the previous project meeting when I am working on the current project meeting (i.e. the meeting with the greatest date prior to the date of the current meeting entity). I was trying to use the filter function, but couldn’t figure out how to both refer to the [Project Meetings] collection’s date field and the current meeting entity’s date field (pseudocode):

`Project.[Project Meetings].Filter(Date.Start < {Current Meeting Date.Start})`

I also wasn’t sure how to exactly return just one item.

Is this even possible?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [March 7, 2021, 9:23am UTC](https://community.fibery.io/t/last-project-meeting/1429/2 "2021-03-07T09:23:53Z")

</div>

It’s not possible to refer to an entity’s own fields in the filter expression (you can only use the fields of the entity collection the filter applies to).  
It has been discussed before, in another context

> [@\[DONE\] Siblings as Children of Parents: filter self](https://community.fibery.io/t/siblings-as-children-of-parents-filter-self/981):
>
> Bit of a confusing title, but basically: When using self-relations in a type, the uni-directional type is often a great fit for the relation (that is - not for situations where I’d want the basic / undirected / bi-directed siblings), where the concept of “parent” entities and “child” entities exists, but they really are all the same type. In such scenarios, it’s often nice to see automatic sibling links, through a lookup: using the children of parents. The problem is that this results in inclu…

Anyway, I have made a demo app that sort-of solves your problem.

> **[Start for free, upgrade when you love it — Fibery](https://shared.fibery.io/sign-up?appShareId=a9614110-fa57-4c13-a94d-a60459057884-meeting-links)**
>
> Create Fibery account. Build your company workspace with no code.

It uses a formula in the project type to find the date of the latest meeting, and then adds a ‘Latest’ flag to the whichever meeting has the matching date.  
Then there is another project formula to find the latest date from all meetings that don’t have the ‘Latest’ flag set, in order to find the date of the penultimate meeting. The meeting that matches this date is flagged as ‘Penultimate’.

Finally, all meetings have a formula field to list the meetings that have either flag set (‘Latest’ and ‘Penultimate’). In this way, whichever meeting you are curently looking at, you can quickly navigate to the latest or penultimate.  
I know it doesn’t exactly provide what you asked for, but I hope it helps your use case.