Add a display_name to improve foreign key visualization

[JonathanPicques]

Feature request

It could be nice to have a display_name for a linked field

Instead of that we could have

Is your feature request related to a problem? Please describe.

My use case is to hand a supabase account to a client and let them manage their coupons.
As they are not really tech-savyy, the interface is a bit cumbersome to work with when it comes to foreign keys

Describe the solution you'd like

The ability to set a display name somewhere when you set up a foreign key

[kiwicopple]

Hey @JonathanPicques - would a database view for your use-case?

Either way, we might end up doing something like this beyond a database view. I'm going to convert this to a Discussion, because it would be good to gather the community's feedback on this one too.

[JonathanPicques]

Hi @kiwicopple thanks for reaching out :)

It's a good solution for making an overview.

The real problem here is adding/updating these values, for instance the field partner.user_id is linked to auth.user.id and selecting an uid is not user-friendly, I'd rather select the user email in that case

[segheysens]

Love this idea, I agree that it would make updating related records in the Table view easier to use.

[woutersteven]

Seconding this, I believe it is done in PHPMyAdmin in the same way, it's very useful.