Use Last Modified Time with 4 how-to topics on iOS tables; 4 topics are available without membership and 0 are membership-related.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Add a Last Modified Time field | Free |
| 2 | 2. Check automatic timestamp updates | Free |
| 3 | 3. Sort records by Last Modified Time | Free |
| 4 | 4. Use the field in time-based calculations | Free |
How-to Guide
1. Add a Last Modified Time field
Entry: Tap the column header → Edit → Field Type → Last Modified Time
- Tap the header where you want to add the field.
- In the floating toolbar, tap Edit.
- In the field editing window, tap Field Type.
- Select Last Modified Time.
- Set the field name, then confirm to create it.
- After creation, the field is filled automatically by the system.
Success Criteria
- On-screen result: A new Last Modified Time column appears in the table.
- Next action available: You can continue editing records and observe time changes.
Tips While Using
- Common mistake: Do not try to type values into this field manually because the system maintains it automatically.
- Environment note: You need permission to edit fields.
2. Check automatic timestamp updates
Entry: Open a table that already contains the Last Modified Time field
- Open a table where the Last Modified Time field has already been added.
- Edit any record with editable content.
- Return to that record row and check the Last Modified Time field.
- Confirm that the field now shows the latest edit time.
Success Criteria
- On-screen result: The Last Modified Time value for the edited record refreshes.
- Next action available: You can edit other records and repeat the check.
Tips While Using
- Common mistake: If you only view a record without changing content, the timestamp does not refresh.
- Environment note: In collaborative scenarios, keep the network connection stable so the latest result can sync.
3. Sort records by Last Modified Time
Entry: Use the sort option in a table that contains the Last Modified Time field
- Open a table that already includes the Last Modified Time field.
- Open the sorting option for the table.
- Set Last Modified Time as the sort field.
- Choose ascending or descending order.
- Review the sorted results to find recently updated or earlier updated records.
Success Criteria
- On-screen result: Records are reordered by Last Modified Time.
- Next action available: You can continue filtering or reviewing target records.
Tips While Using
- Common mistake: Before sorting, confirm that the field has been created successfully and already contains time values.
4. Use the field in time-based calculations
Entry: Reference the time field in a table that needs time-difference analysis
- Open a table that contains the Last Modified Time field.
- Create or open the field or scenario where time-related calculation is needed.
- Select Last Modified Time as the time reference value.
- Complete the required time-difference or interval calculation.
- Save the setup and check whether the result matches your expectation.
Success Criteria
- On-screen result: The related calculation result displays normally.
- Next action available: You can continue adjusting records and observing result changes.
Tips While Using
- Common mistake: Confirm that the participating field format matches the time-based scenario before calculation.