Hello everyoneI've been on Airtable for a while now and I've never had to do anything complicated, but I have a really epic task, as for me. I'd ask the community to help me and not to scold me too much for stupid questions).I have three tables: Docs...
In the Client table I have the Meetings field, linked to Meeting table. A client can have multiple meetings.
I need to know, if a client has any two meetings closer to each other, then 1 month. If the difference between any two dates is less then a m...
Thanks for the ideas! They are very helpful:)
But how can we automatically link the actual meeting to the record of the previous meeting? Or get the date of last meeting before actual?
We have a Pro plan. It’s time to learn JC I guess :slightly_smiling_face:
Linkig manually - is not the solution, it needs more time than making manual report.
In the end, I added several pivot table apps and making screenshots.