Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Re: Collaborator name fetch query

Solved
Jump to Solution
1384 0
cancel
Showing results for 
Search instead for 
Did you mean: 
mshah72
6 - Interface Innovator
6 - Interface Innovator

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.

mshah72
6 - Interface Innovator
6 - Interface Innovator

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.

mshah72
6 - Interface Innovator
6 - Interface Innovator

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.

mshah72
6 - Interface Innovator
6 - Interface Innovator

Got it. Thanks a lot @ScottWorld.