I want the input from each user to be private to them so I enabled row owner in all tables, but I also want to have some data visible by all when they first use the app. A bit like a template so they can see what kind of input they can add. How can i do that? If i put no row owner, no one sees the content.
You can’t have both in the same table.
My suggestion would be to make a copy of the table without row owners applied, and add some sample data to that.
Create a table with no row owners set in any columns. It will be visible to all. This is where you put your “for everyone to see” information.
Think of Row Owners as a security feature, not a filtering tool. Use filtering and relations to limit what users see and only use Row Owners if there is sensitive data you don’t want a hacker-type to dig through to find (which isn’t easy, btw).
Buuut, if you are using Row Owners you can add a second column to help with visibility. I will use a “Role” column in the data tables and with each new record add in the role that can see all rows, such as “Admin”.