Dropdown field - Use a another field than the unique ID of the linked table

Ask the community
1

Hello,

Here is my case:
I have 4 tables: “Coches”, “Coachees”, “Objectives”, “Actions”
Each table use an incremental ID as the unique identifier (E.g. 1, 2, 3 etc.)
Objectives are created for Coachees
Actions can be created independently of the objective
Actions are eventually assigned to Objectives

When I edit an objective via a, “Edit” button in a item details page, in the field “Actions” I see the unique identifier numbers which obviously is not user-friendly.

I would like to be able to display in the dropdown field the “Name” of the action which is another field of my “Actions” table, so that the user can assign actions using this field rather than the unique ID.

Is there a way to do that?

2

Hey, could you please provide more insights on exactly what kind of field you are using with the dropdown field and which data source you are using there? Additionally, for quicker responses, you can use the live chat, which you can find in the studio at the location mentioned in the screenshot.

image
image3328×1890 459 KB

3

Thanks Adamo for your answer

I’m using Airtable and the dropdown field use the unique identifier which is a an autonumber format.

4

We have exactly the same issue. In short: we want to display the second or third column in the dropdown but it always uses the first. Is there any way to accomplish that?