Dear AirTable,

I have a database question. (I use Airtable for other things and it works very well).

I send out articles from time to time, in PDF format. I am using an Excel spreadsheet to record who I send it to, when it was sent, and what article was sent. This is all so I don’t double up and send someone the same article.

I have looked at Airtable, but I can’t see a way of doing it.

This is what I need;

• A list of recipients


• A total number of recipients


• A list of articles


• A total number of articles


• A total number of all articles sent,


• A total number of articles sent per article


• The dates for each article sent

All of that info I have in the spreadsheet, but there’s only one date available for each recipient per article. For example, I can’t record more than one date for the same article going to the same recipient.

Another drawback is that adding a new article to the list, means adding two new columns, setting them up etc, etc, which is a bit time consuming. I’d love to be able to have it easier to add articles.

I would like to see a ‘report’ of;

• List of recipients and what articles they have been sent and on what date


• List of articles and who they have been sent to and on what date


• Chronological date list with who has received what article


• Searchable for dates, recipients, and articles

Any ideas?

The Excel Spreadsheet works, but it is cumbersome, and time consuming to add new articles.

Thank you!

I look forward to hearing from you.

Kind regards,

Stephen Whitwell

Tauranga

New Zealand

stephen@goodwords.nz