Hi Gavin,
I have done something similar by creating a view that has a filter ‘Where {date of advert} is today’. Of course, this will only give you the list of adverts for today, but you can use an Airtable automation/Zapier/Integromat to create a snapshot. For instance, my automation is triggered at midnight (since at that time the view will ‘receive’ ‘new’ records) and copies all relevant records to a new table (which is my task list for that day). As an alternative, you could also let people use the actual view itself (or create an e-mail that contains the list of adverts for the day, for that matter).
Now, the above is only interesting if you are talking about daily publication in the sense that the required list is also ‘published’ daily to your sales people and only viewed on that particular day. In all other cases, I assume the sales team would need an overview of all publication dates and issues. In that case, I agree with Scott. You could also consider using a calendar view. Using a block or Airtable-to-site, though possible, sounds to me like an unnecessarily complex approach.
I have to say, though, that your use case can be interpreted in several ways, so I have made some assumptions in my reply. If these suggestions are not suitable to your situation, it could be useful if you would elaborate on how the sales people actually do their work. What is the sequence of the steps taken? Are they approached by phone at any given time to promptly make an advert booking, or do they first collect all advert requests and have a fixed timeslot in which to disperse all adverts over several issues? Which information do they need to see to be able to match an advert with issue?
