Plan Availability | All plan types |
Permissions |
|
Platform(s) | Web/Browser, Mac app, and Windows app (with some additional limited support on mobile) |
Adding created time fields in Airtable
The created time field type automatically shows a record's creation date and time—applicable to manually created records and records created via form submissions, APIs, and other integrations. Like the date field, you can customize the date format, include a time stamp, and use the same time zone for all collaborators. To add a created time field:
Visit your Airtable homepage.
Create or open your preferred base.
Add or edit a field.
Search for and select Created time.
From here you can can select the date format, opt to include the local time, use the same time zone for all collaborators, and display the time zone.
Adding created by fields in Airtable
The created by field automatically shows which collaborator created a record within the base. To add a created by field:
Visit your Airtable homepage.
Create or open your preferred base.
Add or edit a field.
Search for and select Created by.
Click Create field.
Note
Keep in mind that if a created by record shows the creator as "anonymous," the record was likely created through an anonymous form submission. By design, Airtable forms do not require respondents to sign in, so the Created by field cannot capture who submitted the form unless you collect that information separately.
FAQs
A created by field shows I created it, but I don't remember adding it to the base. What is likely the problem?
Any record created using your account information will show you as a collaborator. Suppose you have set up an integration using a personal access token, or authorized via OAuth. In that case, all records created from the integration will be associated with you. Additionally, the name of the personal access token or OAuth integration will be shown in the activity feed.
Why is there an empty created by record in my base?
When a created by record is empty, it indicates the record predates the created by feature. Records in your bases created before the created by field became available in June 2020 will return blank values.
My “Created by” field shows anonymous, how do I attribute form submissions to someone?
If you need to know who submitted a form, you have two options:
Add a name or email field to the form. Include a short text or email field in the form and ask respondents to enter their name or email address. The submitted value will appear in that field on every record.
Use a prefilled form URL. If you're sharing the form with known collaborators, you can pre-fill a hidden field with each person's identifier by generating a unique prefilled URL for each recipient. This keeps attribution automatic without requiring the respondent to type it in. For more on prefilling, see Prefilling Airtable forms.
There is no way to make the Created by field show a non-collaborator's identity—form submissions from public respondents will always appear as "anonymous" in that field.