# Create a filterable array of record IDs

**URL:** <https://community.baserow.io/t/create-a-filterable-array-of-record-ids/2125>\
**Category:** Technical Help\
**Created:** [January 22, 2023, 4:59pm UTC](https://community.baserow.io/t/create-a-filterable-array-of-record-ids/2125 "2023-01-22T16:59:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bgschust](https://community.baserow.io/user_avatar/community.baserow.io/bgschust/32/1501_2.png) [@bgschust](https://community.baserow.io/u/bgschust)\
**Post date:** [January 22, 2023, 4:59pm UTC](https://community.baserow.io/t/create-a-filterable-array-of-record-ids/2125/1 "2023-01-22T16:59:09Z")

</div>

I have record IDs being looked up across several tables. So table B looks up the ID formula (row\_id()) from table A, and table C looks up the linked IDs from table B, but for some reason I cannot create a string with join() in order to make the field searchable in the API. However, it works with other fields.

---

<div class="post-metadata">

**Author:** ![nigel](https://community.baserow.io/user_avatar/community.baserow.io/nigel/32/51_2.png) [@nigel](https://community.baserow.io/u/nigel)\
**Post date:** [January 22, 2023, 6:56pm UTC](https://community.baserow.io/t/create-a-filterable-array-of-record-ids/2125/2 "2023-01-22T18:56:57Z")

</div>

@bgschust Can you provide the exact formula you are using? I’m able to join together a lookup of `row_id()` formulas using `join(totext(field('row id formula')), ',')`

---

<div class="post-metadata">

**Author:** ![bgschust](https://community.baserow.io/user_avatar/community.baserow.io/bgschust/32/1501_2.png) [@bgschust](https://community.baserow.io/u/bgschust)\
**Post date:** [January 22, 2023, 7:53pm UTC](https://community.baserow.io/t/create-a-filterable-array-of-record-ids/2125/3 "2023-01-22T19:53:19Z")

</div>

Thank you! I was missing totext().