Country Code custom field missing from Facebook Lead Ads

Hi there, @Paulo1988! I hope you don’t mind but I did a bit of digging and it looks like you and my friends in support may have came up with a pretty nifty solution to this. I’ll post it here in case it’s helpful to anyone else who’s stuck:
 

I have a CRM (Ometria) and Zapier is feeding all the Facebook leads it collects into Ometria.

I need each and every lead to have a country code (GB for Great Britain, NL for Netherlands, DE for Germany etc.)

I managed to half-solve this with the Formatter by Zapier tool. I have a rule in place whereby if a customer enters “England” or “Great Britain” Formatter by Zapier reads this and replaces it with the country code: GB before feeding the lead through to Ometria.

The question also came up - what to do if a user doesn’t enter a country code though, to which Connor recommended: 

… I might suggest checking out Formatter's "Lookup Table" transform:
 

• Create lookup tables in Zaps

 
With a Lookup Table, you can relate each input you might receive to its corresponding country code. This way, when the Zap runs, it will search the left side for a match, then output the value on the right, which we'd then map into Ometria:
 

 
Importantly, the Lookup Table transform offers a "Fallback Value" so we can output a default in the event the lead doesn't offer a country or if their country doesn't match any in our table. 

I hope this helps!