How to roll-up to match dates in one row in one column to dates (1:many) in another table?

Topic Labels: Base design
132 1
Showing results for 
Search instead for 
Did you mean: 
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi - I am trying to do a daily balance and bills owed table and am wanting to match expected income so that the dates match. Ideally it would also have a daily exchange rate. 

I am just not sure how to match and roll-up based on varrying criteria without needing a new column for each date. 

How do I do this? Do I need a third table?

1 Reply 1

Hmm, yeah I think you'd need a new table where each record represented a single day:

Screenshot 2024-05-29 at 1.39.35 PM.png

Screenshot 2024-05-29 at 1.39.46 PM.png
And you could use automations to link the records appropriately.  Not entirely sure I understood your question though, sorry if I got something wrong!