AnsweredAssumed Answered

Lookup numbers in form

Question asked by papancsev on Apr 5, 2017
Latest reply on Jul 22, 2018 by hardy-liu

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. 

I need to use it to find duplicate numbers in a single line of text field. 
Is there a way to make it work with numbers as well?
Example list with all column single line of text field.

IDbreakfast
2001apple
2002coconut
2003peach

 

lookup("Example list","ID",ID,"breakfast") 

 

It wont throw error, simply not finding anything.

Outcomes