Help

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

Topic Labels: Formulas
763 2
cancel
Showing results for 
Search instead for 
Did you mean: 
wheels_2go
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
Davidt
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Leslie_Burke
6 - Interface Innovator
6 - Interface Innovator

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