Display records in between Start and End dates of another table

Hi, I need some help creating a formula.

I currently have the following set up:

Table1

  • Primary column = text
  • Start column = date
  • End column = date

Table2

  • Primary column = date
  • Notes column = text

In Table1, I’d like to display what Table2 records exist that are in between the Start and End dates for each Table1 record.

Any advice would be appreciated!

That is not possible in Airtable. You might be able to create a custom Javascript to do something like that for you. The same question was asked in this thread:

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.