I have a book borrowing app,
I have a table with the list of the books, and other fields such as UserID, Borrowing Date, Returning Date, and Status.
These last 4 fields’ records are updated through the app. And when a book is returned, I delete/change these records manually.
I also have a table with User information, such as name, email, phone number…
I want to create a table History where I can store a list of the books a user has already borrowed as well as the borrowing date for each.
Ideally, the history table would update automatically when a book is borrowed from the app and the table with all of the books is automatically updated. Also, it would keep the info even if the info in the book table is deleted because the book has been returned.
I am struggling to make it work on airtable, if any of you could give me a lead on what way to take to make it work, it would be awesome.
PS: Some screenshots of the different tables
book list table: