I have connected WS with Baserow. Imagine in Baserow there are tables "Categories" and "Subcategories" that are linked each other. "Categories" have a lookup field that shows the array of "Subcategories"
On WS I am getting the "Caregories" and I want to show the "Subcategories" for each "Category". I can get that array field but it only returns the lookup value (e.g. name of "Subcategory") and the "Subcategory" ID.
My goal is to also get the slug of that "Subcategory". I see two ways solving this:
- Create another lookup field that displays the "Slugs" array for the "Subcategories". The problem is that I cannot find a way to iterate in WS (e.g. getting an index and display the values from those two fields based on the index)
- Create a string field in Baserow combing the two fields with a separator, e.g. "{category_name} | {category_slug}". Then it is easy to fetch it in WS, but I would need to split the two values out of the string. Is this possible in WS?
Or is there a better way to approach it?
Thanks in advance!