Hello,
The lookup table is not showing the desired output despite having a matching record in the table.
The table is configured as follows:
As you can see here the input matches one of the items in the table which should output ‘SILVER’
However when testing, the output field is empty
I have double checked the usual things like double spaces, space at the end, spelling etc.
Thanks
Best answer by Mitchell Zezima
SOLVED - I realised that one of the letters was lowercase in the input and uppercase in the lookup table. I now know that the lookup table is case sensitive
SOLVED - I realised that one of the letters was lowercase in the input and uppercase in the lookup table. I now know that the lookup table is case sensitive
+14For anyone else, help links for using Formatter: https://zapier.com/apps/formatter/integrations#help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
