Hey all! I have what I suspect is an array issue with Airtable's back-end, but it's preventing me from filtering on the front end, so I would love some help.
I have 3 tables: Books, Products, and Authors. A book might have multiple authors, and each author may or may not have a bio. I have made a roll-up in the books table for author bios with this formula:
IF(values, ARRAYJOIN(values, "\n\n"), BLANK())
I have also tried it with just the ARRAYJOIN, and no if statement.
I then have a 1-to-1 relationship between Books and Products. In the Products table, I have a look-up of the roll-up of the bios in the Books table.
Here's the issue: when a title has multiple authors, but none of them has a bio, the roll-up should obviously return blank. The look-up in the products table should return blank. But when I filter products by having the look-up be blank, the record in question won't show up. I tried filtering by newlines, whitespace, anything I could think of, but I can't find how AT is parsing the empty array returned from the look-up of the roll-up.
Has anybody run into this before and found a workaround?