Collection association: Select target field that is displayed in dropdown

Hi,

I have 2 collections, clients and invoices. Each client can have many invoices, therefore I create a field “clientId” in the invoices collection and a Many-To-One relation called “client”.

But when adding a new invoice, all I can select is the client’s ID. I want to be shown their name field in the dropdown instead, but cannot see how to do this in Nocobase. Any suggestion?

Regards

En la Configuracion de la colección en el título a mostrar, selecciona el nombre del cliente, ya que por defecto está el ID

This didn’t work for me, however opening the UI Editor, in the relation select field itself I was able to set the “Title Field” to the desired field in the target collection.

1 Like

Esa es otra solución pero si haces otros campos similares tendrías que hacer la misma configuración en cada campo, pero si la haces desde la colección en los nuevos campos creados ya mantendrá el título definido en la colección

In the form, set the properties of the Many-To-One field: Title, and change id to name.