Filtering table entries by today()

[Pablo_DV]

Hi Joseph,

Welcome to the community!

It would be much easier to help you if you would share your doc.

Guide: How to share your doc with the Coda Community

TL;DR Guide (especially for new Coda-Users): How to share your doc with the Coda Community. Just copy and paste it into all topics where there is insufficient information. Long version: Hello folks, This is my first post in this category. I don’t think this post has much added value, but I decided to publish it here anyway. In the last months, I have often seen that new users, in particular, need help, but are not aware that it is extremely important for us to share their document, add a …

But anyway, here’s a couple of pointers:

• I would recommend you to try to minimize the number of tables, specially when the objects are so similar (in this case both are points).
  If I were you I would delete the second table and just add a ‘Type’ column in your original table with possible values Academic and Student. You won’t need to replicate all the common columns and formulas saving time and avoiding errors like the one you are experiencing.
• You don’t need to stack filter() formulas, it’s probably worse for performance and not as flexible as using AND or OR between conditions.

This is how the formula would look like if you follow my tips
Points.Filter(type=Academic AND Name=thisRow.Name AND Date=Today()).sum()

Let me know if this helps you,

Pablo