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?
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..
Checking with the team on this. I’m not sure why array contains something is supported, but not the inverse.
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).
