Hi folks! New to coda and loving it so far, but been stuck trying to think through the same challenge for hours now…
Tl;dr - looking to make email view within table record filter dynamically by the email listed as a property of that record.
I’m trying to build a CRM-esque internal tool - the important feature of this being that I have a table with contacts (first name, last name, email) and, ideally, I’d like it to be the case that when I open a contacts record on the table, I am able to see all messages/emails to or from that specific contact. That said, I’m having lots of trouble doing this in a dynamic way where the “from” and “to” filters just pull from the contact email to auto-filter (as opposed to manually typing in the raw text email filter on within each new contact).
I also added columns MailAdressFrom and MailAdressTo, in lower case to make filter easier.
I’ve created a new table, where the Name Column is a select list from all mail adresses (From or To), so that you can select any people related to your inbox/sentbox. Of course, you should use your google contact database, and make a selectlist/lookup to this database. But be sure you can refer to the good adress mail in your inbox/send box for each people
