Hello Baserow team,
Problem
My use case is that:
- I had created two tables in my database, one called “BOOKS” and another called “WRITERS”.
- The “BOOKS” table stores bibliography records, including fields like author(s), publisher, ISBN number, etc., while the “WRITERS” table stores personal profiles, including fields like biography information, published works, etc.
- The “author(s)” field in the “BOOKS” table is a link to table “WRITERS”; the “published works” field in the “WRITERS” table is a link to table “BOOKS”.
My problem under this use case is that, when I try to add an entry for a new book written by an unfamiliar writer (i.e. not yet existed in the “WRITER” table), what I have to do is to establish two incomplete entries (= rows) separately and manually: one in “BOOKS” (for the sake of elaboration, let’s assume this entry is On Liberty) and another one in “WRITERS” (J.S. Mill), then I have to edit these two entries to link them together.
Idea
I hope that, I can establish a new entry in the table “WRITERS” when I edit the field “author(s)” of the entry On Liberty in the table “BOOKS”, and name the newly created entry of “WRITERS” J.S. Mill, as the “author(s)” field is actually a “link to table (WRITERS)”.
By adding this feature, I can finish the creation of entry On Liberty uninterruptedly, make sure that the link (BOOKS → WRITERS) is established properly, and there would be a proper entry (row) in the “WRITERS” table so that I do not need to create from scratch.
Reference
This is an existing feature in Airtable. I hope that similar feature can be introduced in Baserow as well.