Good day everyone. What I’m trying to do is this. Have a table, table has lookup column with a dropdown list. Have a user friendly view of this table for others to see and use. But users can still use dropdown from the lookup column. It doesn’t change the data in the doc (have sharing settings set to view only), but trying to find a way to disable that being a dropdown or being able to change it at all in a view. Thanks.
If you have a certain tier of a paid plan you can enable locking and then change the locking permissions per page. Therefore, if you have access to locking, you can put the view of a table on its own specific page and set the locking permissions of that page to “Read Only”
Just ensure that you also set the unlocking permissions to “Only specific people can unlock” so that your users can’t unlock and then change the table!
Ok cool. Thanks for that.
You can accomplish this by creating another,
[New Column] in the table =
[Dropdown Column]. Then create a new view of the original table, hide
[Dropdown Column] and show
Oh yeah - for sure what @Johg_Ananda said. I might have misunderstood your question.
Any formulas are “read only” as they cant be changed. So you could totally go that route if you just want it viewed and then on another view of that same table you could actually have the editable lookup cells
If you are looking for actual read only, you would need to use locking - as any user could accidentally change the formulas in columns or delete columns entirely.