External Database : Display value of Links not show

order_custom is link to treatment table. I set display value of order_custom is order_id which is integer in PostgresDB. But when I open ticket of one random records in treatment table, it not show display value of link record of order_custom. However, I inspect network and see get data APIs, the value of link record order custom is show along with other columns.

Can you provide the relation between order_custom and treatment table.

It should be 1-1 relationship, how can I define this in Postgres for NocoDB to understand. As I read the document about Display Value, the value display shouldn’t be the number from primary key, but other columns as text. How can I set display value as order_id?

Find details here to update display value field

1 Like

Ok. That’s what I thought too. So here is my work around method. First, I need to create a formula and choose order_id column as value in that formula. Then I set display value to that formula column. Voila, we have a display value from link records as primary numeric key.

1 Like