I’m looking for a way that site users, when logged in, can save or bookmark specific rows.
I assume this could be done through creating a column that links the user table with the target table and then including a checkbox in the item’s detail page that can be checked and unchecked by the user if they want to save it.
Multiple users have to be able to have different rows saved; is it possible to have a user-specific input like this, or will whatever they submit overwrite whatever is in that linked column?
Please advise on the best way to set this up.
You are spot on with your assessment. Unfortuantely, you cannot add a record to a linked table, it would simply overwrite it.
Yeah, I couldn’t make it happen the way I had it set up.
I did figure something else out though that seems to be working.
I will try to explain through the use case, which is a website that allows logged in users to bookmark books to save to a list.
The easy solution was to create a table that connects the user table with the books table. It has columns for each table links, lookup columns for row IDs, a “last modified” column, and a rating column with just 1 flag (either it’s flagged or not). The label column is a formula that combines the book row ID with the user ID into one number string.
On the book details page I had to add 2 buttons - one to create a record in the Bookmarked Books table with the flag added; and another button to remove the bookmark.
That was the easy part.
I needed a way to show whether the currently viewed book was already bookmarked, so I added a single flag rating (not input) and had to experiment with how to show the current user’s flag status without an error message appearing upon the page load if the book wasn’t currently flagged by the user.
-I had to setup a data source for the page as follows:
list multiple rows, local baserow, bookmarked books table, no filters, with search parameter parameter>ID User>ID (these combined were the label for each row)
-The flag rating value setup to show data source>book-user bookmark>-0>bookmarked (IE, the first row in a list)
It’s possible I missed something and it’s still not going to work once I really try to use it but for now it seems to be doing the trick.