I hope an Airtable wizard out there can help.
I have 12 tables - one named “Topics”, with a list of topics, and 11 tables of “Articles” (one per country I write about, which isn’t very handy but would be solved if Airtable finally did nested tables!), with a list of articles, which all have a field linked to “Topics”.
Here’s my problem. All topics have not been written out as articles in all countries. I need to see that from the “Articles” tables. At this moment, the only solution I’ve found is to create an article with a blank title ("-") and assign it to that topic in the linked field.
But I have hundreds of topics, and thousands of non-written articles, so it’s extremely time consuming to do it that way (and I am expanding to 40 countries, so it will soon be an impossible task).
I was wondering if there was a formula I could use in the title field (which is the primary field in “Articles”) that would automatically show an empty title (or “-”, whatever!) if there is no article for a particular topic from the Topic table.
Any solution outside the box is welcome too!
Thank you in advance for your help.