#ERROR! when using ENCODE_URL_COMPONENT() on lookup - SOLUTION

Topic Labels: Formulas
883 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I’m new to the airtable community and wasnt sure how to reply to an original post that has been closed. But I found a solution to this #ERROR! when using ENCODE_URL_COMPONENT() on lookup? post.
You can use ENCODE_URL_COMPONENT({lookupFieldThatYouAreTryingToEncode}&"").
This adding (&"") solution is a lot neater than adding another already encoded field to the parent table.

2 Replies 2
5 - Automation Enthusiast
5 - Automation Enthusiast

adding the &"" worked for me as well. Thanks!

7 - App Architect
7 - App Architect

adding the &"" also worked for me. Thanks!