I can’t reproduce that; can you post screenshots or a screen recording of what you are doing and seeing? Alternatively, a step-by-step instruction (including every step), and I’ll try again.
Then, I opened a new blank record, but the bug also happens when just coming back to table view. Here, I went back to table view without entering any information in the new blank record:
May I chime in with the remark that this kind of data is best kept in a real database? Ninox comes to mind as a cheap product, FileMaker in the expensive end, Airtable… There are probably a lot out there.
Rationale: books and their authors are relations. One would use one table for books (title, # pages, year of publication…), one for the authors (first name, last name, dob, …) and maybe one for the publisher (name, location etc). The book table would then contain the id of the publisher (its record #), not its name. Similarly, a fourth table would combine book and author ids. That
prevents repetition of data
prevents typos because of the repetition
allows for an arbitrary number of authors for each book: no need to n reserve there columns, when in most cases only one is needed. And no problem, if a book has for authors.
and most importantly: permits arbitrarily complex queries. Like all books written by a, published by b, in year c.
Sheets are ok for many things. Relational data is not one of them.
@BLUEFROG
Yes, I guessed so. I am loosely following ISO 690 format, but as @chrillek pointed out, yes, this is database stuff. Now, isn’t DEVONthink a database program?
I wanted to learn DEVONthink progressively to, in the end, have this rationale built, especially since many books with have their own article with summary, comments, etc., where the relations would really matter. I would even add the digital version, because I like to keep both printed and digital versions of all my books (printed because it is way better to read, digital for the ease of research and the power of relations building).
Yes, but it is not a relational database. Loosely spoken, it’s a program to manage unstructured data.
Regardless of DT: a sheet in Numbers, LibreOffice or Excel would not be any better
In fact, it’s the sheet approach that is not particularly well suited for relational data.
On the other hand, relational databases are not particularly good in handling large blobs of unstructured data like digital books, photos etc.
So a combined approach might work best: have the data in a database with a reference to the book/picture. These can be stored in the filesystem or in DT. On the other hand, DT could store a reference to the database record, perhaps as a link or id in the user meta data.
But this would probably only be worthwhile for a large(r) amount of books. And if you need the search functions I alluded to before. Otherwise – a sheet might be the best compromise. Instead of using three identically named columns, you could have just one „auteurs“, with the names separated by semicolon or comma or slash…
Thanks very much for the detailed instructions; I can confirm the behaviour you are describing; Jim’s response and my quick experiment would suggest that the identical column names are responsible. I guess the quick workaround would be for you to rename the columns “Auteur un”, “Auteur deux”, “Auteur trois” or some such.
Still sounds like a bug to me, though - i.e. if providing the columns with identical names leads to interactions such as these, then I think I would expect DT to inhibit you from doing so. It’s not uncommon though - if you’ve ever designed forms in Acrobat or similar and used any for of duplication, you might well have been in for a surprise when you thought you had finished. Not that I’m blaming Adobe for that - after the fact it’s all pretty obvious…
I guess that sums it up: I am not DEVONthink material.
Not that DEVONthink is a bad app, definitely NOT. It’s really impressive. But, just, as @chrillek summarized it, what I want to achieve doesn’t seem to really be what DEVONthink is for. Or any application, in fact, so I will go back to relying on my sole brain.