Four fields keep track of a record's history: Created on, Created by, Last edited on, and Last edited by. They are meant to help you see at a glance when a record was made and who touched it last, for example to spot leads nobody has updated recently.
Note:
People can't edit these fields. Tape sets the values automatically.
Add them to the layout to see them. The fields only show on records and in views after you add them.
Who can use these fields?
These fields are available on all plans: Free, Plus, and Premium. See what each plan includes on our pricing page.
To add or change a field, you need
Full accessto the database app and a desktop or tablet.
Add the fields
Open the database app, open the app menu, and select
Customize record layout.Click
+or type/in a text block.Under
New field, scroll down and selectCreated on,Last edited on,Created by, orLast edited by.
What the fields show
Created on: the date and time a record was created.Created by: the person who created the record.Last edited on: the date and time a record was last edited.Last edited by: the person who edited the record last.
When a person didn't make the change, Created by and Last edited by show where it came from instead:
Automation: an automation created or changed the record.Form: the record came in through a form.Email: the record was created by email. Learn more about creating records by email →
Change how the fields look
In Edit field display, the date fields offer Date format and Time format for one layout. Learn more about field display →
Created by and Last edited by offer:
Chip style:DefaultorAvatar only, which shows just the profile picture.Size:Default,Large, orExtra large.
Use the fields
Filter or sort a view by
Last edited onto find records nobody has touched for a while. Learn more about sorting and grouping views →Use
Created on,Last edited on, orLast edited byin a calculation, for example to count the days since a record was created.Created byisn't available in calculations. Learn more about calculation syntax →
FAQs
Can I change the creation date of a record?
Can I change the creation date of a record?
No. Created on is set when the record is created and can't be edited.
Does a comment change Last edited on?
Does a comment change Last edited on?
No. Last edited on and Last edited by change when someone changes a field value of the record. Deleting or restoring the record updates Last edited on only. Comments and new results of calculation fields don't change them.
Can I use these fields in a view?
Can I use these fields in a view?
Yes. Views can show, filter, and sort by these fields. Learn more about views →
Do records I imported have a Created on date?
Do records I imported have a Created on date?
Yes, they show the date and time of the import. You can't set Created on from a file. To keep an original date, import it into a separate Date field. Learn more about importing data →
Can I hide these fields from some people?
Can I hide these fields from some people?
Yes, with field access. Field access is only available on the Premium Plan. Learn more about field access →
Can I see every change, not only the last one?
Can I see every change, not only the last one?
Yes, in the record activity. Last edited on and Last edited by only show the latest change, while the Activity tab lists every change with its author. Learn more about record activity →
Are there other field types?
Are there other field types?
Yes! Database apps have fields for text, numbers, dates, members, files, relations, calculations, and more. See every field type in Intro to fields →
Still have more questions? Find answers and get help from community experts in the Tape community →.
