How to Use WPS Last Modified Time on Android

Use Last Modified Time with 4 how-to topics, all available without membership; start from the index to add the field, review auto-filled timestamps, compare field types, and sort or calculate with time values.

How-to Index

How-to Guide

1. Add a Last Modified Time field

Entry: Tap a table header → Edit → Field Type → Last Modified Time

1. Tap the table header you want to configure.
2. In the floating toolbar, tap Edit.
3. In the field editing window, tap Field Type.
4. Select Last Modified Time.
5. Set the field name, then confirm to finish.

Success Criteria

• Interface result: A new Last Modified Time column appears in the table.
• What you can do next: You can continue editing records and watch the field update.

Tips While Using

• The field value is filled in by the system and does not need manual input.
• You need to open an editable data table before the field editing entry is available.

2. Check the auto-filled timestamp

Entry: Edit any record in a table that already includes the field

1. Make sure the table already has a Last Modified Time field.
2. Open any record and edit it.
3. Save the change or finish the edit.
4. Return to the table and check the updated timestamp for that record.

Success Criteria

• Interface result: The edited record shows the latest edit time in the Last Modified Time field.
• What you can do next: You can edit other records and compare their updated times.

Tips While Using

• This is a system-generated field, so you do not enter the time manually.
• If a record is only viewed and not edited, the timestamp does not refresh just from browsing.

3. Compare time fields and date fields

Entry: Open the Field Type selection screen

1. Open the header editing screen and enter Field Type.
2. Review the options for Last Modified Time and date-related fields.
3. Select Last Modified Time when you need the latest edit moment for a record.
4. Select a date field when you need calendar dates or a manually set date, and enable time display if needed.

Success Criteria

• Interface result: You know which field type fits the current business scenario.
• What you can do next: You can create the right field for your table design.

Tips While Using

• Time-focused fields are more suitable when hours, minutes, and seconds matter.
• If you need both date and time, choose the date field settings that fit your table design.

4. Sort by time or use it in formulas

Entry: Open table sorting or formula-related settings

1. Make sure the table already includes a Last Modified Time field.
2. Choose that field as the sorting basis in the sort settings.
3. Set ascending or descending order as needed and review the record order.
4. If you need time-gap calculations, reference the field in a formula.

Success Criteria

• Interface result: Records can be sorted by edit time, or the field can return time-based calculation results in formulas.
• What you can do next: You can continue filtering, counting, or tracking update frequency.

Tips While Using

• The field supports chronological sorting.
• The field can be used in formulas for time-difference scenarios.