#Airtable change primary field free#

Airtable lets you create new views to serve a specific purpose. Sometimes, having all the articles in a single view is overwhelming. Here’s what the whole “AirtableKanban View” looks like:īecause Airtable keeps track of when articles move from one stage to another, we can look back and see where things are getting stuck in our process and how they change over time.

Promoted - At this point, the article is completely finished…until we decide to do a refresh.

This column holds articles that have been published but not yet promoted.

Published - We don’t promote content directly for our clients, but you should be.

Scheduled - Very few clients publish content the moment we hand it over to them, so each assignment enters the Airtable Scheduling stage until it goes live.

Typically, this involves some sub-steps (technical review, copy editing, revisions, etc.), but by the end, we should have a complete piece of content that’s ready to publish.

Editing - After a writer submits their first draft, the article enters editing.

Writing - Once the writer is confirmed and starts working on the assignment, we move it to this column.

Ready - At this stage, the assignment is defined, it has a due date, and we’re deciding who will write it.

We typically want to have a complete brief (see Part 1 above) before moving an assignment out of this column.

Preparing - Ideas and loose pitches that still need to be defined go here.

We typically use the following stages for each piece of content: Our Airtable“Kanban View” in the “Assignments” table helps you see exactly where each article is in the publishing process. We can also drag assignments around to move their due dates or rearrange them based on extenuating circumstances. Just navigate to the Airtable “Calendar View” in our “Assignments” table to see when articles will be published.īy color-coding each assignment, we can see which ones are on track and which ones might need extra attention to make sure they hit their due date. I wouldn’t recommend this approach, but the primary goal of a publishing calendar is just that. If you’re old-school and keep track of your calendar draft on a wall calendar at your office, you’ll probably just pencil in the names of each article on the date you plan to release them. Here are the key pieces to our Airtable schedule template: 1. Our Airtable calendar goes even further by allowing us to manage assignments, writer payments, and writer applications.ĬOPY OUR AIRTABLE EDITORIAL CALENDAR TEMPLATE HERE It lays out all the articles your team is working on along with their current status. What is an Airtable Editorial Calendar?Īn “editorial calendar,” “publishing calendar” or “content tracker” is the backbone of a robust content management process. In this post, I’ll show you the elements of our publishing calendar and give you access to a template of the publishing calendar we use at v to manage hundreds of pieces of content and dozens of writers simultaneously. In addition to integrations with third-party tools like Zapier, Airtable has apps, automations, and blocks that make the platform even more powerful.

#Airtable change primary field free#

To do so, create a formula column, and set the formula to RECORD_ID().Airtable is a free content management platform that gives you the power of a database with the ease of use of a spreadsheet. It is possible to see the record IDs that Airtable is using behind the scenes. That becomes especially important when you are linking related records.

The primary column provides an informal way to identify a record in a table. It’s A Way to Identify and Select Records

Therefore, it doesn’t meet the requirements that are necessary for it to serve as an alternate primary key. It’s also possible for multiple records to contain the same value. It’s entirely possible for a record to contain no value in the primary column. You might also think of the primary column is an alternate primary key. Airtable has its own internal record ID that is formatted as an alphanumeric ID, and its value is unique within each database. The real primary key is handled behind the scenes by Airtable. If you’re familiar with relational database terms, it might seem to you that the primary column is a table’s primary key - but it isn’t. This becomes particularly important when relating records. Its purpose is to give users a way to identify a record in the table. In this tech brief, you’ll learn what the primary column is, how it works, and why it is important.Įvery Airtable table includes a single primary column. The primary column (field) is a concept that many new Airtable users struggle with. This is a guest post courtesy of database design expert and author Tim Dietrich, an honorary Airtable MVP. An introduction to the primary column from Tim Dietrich