# Linked objects representation :\[Sep 30\]

**URL:** <https://community.nocodb.com/t/linked-objects-representation-sep-30/114>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114 "2022-11-03T07:31:18Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/1 "2022-11-03T07:31:18Z")

</div>

> 🙋‍♂️ **hell\_io** _asked_

## Got a problem with ‘invisible’ links to another table. The column looks empty, though if I expand a concrete cell I can see a list of related rows. Maybe it has something to do with custom id column

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/2 "2022-11-03T07:31:19Z")

</div>

> 🙋‍♂️ **elephantum** _replied_

#### 

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/94483f8891a26ca22b4472e0849d0f3ca5bf6a28.png)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/3 "2022-11-03T07:31:20Z")

</div>

> 🙋‍♂️ **elephantum** _replied_

#### 

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/e0178073da41aca720a2b827d5ff350a7f587d00.png)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/4 "2022-11-03T07:31:21Z")

</div>

> 💁 **o1lab** _replied_

#### We automatically choose a primary value column for the linkToAnoterRecord

#### 

#### Could you please check if tehre is an empty column in another table

#### 

#### If so, please select some other column as primary value column - this can be done by hovering on column header. And then you can come and refresh the page

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/5 "2022-11-03T07:31:22Z")

</div>

> 🙋‍♂️ **hell\_io** _replied_

#### The primary value column is not empty, every row has a value and it’s a text ID (non-null, pk). Renaming column from custom name to “id” doesn’t help, unfortunately

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/6 "2022-11-03T07:31:24Z")

</div>

> 🙋‍♂️ **hell\_io** _replied_

#### There’s another interesting problem, you can see it in the first pic, the right column. The values are all the same and don’t make sense cause the primary values in the related table are text IDs as well

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/7 "2022-11-03T07:31:25Z")

</div>

> 🙋‍♂️ **elephantum** _replied_

#### Selecting primary value does not help, just tried it couple of times. 😦

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/8 "2022-11-03T07:31:26Z")

</div>

> 🙋‍♂️ **elephantum** _replied_

#### Right column of data looks like unix timestamp, actually

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/9 "2022-11-03T07:31:28Z")

</div>

> 💁 **o1lab** _replied_

#### possible to do a quick zoom ?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/10 "2022-11-03T07:31:29Z")

</div>

> 💁 **o1lab** _replied_

#### will help see the problem quick

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/11 "2022-11-03T07:31:30Z")

</div>

> 🙋‍♂️ **elephantum** _replied_

#### hell\_io@discord up to you

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/12 "2022-11-03T07:31:31Z")

</div>

> 💁 **o1lab** _replied_

#### can u please paste the project info (from top right menu)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/13 "2022-11-03T07:31:32Z")

</div>

> 🙋‍♂️ **elephantum** _replied_

#### Node: **v12.22.1**

#### Arch: **x64**

#### Platform: **linux**

#### Docker: **false**

#### Database: **pg**

#### ProjectOnRootDB: **true**

#### RootDB: **pg**

#### PackageVersion: **0.11.29**

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/14 "2022-11-03T07:31:33Z")

</div>

> 🙋‍♂️ **elephantum** _replied_

#### \> Docker: false

#### is not true, we run nocodb in docker in k8s

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/15 "2022-11-03T07:31:35Z")

</div>

> 🙋‍♂️ **hell\_io** _replied_

#### we might have figured out, that we just shouldn’t write rows to the database directly, but only via API. Maybe It’s kinda obvious

#### 

#### So for now I’m gonna try and insert data correctly, and if doesn’t work out - let’s zoom then

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/16 "2022-11-03T07:31:36Z")

</div>

> 💁 **o1lab** _replied_

#### ohok

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/17 "2022-11-03T07:31:37Z")

</div>

> 💁 **o1lab** _replied_

#### ok

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/18 "2022-11-03T07:31:38Z")

</div>

> 💁 **o1lab** _replied_

#### writing rows is fine - we just read the rows

#### however, if you are changing schema - then it has to be synced

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/19 "2022-11-03T07:31:40Z")

</div>

> 💁 **o1lab** _replied_

#### [https://docs.nocodb.com/setup-and-usages/sync-schema](https://docs.nocodb.com/setup-and-usages/sync-schema)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:31am UTC](https://community.nocodb.com/t/linked-objects-representation-sep-30/114/20 "2022-11-03T07:31:41Z")

</div>

> 💁 **o1lab** _replied_

#### caution : although this will break things related to schema migrations from env to another

#

[Next page](https://community.nocodb.com/t/linked-objects-representation-sep-30/114.md?page=2)
