How to prevent users from changing a cell in Dynamic View
Hi ,
I have a sheet with some data; users need to populate some cells with additional data. How can I prevent them from modifying the existing data?
Best Answer
-
Hello! Here are two solutions depending on your use case:
- You can click on a field shown in the detains panel and change the field properties to read only if you want to prevent edits to an entire column.
2. Alternatively, if you'd like a field to be editable up until specific data is entered into a field, you can go into the logic tab and freeze key fields when specific criteria are met.
Hope this helps!
Answers
-
Hello! Here are two solutions depending on your use case:
- You can click on a field shown in the detains panel and change the field properties to read only if you want to prevent edits to an entire column.
2. Alternatively, if you'd like a field to be editable up until specific data is entered into a field, you can go into the logic tab and freeze key fields when specific criteria are met.
Hope this helps!
-
@Almonto1 Thank you! I actually would like to freeze a row, not a column/field. Is there a way to prevent users from changing data in a row?
-
You would need to leverage the logic and basically set all fields to read only when the certain conditions are met.
-
@Paul Newcome can you please give me an example?
-
Oh!! I see… thank you both @Paul Newcome @Almonto1 !!!
-
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.6K Get Help
- 435 Global Discussions
- 152 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- Hey! This automation was working fine - but now that I've ensured that as i look to leave the company we have better owners, i can't select this sheet. They're in 2 workspaces, which wasn't a problem …
- Under the User Subscription Model, can internal collaborators designated as viewers (not members or guests), enter data into a dynamic view? Our group is still on the Legacy Collaborator Model and use…
- I've set up a archiving workflow using an archive checkbox column in our intake sheet through our blueprint. When this criteria is met, the project is supposed to be moved into an archive workspace, t…
