Help

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

Link collaborator field to employee field in another table

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
ScottWorld
18 - Pluto
18 - Pluto

This isnโ€™t yet possible in Airtable because we can currently only link tables to tables (not fields to fields), but it would be really awesome if we could link a collaborator field (that IS NOT the primary field) in a โ€œProjectsโ€ table to a matching employee name (which IS the primary field) in an โ€œEmployeesโ€ table.

That way, we could get all the extra features & benefits of a collaborator field, while simultaneously getting all the features & benefits of a linked field. ๐Ÿ™‚

The workaround for now is pretty simple: We just have an extra field inside the Projects table which is the link to the employee table. (Only problem is that we now have 2 fields in Projects which have the exact same information in them.)

4 Comments
Jean_Roubas
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,
Thanks for bringing that topic up.
The other issue that I face with your workaround is that this extra field can be manually changed, contrary to a โ€œcreated byโ€ field that displays collaborators. If you have any suggestion to work around that too, Iโ€™d be keen on reading it !
Best

ScottWorld
18 - Pluto
18 - Pluto

If youโ€™re looking to create a field that editors canโ€™t change, just create a formula field.

Jean_Roubas
5 - Automation Enthusiast
5 - Automation Enthusiast

Unfortunately a formula field cannot link two tables

ScottWorld
18 - Pluto
18 - Pluto

Unfortunately, unlike other database systems, Airtable doesnโ€™t link tables based on field values. Airtable only links tables based on records. A linked field itself must always be editable, or else you canโ€™t link records. Airtable doesnโ€™t link based on field values.