AnsweredAssumed Answered

Lookup numbers in form

Question asked by papancsev on Apr 5, 2017
Latest reply on Apr 6, 2017 by emha

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