Sep 12, 2019 12:39 PM
Getting and #ERROR! when using ENCODE_URL_COMPONENT() on a lookup field of a text field. Can the formula be used on lookups?
Solved! Go to Solution.
Jul 12, 2023 04:03 PM - edited Jul 12, 2023 04:04 PM
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.
Jan 16, 2024 07:32 PM
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.
Feb 13, 2024 03:27 PM - edited Feb 13, 2024 08:52 PM
You are my hero @Devon_Godfrey 😄 Thanks so much for this.