Please help! thanks in advance
I have a sheet that contains a list of books (like a database) that displays the list on a tab called “All Books”. I (the admin) will be maintaining the list of books. All users can see the list of books (i.e. no row owners).
I have a separate sheet called “My Books”, and a tab for it in the app. This tab is for users to see the books they have added only (i.e. row owners).
I want users to be able to scroll through “All Books”, click on a book, and have that book show up in “My Books”. Again, users should only see their own books on the My Books tab.
How can I accomplish this?