# Formula to get row\_id from linked field without a lookup

**URL:** https://community.baserow.io/t/formula-to-get-row-id-from-linked-field-without-a-lookup/12844
**Category:** Feature Ideas
**Created:** [August 27, 2026, 1:08pm UTC](https://community.baserow.io/t/formula-to-get-row-id-from-linked-field-without-a-lookup/12844 "2026-08-27T13:08:37Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![360Creators](https://community.baserow.io/user_avatar/community.baserow.io/360creators/32/3827_2.png) [@360Creators](https://community.baserow.io/u/360Creators)
#### Post date: [August 27, 2026, 1:08pm UTC](https://community.baserow.io/t/formula-to-get-row-id-from-linked-field-without-a-lookup/12844/1 "2026-08-27T13:08:37Z")

</div>

It’d be great to have something working like this:

```auto
row_id(field('Linked Field'))

```

So that I don’t need to create a row\_id formula in that linked table and then needing to use a lookup field. Instead just having a single formula.

Would be nice

---

<div class="post-metadata">

### Author: ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [August 31, 2026, 10:15am UTC](https://community.baserow.io/t/formula-to-get-row-id-from-linked-field-without-a-lookup/12844/2 "2026-08-31T10:15:29Z")

</div>

Hey @360Creators, I’ve added it to the list of discussions. I’ll let you know once I’ve discussed it with the team. 🙂

---

<div class="post-metadata">

### Author: ![Mary-Lou](https://community.baserow.io/letter_avatar_proxy/v4/letter/m/4bbf92/32.png) [@Mary-Lou](https://community.baserow.io/u/Mary-Lou)
#### Post date: [September 2, 2026, 9:07am UTC](https://community.baserow.io/t/formula-to-get-row-id-from-linked-field-without-a-lookup/12844/3 "2026-09-02T09:07:47Z")

</div>

This may go hand in hand with [Enable sorting / filtering by row identifier](https://community.baserow.io/t/enable-sorting-filtering-by-row-identifier/11285) ?

---

<div class="post-metadata">

### Author: ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [October 16, 2026, 12:37pm UTC](https://community.baserow.io/t/formula-to-get-row-id-from-linked-field-without-a-lookup/12844/4 "2026-10-16T12:37:51Z")

</div>

Hey @360Creators, I have one question about this use case: if the linked field contains multiple records, should `row_id()` return the IDs of all linked records or just the first one?

---

<div class="post-metadata">

### Author: ![360Creators](https://community.baserow.io/user_avatar/community.baserow.io/360creators/32/3827_2.png) [@360Creators](https://community.baserow.io/u/360Creators)
#### Post date: [October 16, 2026, 2:11pm UTC](https://community.baserow.io/t/formula-to-get-row-id-from-linked-field-without-a-lookup/12844/5 "2026-10-16T14:11:35Z")

</div>

When `Allow multiple relationships`, then yes all linked records. If I would then want the first one, I would probably combine it with `first()`.