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