Query column - filter on "This row>Multiple Texts"

Ask for Help
1

HI

I am doing a query to a table, and trying to return only rows with rowIds that do NOT exist in a “This row>Multiple Texts” column (Trebuchet method)

However I can not select a “This row>Multiple Texts” column. I need to convert it to a Joined List first.

It works fine, but I thought I should able to choose “Row ID” is not included in “This row>Multiple Texts”

Or am I missing something?

2

You’re right that Glide doesn’t let you compare a Row ID directly against a “Multiple Texts” column unless you first turn that column into a Joined List. That’s because Multiple Texts is actually an array, and Glide can only do “is included in” checks with plain text. Don’t Mind it..

4

Checking with the team on this. I’m not sure why array contains something is supported, but not the inverse.

CleanShot 2025-06-28 at 06.52.34
CleanShot 2025-06-28 at 06.52.34342×152 4.9 KB

6

Here’s the response:

There is a reason — it has to do with how this data is stored in the back-end. I don’t think you can use “is included in” when looking at a certain type of data due to the way it’s actually stored (it’s not seen as a piece of text that can be broken into parts).