Lookup when field is not None

Ask for Help Formulas
1

How to have LookupOne but with a field not a certain value (None in my case)
In my example, I have Items, Item Movements and Event tables.
In Items, I have a column Last Movement that is Item Movement filtered for this Item, but I want to filter out movements where Event is not defined.
I have tried with: Event=CONTAINS(Events.all) but as you can see I have a #TypeError
How can I figure it out ?

image
image1662×530 49.8 KB

I’ve masked out some sensitive data

2

You could have a has_event column (of type Toggle, that you may hide if you want) in Item Movement, that you would define as follows: not not $Event.

Then your formula becomes Item_Movements.lookupOne(Item=$id, has_event=True, order_by=”-Date”).

3

Ok, thanks, that works well