Getting and #ERROR! when using ENCODE_URL_COMPONENT() on a lookup field of a text field. Can the formula be used on lookups?
Hmmm… good question (I guess).
I hate it when support people ask me “Why would you want to do that?”, and yet – here’s a good example of why someone might ask this question.
I’m sure you have a good reason, but I would love to hear it anyway - just curious.
As far as a lookup function is concerned, whatever is in the string is what it will attempt to match on. If the contents of that field is also URL encoded, I suppose it should work as I can’t imagine why Airtable would sanitize lookups in any way.