[Feature request] Ability to Lock View Settings for Specific Views to Prevent Auto-Save by Other Users

[promto-c]

Is your feature request related to a problem? Please describe.
When multiple users are in database editable mode within the same view, changes to view settings (filters, sorting, grouping, view options, etc.) are automatically saved for everyone. This can cause frustration when adjustments made by one user unintentionally affect the view for others, disrupting workflows or preferred configurations.

Describe the solution you'd like
Introduce a "Lock View Settings" feature that allows users to lock a specific view's configuration (filters, sorting, grouping, etc.) to prevent automatic saving of changes made by other users in the same view. Key details of this feature include:

1. While locked, users can still adjust view settings, but those changes will not be saved globally for everyone.
2. Provide indicators for locked views, such as:
   • Visual cues (e.g., a lock icon or a notification banner).
   • An option to reset changes to the original locked state using a [Reset] button.
   • Explicit options to [Save Changes Globally] or [Save as Personal View] for finalizing changes.

Describe alternatives you've considered

• Disabling auto-save entirely and requiring manual confirmation for all view changes. However, this approach could disrupt workflows where auto-save is useful.
• Duplicating views to create personal, non-shared versions. However, this isn't always practical because, in many cases, users may only need a temporary adjustment to filters or grouping for specific tasks but still want to reuse the original view without creating redundant versions.

Additional context
This feature would enhance collaboration by giving users control over shared views without impacting others' configurations.

For reference, the attached screenshot demonstrates similar functionality in Notion, where shared views allow temporary adjustments that don’t persist for all users unless explicitly saved. This type of flexibility could serve as an inspiration for implementation.