Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

"Created by" field type (or username called by formula)

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Paul_Teplitz
6 - Interface Innovator
6 - Interface Innovator

Hi there:

Part of how I use Airtable is as a CRM, and I am setting up a table that my staff can use to track customer interactions. We are interacting with hundreds of customers, and itโ€™s very useful to be able to know which staff member was involved in previous communications with a customer. Just like there is a โ€œcreated timeโ€ field type, it would be great to have a โ€œcreated byโ€ field type. Alternatively, a formula that returned the username of the active user would also be a potential solution.

Thanks,
Paul

42 Comments
Sam_Hell
4 - Data Explorer
4 - Data Explorer

Also need it! Can we get it? Should be fast and simple to code or?

Justin_Blum
4 - Data Explorer
4 - Data Explorer

+1 To add a โ€œDefault to Creatorโ€ switch to the collaborator field

Guido_Hoffmann
5 - Automation Enthusiast
5 - Automation Enthusiast

Definitely need this as well so +1.

In the meantime is there a way to pull the creator out of a record with the scripting block?

Eric_Petersen
7 - App Architect
7 - App Architect

The Record Revision History Activity often has the data we want to use. Has anyone figured out how to search and use this data (in a formula)?

Pedro_Miszewski
5 - Automation Enthusiast
5 - Automation Enthusiast

+1 for this feature!

Diane_F
4 - Data Explorer
4 - Data Explorer

+1 for this feature too!

Lisa_Lang
4 - Data Explorer
4 - Data Explorer

:thumbs_up: Cosign this feature.

ScottWorld
18 - Pluto
18 - Pluto

If you expand your record (click into a record and hit the space bar), the complete historical activity log for each record is right there โ€” including the creation date, creation time, creation name, and the complete editing history of every field: every modification date, every modification time, and every modification field โ€” including what the field was changed from and changed to. Itโ€™s pretty powerful. Iโ€™ve never seen such an in-depth log of changes before.

Granted, the creator name is visible in the activity log but it isnโ€™t available as a searchable field in your database, but now that we have the Javascript scripting block, I wonder if there is some Javascript access to the creator name. If so, you could run a Javascript script to pull the creator name from the activity log into your database.

But yes, in general, โ€œcreated byโ€ would be a great new field for Airtable to add.

vlado_vaco
4 - Data Explorer
4 - Data Explorer

Hi guys. We are deciding on subscribing for Airtable, but this feature is really important to us. Is there any plan to implement this?

Thank you for your reply.

best regards

ScottWorld
18 - Pluto
18 - Pluto

In the meantime, this would be a MANUAL PROCESS on your end, but you could always add a collaborator field to your system, and have your users select their own name from the list of collaborators whenever they create a new record. Obviously not what youโ€™re ultimately looking for, but could be a good stopgap measure.