Help

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

Topic Labels: Formulas
522 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

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