Skip to main content

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

  • November 30, 2023
  • 1 reply
  • 14 views

Forum|alt.badge.img+1

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:

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

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • November 30, 2023

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