To reduce the risk of accidental or unauthorized deletions, you can configure a table so that records cannot be removed unless the user has a specific keyword. This adds a safeguard while still allowing approved users to proceed when necessary.
Follow the steps below to apply this configuration:
Navigate to the Vehicles table and select the three-dot menu in the upper-right corner, then choose Show details:
Click Table Schema:
Make the following updates on Table Schema:
Change No delete to No
Add the appropriate user keyword to Required keyword to override Delete where
Add the condition
VEHICLE_ID_FW IS NOT NULLto No delete where
With this setup, if a user without the required keyword tries to delete a record, they will first see a confirmation prompt:
If they click OK, a second message will appear confirming that they cannot delete the record:
