CRM
CRM

CRM

Created
Nov 29, 2019 9:31 AM
Tags

Personal Relationship Management

🤔 What this is

click the black triangles to see more detail

Like a CRM but for personal relationships, to help you stay closer to friends and contacts
The People template (database) below is where you add contacts and their information
Click on "All - Simple (Table)" to see People in different ways (and make your own view)
All of these views are based on the same database of information
The second database for Events is a list of trips and activities, and is linked to the People database

* If you change the Goal field, you can adjust the formula in the Deadline field so that it works with your new option. Open a record in the database and update the current formula:

if(prop("🎯 Goal") == "Weekly", 7, if(prop("🎯 Goal") == "Monthly", 28, if(prop("🎯 Goal") == "Quarterly", 90, if(prop("🎯 Goal") == "Half-Year", 180, if(prop("🎯 Goal") == "Annually", 365, 999999)))))

For example, if you want to add a "Bi-monthly" you would replicate the logic used with the other options:

if(prop("🎯 Goal") == "Weekly", 7, if(prop("🎯 Goal") == "Bi-monthly", 60, if(prop("🎯 Goal") == "Monthly", 28, if(prop("🎯 Goal") == "Quarterly", 90, if(prop("🎯 Goal") == "Half-Year", 180, if(prop("🎯 Goal") == "Annually", 365, 999999))))))

🖐️ How to get it

💭 Why I did it

Remembering to get in touch is different to responding to a text or post on social

(and maybe a doc is as good as an app)

Click "All - Simple (Table)" 👇 to see the contacts list in different formats and with filters ⬆️

🙂
Template (1): People

Name🎯 Goal🚩 Overdue<-- LastNext -->🔨 ActionShared Event
Weekly
January 21, 2019
January 29, 2019

Return his camera next time!

Weekly
January 21, 2019
February 5, 2020
Monthly
February 2, 2019
Quarterly
November 5, 2018
Quarterly
December 19, 2018

Arrange dinner @April 10, 2019 8:00 AM (GMT)

Half-Year
January 28, 2019
February 8, 2019
Annually
December 4, 2018
June 27, 2019

Share case study

Open "Trip to S. Africa" 👇 to see how you can keep notes and files inside the table ⬆️

✈️🍷 Template (2): Events

NameDate(s)PeopleFiles
April 8, 2019 → April 28, 2019
January 21, 2019