Display text of id from database

Hi,

Testing out 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.

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!

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

2 Likes

This could help you