More Vieweirdness

Mel Charles I am using the Mac app with iCloud sharing, not what I think you're referring to as 'web based'.

That aside, I've not seen this issue anywhere else either, completely new to me.

That column was set as:-

if vType = 2 then
    let theType := Frame.fullDesc;
    if theType then theType else "?" end
end

vType means motorcycle (4 means car), so in the above example, it only shows fullDesc (a text string concatenation of several other fields) for motorcycles and with a '!=null' filter should only therefore list motorcycle records. A filter technique originally suggested on here and has worked perfectly everywhere I have used it. In this case it displays the column correctly as expected, but NO filter works on it.

--later--

Did some more testing on a simplified version:-

if vType = 2 then
    Frame.fullDesc;
end

also fails to filter. But:-

if vType = 2 then
    Frame.Materials;
end

works and can be filtered. 'Materials' is a Dynamic MultiChoice field. However:-

if vType = 2 then
    text(Frame.fullDesc);
end

again will NOT filter.

The 'fullDesc' field is a concatenation of several Dynamic MultiChoice fields, each using text() in order to add some additional text. So…

The problem is that if the string being filtered is derived from anything using text(DMC), it will not filter. However, a text type field, a single raw DMC or any literal string (or numbers etc), filtering then works.

So Ninox IS somehow looking back at the derivation of the string it is trying to filter, and if that includes a text() conversion of a DMC (or possibly any choice field, but text("string") is fine), it gives up and doesn't filter.

As I said, I got around the problem by using a different column, so although weird, not a show stopper.

Be interesting to see if knowing the above, others can replicate the problem.