Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Base design
630 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Rose_Haft1
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!