Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Collaborator name fetch query

Solved
Jump to Solution
389 6
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there any option to directly fetch the collaborator name whoever is entering the record? I am using a shared base.

If the above thing is possible, is it also possible using forms?

Thank you in advance.

1 Solution

Accepted Solutions

Did you check out both the “Created By” and “Last Modified By” field types?

There is also a “User” field type as well.

See Solution in Thread

6 Replies 6

HI @mshah72,
Can you explain a little more on what you mean by Fetch the Collaborator?

A user does not need to be a record collaborator to enter a record. If you want to show the user’s name that updated a record, you can add a Last Modified By field to your table.

I want to insert a field in my base named Collaborator.
Now if there are 3 employees viz. Rose, Mary Cherry.
If Mary creates a record, Mary’s name should appear in the collaborator column automatically instead of Mary manually writing. Is there any way to achieve this?

Did you check out both the “Created By” and “Last Modified By” field types?

There is also a “User” field type as well.

Thanks a lot Scott. I never noticed that. But yes, it will help me a lot.
And I am not able to find the field type User. Do we need to separately enable that?
Is this thing also possible in a form?

You “User” field type might be named “Collaborator” — it seems like Airtable might be experimenting with different names for that field type.

Got it. Thanks a lot @ScottWorld.