Can't add "=" constraint, only "contains"?

Hi All!

In one of our Tables (via Airtable) we can constrain searches, like email searches, with an = sign no problem:

But for some reason, in another table, we can only use “contains” :
image

I’ve reinitialized and checked both, and in both cases the relevant field is a Text field, so I’m not sure why we can’t use an “=” sign for the latter

It’s creating huge problems - any advice on how to resolve? Thank you!

Hey @darin :wave:

If there is only contains, that means API connector initialized it as a list. Since the API response is not gonna change, probably you have to change your logic a little bit.
A list of emails containing a single email is more or less same as an email field’s being equal to a single email value.

bdk_512x512 @Huseyin from Flusk | Discover the #1 Security and Monitoring Tool for Bubble

Thanks @flusk - yep we solved it, it’s because that’s a ‘lookup’ field in AirTable, so we had to create a separate local field mapping to it.

Thank you!

1 Like

Hello @darin, how are you?

Ahhhh airtable and its many downfalls, this is why I always recommend other codeless backends besides airtable.

Something that might fix this problem is when you initialize the call for the “Owners” table, you should be able to change the type from single to list. Try re-initializing the call and in the popup that shows up with all the datapoints, change the ones you want as a list to list.

This topic was automatically closed after 70 days. New replies are no longer allowed.