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

[Paul_Teplitz]

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

[Sam_Hell]

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

[Justin_Blum]

+1 To add a “Default to Creator” switch to the collaborator field

[Guido_Hoffmann]

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]

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]

+1 for this feature!

[Diane_F]

+1 for this feature too!

[Lisa_Lang]

:thumbs_up: Cosign this feature.

[ScottWorld]

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]

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]

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.