Locking Dynamic View after a specific date


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

  • Genevieve P.
    Genevieve P. Employee Admin
    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