Is your primary column a formula field? Is there anyone else working inside your Airtable base that could have changed anything?
Is your primary column a formula field? Is there anyone else working inside your Airtable base that could have changed anything?
No. The primary field is just words.
There are three tables. We are a publishing company. The first table is for Author data, and the primary field is their last name. The second table is for Books, and the primary field is just words again – a column called CODE – just one word so, at a glance, we can spot which book we want to work with. The third table is for a style guide form. Its primary field is also the same CODE word that is the primary field in the Book table.
I have all the authors and their pertinent info entered into the Authors table. Same with the Books. I have been attempting to figure out how to get the fields-in-common to auto-populate – so far, I can only link field by field, but it seems there should be a way to tell the tables to pull in-common fields from each other. I’m still learning this.
But I wasn’t really doing anything to do with this at the time the glitch occurred. I was in the Books table and all of a sudden, the screen flashed, and a bunch of the book titles suddenly showed up on additional lines in the table – but in the CODE field, not the TITLE field. I don’t think anything has overwritten, but they are interspersed all through the table, between the records that were already there.
No one is working in the base but me.