Noob alert. I need to make certain records in a sheet open for everyone, while others remain restricted. I thought I could solve this with with multiple versions, but cannot figure it out. I need all the fields of certain records in one sheet to be open to everyone.
Thanks
Hi,
If you need to make certain records in the same sheet accessible to everyone, while keeping others restricted, you can achieve this by using multiple versions of the sheet. For example, if you have 10 records but want to make one specific record open to those who are not logged in, you can create a separate version of the form for “Everyone.” Then, apply a fixed filter to that version to display only the record you want to make public.
This way, you can control which records are accessible while keeping the others restricted.
I accomplish that by using access rights without having to created multiple versions. Hopes that helps.
how you did that?
Sheets are assigned to groups, to that groups you can give different access rights. I have hundreds of sheets that I created but if a user its under group Wolf they only see the records assigned to them because the in Access Rights for that sheet I set the setting as Survey User. Then in the record I included a field using select user, when a new record is created is assigned to a user. You can assigned multiple groups with different access rights to a sheet.