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+1) | ||||
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 |