Formula Playground
Copy base
Report abuse
Views
Autonumber
Formula Reference
Description (from Formula Reference)
Type (from Formula Reference)
1
1
LAST_MODIFIED_TIME()

Returns the date and time of the most recent modification made by a user in a non-computed field in the table. If you only care about changes made to specific fields, you can include one or more field names, and the function will just return the date and time of the most recent change made to any of the specified fields.

Date and time functions
2
2
CREATED_TIME()

Returns the date and time a given record was created. 

Date and time functions
3
3
RECORD_ID()

Returns the ID of the current record.

Record functions
Drag to adjust the number of frozen columns
Example Status
LAST_MODIFIED_TIME([{field1},{field2}, ...])
LAST_MODIFIED_TIME() w/ Field
CREATED_TIME()
RECORD_ID()
Todo
6/10/2021
9:43pm
6/10/2021
9:43pm
6/7/2021
10:50pm
recNu5Hp5gmu38hVf
Done
6/10/2021
9:42pm
6/10/2021
9:42pm
6/10/2021
9:42pm
recFL18aQHwDFmz1B
6/10/2021
9:36pm
6/7/2021
10:50pm
recAMNDrETDslWlWx
3 records
  • All — use the below views to filter between examples!
  • LAST_MODIFIED_TIME()
  • CREATED_TIME()
  • RECORD_ID()
Extensions

Alert

Lorem ipsum
Okay