Kervin

Discussions

Create a URL with CONCAT and variable in the middle.
CONCAT("https://b2b.officedepot.com/rest/ODServices/api/product/priceAvailability/xml?zipcode=XXXX,"&sku=", `VARIABLE` ,"&billto=XXXX) I am trying to have a cell value where it shows VARIABLE . Everything else is part of a constant URL. I just can't get the variable To be in the middle of the URL. I have worked with others…
Beastmode. How to create a CONCAT URL with several variables?
Want to build the following link on a card =CONCATENATE("https://b2b.officedepot.com/rest/ODServices/api/product/priceAvailability/xml?zipcode=",`CONSTANT1`,"&sku=",`COLUMN`,"&billto=",`CONSTANT2` ) The URL is a constant as well as "CONSTANT1" and "CONSTANT2", but also need "COLUMN to change depending on the value of the…