# Display text of id from database

**URL:** <https://community.weweb.io/t/display-text-of-id-from-database/2305>\
**Category:** How do I?\
**Tags:** binding, supabase\
**Created:** [April 14, 2023, 9:28pm UTC](https://community.weweb.io/t/display-text-of-id-from-database/2305 "2023-04-14T21:28:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kawwl](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/kawwl/32/14297_2.png) [@Kawwl](https://community.weweb.io/u/Kawwl)\
**Post date:** [April 14, 2023, 9:28pm UTC](https://community.weweb.io/t/display-text-of-id-from-database/2305/1 "2023-04-14T21:28:42Z")

</div>

Hi,

Testing out [weweb.io](http://weweb.io), looking great so far. I’ve decided to use Supabase for my first project. I’m pretty novice in both systems, so it is a learning curve. The reason for Supabase is that I at some point will check out their Realtime features.

I’ve been playing around for a few hours getting the feel of weweb. Currently trying to build a (bad) workout / lifting tracker. Not doing anything great with UX, it’s just to learn the ropes.

**How do I display a “text name” from another collection when I only have its id?**  
I have two tables that I need to display some information across. In one table i have exercises, in the other i have exWorkJunction (exerciseId+workoutId).

I am able to look up which exercise the ID has, and get the info.

 ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/d/d8dc1ed3284630c1b8bc8d2981cee7e397c89a92.png)

I am displaying all exWorkJunction in a collection list where workoutId = WorkoutId of the current window (modal)

However, i have no clue how to get the exName to display (i need to extract exName)  
I might have done this very complicated, but it seemed logical when drawing it out.

This got very confusing as i couldn’t add more images and the links were dead.

All help appreciated!

---

<div class="post-metadata">

**Author:** ![luka](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/luka/32/1571_2.png) [@luka](https://community.weweb.io/u/luka)\
**Post date:** [April 17, 2023, 1:15pm UTC](https://community.weweb.io/t/display-text-of-id-from-database/2305/2 "2023-04-17T13:15:10Z")

</div>

You can wrap your current formula with getKeyValue formula under Object, the lookup(…) will return a object and then you can type “exName” as a second parameter for the formula.

Alternatively you can just type “.exName” at the end of your current formula

---

<div class="post-metadata">

**Author:** ![visualdevs](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/visualdevs/32/6248_2.png) [@visualdevs](https://community.weweb.io/u/visualdevs)\
**Post date:** [June 9, 2023, 10:22pm UTC](https://community.weweb.io/t/display-text-of-id-from-database/2305/3 "2023-06-09T22:22:32Z")

</div>

This could help you

 ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/9/9fe6b41f2732bc2a1d99402736989cb033374257.png)