Hi @mnvwvnm and @Bayerse - we were last talking about keeping track of our relationships over here, when the forum abruptly closed on us.
Thank you so much for your groundwork, @mnvwvnm - it took me a while to understand how FLATTEN was working and how your columns were pulling in data. But I was steadily able to tinker and come up with a solution that I think is a little more robust and will work well for me.
My set up
- #
- all my People notes have this tag - each People note needs a
Contact Frequency::field - set this to a time period ( 7 days, 1 month, 2 years) - #
- all my YYYY-MM-DD daily notes have this tag. The formula pulls in any notes with this tag - “_System” folder - is where my templates/attachments live, so I exclude this
- I grabbed an online emoji for aesthetics to indicate it is time to call the person
Catch up with friends table
TABLE WITHOUT ID
Person,
reverse(sort(rows.IN))[0] as "Last Contact",
choice(date(today) - date(reverse(sort(rows.IN))[0]) >= default(Person.contact-frequency, " "), "", " ") AS "Call_now?",
date(today) - date(reverse(sort(rows.IN))[0]) AS "Days since last contact"
FROM #👤 and !"_System"
FLATTEN file.inlinks as IN
WHERE contains(IN.file.tags, "#📓")
GROUP BY file.link AS Person
SORT reverse(sort(rows.IN))[0] ASC
