Create a template column in the Categories table, adding the signed-in user’s email.
Create a relation based on that template, back to the Users table where you store the emails.
When users click the Categories list, you set a column through the relation above, let’s call it “Category Choice”. Say I click “Groceries”, then the “Category Choice” column in my user profiles row will have the value “Groceries”.
Have an If Then Else column in the Categories table. If category name is the same as signed-in user’s “Category Choice” then “Selected”, else empty. Display that on the Category list, possibly as a tag, to let users know visually that their choice has been recorded.
Create an inline list on the Products table, filter by “Category Name” is signed-in user’s “Category Choice”.
Consider the rounded one is an inline list as category
And it is getting the products related to the category should display like the below one which is also an inline list.
My question is whether to display the products need one inline list or more inline list.
I am trying to do something similar but I am stuck on point three because list has no ‘Write To Option’ how do we set a column through the relation , When users click the Categories list?
You need to change the Item Click action on the collection to a Set Column action. Then when configuring that action, you can set the Row to the relation and you will see all of the related row’s columns where you can change values.