I have this table called last contact information where I try to find out which person I last contacted.
I’d like to see a report within the table that lets me filter by when I last had contact with people.
So I can run a report — “show me everyone that I haven’t contacted in the last 90 days” (or any other duration of days) and also see everyone who doesn’t have a date in their for last contact.
Date of contact).To include rows with blank dates in the filter, modify the table filter settings by adding this formula:
If(
[Date is blank],
thisRow.[Date of contact].Matches([Select Last Contact Information Date of contact]) OR thisRow.[Date of contact].IsBlank(),
thisRow.[Date of contact].Matches([Select Last Contact Information Date of contact])
)
Optionally, you can add a toggle control near the date filter to enable or disable this parameter.
For better organization, enable sorting to display records from the earliest to the latest dates. This will improve the readability of your data.
To make the data more visually appealing:
Today() - thisRow.[Date of contact]
In the clients table, you can add a calculated property, Last Contact, that determines the most recent contact date for each client. Apply similar conditional formatting as in the main table using the Days passed property.
For further reference, I have prepared a sample document that demonstrates these configurations. You can copy it to your workspace to explore the setup in detail.
By implementing these measures, you can:
I hope this information will be helpful to you! Wishing you success in Coda 
hi @Carlo_Cardenas ,
although I like the creative solution of @Tamerlan_PRO quite a bit (dding a column with day values), there is a shorter route I show below.
the date picker outputs two date values and we apply a filter relating to the first and last value (or min & max which are the same in this context).
thisRow.[date of contact] >= [date range 1].First() and
thisRow.[date of contact] <= [date range 1].Last()
@Tamerlan_PRO made many great comments worthwhile to follow!
cheers, Christiaan
What I find fascinating about Coda is the many different ways to get something done. a 3rd way would be to default new dates to say 1/1/1970, rather than leaving them blank.
If you would like customers never contacted, you would then filter for date = 1/1/970. But they will also be included in any search for customers not contacted in greater than x days.
P
Thank you so much, I’ll give this a try.
Thank you, Christiaan!
in this blog post you find the solution explained in greater detail:
enjoy, cheers, christiaan
@Carlo_Cardenas I highly recommend reading Christiaan’s blog! It’s a real treasure trove of valuable knowledge about Coda! And I recommend it to everyone who happens to see this message.
