Create a date filter in Table B based on the date in Table A

[Tanveer_Hundal]

Hi folks.

I am trying to use canvas columns right now to create a weekly view of updates for the week.

I have the table above (Table A) which is the master table to view and another table (Table B) which has all our updates.

**My question: how can I add a filter to Table B so that when creating a view, it is filtered for the date in Table A’s “Date of Review”. **

Link to this coda is here: https://coda.io/d/_dM4iLhk2M3w/Testing-Coda_suu4p

[Scott_Collier-Weir]

Do you want to filter it by both area of business and date?

Or just by date

[Tanveer_Hundal]

@Scott_Collier-Weir By both! Area of business is easier because that is in Table B. We will be having new rows created in Table A every week so filtering for it by a specific row is where I am hitting a block.