Guide to Using Last Modified By Field Feature in DBSheet

Feature Summary

The Last Modified By field is used to automatically record the last modifier of each row record. It supports selecting "All Fields" or "Specified Fields" as the update trigger condition, suitable for scenarios such as responsibility tracing and change auditing.

Feature Description

Operation Steps

Create a New Last Modified By Field

Feature Entry
"+" button on the right side of the header → "Field Type" dropdown list → "Last Modified By" option

1. Click the "+" button on the right side of the header
2. Select the "Last Modified By" field from the pop-up field type list
3. Enter the field name and click "Confirm" to complete the creation

Set Update Scope

Feature Entry
Right-click "Field Title" → "Field Settings" → "Scope" option

1. Right-click the Last Modified By field title and select "Field Settings"
2. Select the field scope that triggers the update:
3. · "All Fields" : Modifying any field will update the modifier
4. · "Select Fields" : The modifier will be updated only when specified fields are modified

FAQ

Q1: What is the difference between the Last Modified By field and the Created By field?

• Solution: The Created By field records the user who first created the record, while the Last Modified By field records the user who last modified the record. The two can be used together to achieve complete operation tracing.

Q2: How to control which field modifications will update the Last Modified By field?

• Solution: Select "Select Fields" in the field settings, and then specify that the Last Modified By marker is updated only when certain fields are modified.

Notes

• The Last Modified By field is automatically recorded by the system and cannot be manually modified
• The update condition can be precisely controlled by setting the trigger scope
• Combined with the filter feature, you can quickly view all records modified by a specific person