Hi! I have 2 tables in Supabase: Orders and Statuses. Statuses - is related to the Orders table (connected via the Status ID field).
In the Statuses table, in addition to the ID field, there is also the Status Name field. But the relationship I made exactly through the ID field (so necessary for technical features).
In Weweb there is a table of Order Collections (from Supabase), I also display the Order Status field. But now I can display only the ID of the status itself (as it is displayed in the Supabase table itself).
But I need to display the Status Name field instead of the ID. How can I do this? Is there any formula in the form of a query to the relationship table? I tried to do via the Lookup function, but it probably doesn’t work the way I intended. I fetch both tables from Supabase.
That is, I end up needing to display the Status Name in each row instead of the ID in the data table.
The Statuses table will have more fields going forward, such as Status Color, Status Background and possibly a number of other fields that will also need to be retrieved in individual situations in the frontend. If only the Status Name field was needed, there would be no particular problem getting the value of the Status Name field.
Please, help me!
