Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Problem creating a URL formula using any field that contain more than one word in a cell

Topic Labels: Formulas
620 1
cancel
Showing results for 
Search instead for 
Did you mean: 
EdJacobs
5 - Automation Enthusiast
5 - Automation Enthusiast

I am trying to create a URL to search Google Shopping for a specific combination of (Brand, & Product Title), however i am noticing that if either the Brand or Title has more than one word, the URL does not form correctly:

EdJacobs_0-1701380118129.png

dummy.png

Ideally I would use the Google Shopping ID for the product search, but that is a separate URL/search entirely. I also want to add UPC to this, but that shouldn't be a problem as a UPC is not two words (however sometimes multiple UPCs may be searched, so the same issue might arise).

If anyone is able to advise, I would greatly appreciate any help!

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

You will need to URL encode those field names by wrapping them with the ENCODE_URL_COMPONENT() function.