Hi,
As I see the lookup function in the form only works if the column to filter on and/or(?) value to filter on has a letter in it.
ID | breakfast |
---|---|
2001 | apple |
2002 | coconut |
2003 | peach |
lookup("Example list","ID",ID,"breakfast")
It wont throw error, simply not finding anything.