Display the desired field

Hi @icos :wave:

It looks like your properties table is referencing the type table in Supabase. In WeWeb, your Properties collection is not fetching the type name but only the type id.

But you have the type names in the Type collection, so when binding info on an item from the Properties collection, you could use the lookup formula to look for the id of the type in the Type collection.

In the example below, I had a list of vehicles from a vehicles table with a reference to a location_id (2) from another table and used the lookup formula to get the name of that location from my locations collection:

Does that help?

1 Like