I needed search for the numbers 1 to 10 in my column ‘code’ to show only rows that had numbers in that column code so for this i would just enter the numer 1, 2, 3 in the field Lookup Value but i can only use custom field in this field.
So i needed to create 10 custom fields named lookup_code_column_1, lookup_code_column_2, etc and define the value 1, 2, 3 for each and only after do all this i could use the custom field lookup_code_column_1 in the field Lookup Value to make manychat understand that i wanted in the Lookup Value a simple number. frustrating.
I am talking about google sheets integration offcourse.