Help

#ERROR! when using ENCODE_URL_COMPONENT() on lookup?

Topic Labels: Formulas
Solved
Jump to Solution
6524 12
cancel
Showing results for 
Search instead for 
Did you mean: 
Jgray
5 - Automation Enthusiast
5 - Automation Enthusiast

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

12 Replies 12
Devon_Godfrey
6 - Interface Innovator
6 - Interface Innovator

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.

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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