I've got database A with 1000's of records. I'd like to make a table that lists a subset of records from database A, along with some new properties. I can't just do a view, as this would add these new properties to database A, and the new properties are unique to this subset of items. It sounds simple: create database B and set up a relation to database A using a common key. In my case, the data for database B will be entered by hand. The twist is that the key names in database A are messy. I'd like to filter items in database A, copy the key names, and paste them into an empty database B to get started. When I do, though, I just get all the key names as one continuous piece of text in one entry. Is there a way to copy the names and paste them into a new DB as a series of entries?
Dropping the db A vs db B stuff, in this case, db A is thousands of citations from Zotero imported via Notero, resulting in a large db in Notion. When writing a paper or grant proposal, I like to take all the papers using deep learning for task X and make a new table about differences in methodology. Which papers used data from more than one source? What architecture did each paper use? Etc. These fields are only relevant to the current paper or grant proposal and not every paper in Zotero.
It also seems like the text names in Notion aren't the actual keys. They are just labels associated with the "real" keys, yet from the Notion relation examples, they seem to join based on the text. Is that correct? That seems dangerous. If one of the folks with a DB background and lots of Notion experience could share what they've figured out, that would be great to have in the forums.