Create a URL with CONCAT and variable in the middle.

Kervin

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 where the variable is on the end and looks like this

CONCAT('<a href="https://www.purchasingplatform.com/admin/products/', `PP Item #`, '" target="_blank">', `PP Item #`, '</a>')

MarkSnodgrass

I think your issue is around the double quotes in parts. Here is an example of how I did one similar where ClaimNumber is my variable name:

CONCAT('<a href="https://mydomoinstance.domo.com/page/954056803?pfilters=[',
    '{%22column%22:%22ClaimNumber%22,%22operand%22:%22IN%22,%22values%22:[%22',
    `ClaimNumber`,
    '%22]}',
    ']" target="_blank">',
    `ClaimNumber`,
    '</a>')

I found it worked best to break things up into more concat statements than technically necessary to deal with the quotes.