Unsupported formula field to filter on

I would like to generate a slug using Baserow to use with Webstudio.
But when I try to connect, I receive this error.

Is there any workaround for this?

Using:

https://api.baserow.io/api/database/rows/table/387000/?user_field_names=false&filters={"filter_type":"AND","filters":[{"type":"equal","field":"2941000","value":"airtable-to-baserow"}],"groups":[]}

In which 2941000 is the field ID for the slug formula.

Hi,

I tried the equal filter on a formula field in the database UI and it seems to work. Is it possible that the result of the formula is not considered to be a text? You can work around this by using the totext() function to convert the result to a text that can be used with the equal filter.

Thanks Frederik!

I’ve used a pre-configured url which I didn’t understand yet completely. I had two slugs. Slug2 being single line text working with type equal. And Slug being a formula. And instead of type equal, I needed to use has_value_equal because it was an array as shown in the api docs.

Learned another valuable thing today :grin:

Shared solution in Webstudio discord as well.