Item fields on Сategory page

At a glance

The community member is struggling with Baserow and needs help displaying the URL of elements in a category page. They have two tables: one with elements that have a URL and category, and another with categories that are connected to the elements. The community member was able to display the items in a category page, but couldn't display the URL because it's in another table.

In the comments, another community member suggests using a Lookup field, which the original poster says they have already solved by making two requests on the page: one for categories and one for items. The community member notes that they initially had an issue with the wrong operator, and needed to use "has_value_equal" for the Lookup field.

Useful resources

Lookup field

baserow.io

DDenis Kozeev

Hello everyone and happy new year 🎄
I need help, I'm struggling with Baserow for the second day.

I did the basic things shown in the video. But I still can’t solve the more complex ones.

I have:
1 table with elements they have before the field, for example URL and Category
2 table with categories, there is a field where the elements of this category are shown (the tables are connected through the category)

I created a category page and displayed the items in that category there. But I can’t display the URL of the elements because it is in another table.

I tried to add display of elements as we do on the page with filters, but I could not achieve the display of elements of only this category.

Please tell me how to implement this?

2 comments

JJohn Siciliano

This is probably what you need https://baserow.io/user-docs/lookup-field

DDenis Kozeev

I have currently solved this through the output of item. Now I have 2 requests on the page, categories and item (I don’t know if this is good or bad).

Item takes the slug field which I display in the table via Lookup and compares it with the category URL. Initially it didn’t work because the request was made by the wrong operator. For the Lookup field, you need to make a request using "has_value_equal".

It’s important who does it using GPT, he doesn’t know all the operators in baserow and I couldn’t solve the problem until I fed him all the documentation 😁

Add a reply

Join the Webstudio community

Item fields on Сategory page - Baserow

Lookup field