#ERROR! when using ENCODE_URL_COMPONENT() on lookup?

[Jgray]

Getting and #ERROR! when using ENCODE_URL_COMPONENT() on a lookup field of a text field. Can the formula be used on lookups?

[Devon_Godfrey]

Found a solution, use this in your formula: 

ENCODE_URL_COMPONENT(ARRAYJOIN( Email, ""))

"Email" was the field I wanted to encode into the URL. Arrayjoin basically converts the array into a string. Itl's a lookup field that looks up my contact table, and is on my opportunity table in my CRM.

[Celeste_Bancos]

This works, thank you so much @Devon_Godfrey!

To answer @Bill_French's question, I am using ENCODE_URL_COMPONENT in the formula of a button field to construct a link to an Interface form that is prefilled with data.

[airtable782ccc]

You are my hero @Devon_Godfrey  😄 Thanks so much for this.