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?
(I’m not familiar with Javascript and on a Pro plan)
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.
Our users creates new groups, so the list of totals is dinamic.
If I would create a formula, it must be edited every week, and it takes more time than manual report :slightly_smiling_face:
