Locking Dynamic View after a specific date
Hi,
Does Dynamic View offer the capability to lock the view after a specific date? I need users to make some data entries up until a specific date after which they should not be able to make or change any entries. However, they should be able to see their data.
Will locking the rows in the original sheet prevent users from changing their entries in the Dynamic View of that sheet?
Best Answer
-
Hi @User251
You can set Field Logic rules on the Details panel of the View to lock all of your other fields to be Read Only, based on a value in that row.
What I would suggest doing is set up a dropdown in your source sheet that contains a column formula checking your date and returning a specific text value (ex. "Past Date" or "Lock Row"). Then you can use this helper dropdown as the trigger for your Field logic:
See: Configure view conditions and sharing logic
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @User251
You can set Field Logic rules on the Details panel of the View to lock all of your other fields to be Read Only, based on a value in that row.
What I would suggest doing is set up a dropdown in your source sheet that contains a column formula checking your date and returning a specific text value (ex. "Past Date" or "Lock Row"). Then you can use this helper dropdown as the trigger for your Field logic:
See: Configure view conditions and sharing logic
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you so much @Genevieve P. for the helpful answer. It worked!
-
This is the same method I use. I wish the functionality would lock attachments too. Dynamic View users can still add attachments even after the logic lock setup.
-
@Genevieve P. I'm trying to apply the same logic to another dynamic view, but I'm unable to save it for some reason. I created a column in the sheet that changes to "locked view" after a certain date. However, when I try to add the fields that need to be come read-only in the in the dynamic view, I cannot save the logic. Any suggestions, please?
-
Hey @User251
Can you upload a screen capture of what you're seeing with the logic applied? (But please block any sensitive data.)
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. Just an FYI , the open Lock view field is hidden in the Details Panel
-
Hey @User251
Thanks so much for this image, it was really helpful!
All you need to do is name the logic (where it says "Rule #1"), then you'll be able to save it. 🙂
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. my bad! Thank you so much!!
-
No problem! Glad I could help
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives