Hi @DN1 - unfortunately, you can’t do this. Not all field types are available for selection on the primary field of a table. Generally, it is good practice to make the primary field unique if you can and although Airtable does not enforce this 100%, I guess they are trying to remove the obvioiusly non-unique field types like single selects for the primary field.

Hi Jonathan


Thanks.


I tried a work around and shifted between columns in the original Excel file I uploaded so that I can convert the relevant column into a single select. however, itstead of using “column A” in my Excel sheet as the unique field, they added an extra column with no values so it still doesn´t solve my problem (see image). Any idea how to solve that? In this case, I would like the Media Outlet column to become the unique column on the far left.


Thanks!

I think this is because the primary field is set to a number so if you try to import a string (media outlet) into that it won’t be accepted.

Change the primary field to single line text and copy and paste the media outlet values into it (or try running the import again).

Thank you Jonathan! Yes, that worked!