
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 13, 2024 03:27 PM - edited ‎Feb 13, 2024 08:52 PM
You are my hero @Devon_Godfrey 😄 Thanks so much for this.

- « Previous
-
- 1
- 2
- Next »