Created
Nov 29, 2019 9:31 AM
Tags
Personal Relationship Management
🤔 What this is
click the black triangles to see more detail
‣
‣
‣
‣
‣
* 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 ⬆️
Name | 🎯 Goal | 🚩 Overdue | <-- Last | Next --> | 🔨 Action | Shared 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 ⬆️
Name | Date(s) | People | Files |
---|---|---|---|
April 8, 2019 → April 28, 2019 | |||
January 21, 2019 |