I am trying to create a node that brings back all records from a specific view. Activepieces does not seem to have such option.
Insteads, I am trying to use a negative formula where {Status} != ‘Booked’
However, I cannot make it work in Activepieces. It forces me to indicate a search filed and Search Value.
The Search Field is “Status” I selected that but I cannot get any results is I set the Search Value to any of these:
''
""
!= 'Booked'
How do I make it work?
EDIT: I think I figured a way. In the Search Value filed, press the Space Bar key once.