Open Calculated URL

[Hoytopher]

The script which I am using (kindly provided by another user) is: 

"http://www.publishersmarketplace.com/pm/search?ss_q=" & Contacts::First Name & "+" & Contacts::Last Name & "&ss_c=dealmaker"

 

Using this script, I am able to generate the URL that I wish. The URL is different depending on who I am searching for, and as such each URL is unique to a specific record. I currently have a field set to perform this script - the problem is creating a button capable of going to this calculated URL. Trying to enter it as the URL to go to leads to me searching for Contacts::First Name rather than the desired first name. I am unsure of how to go forward and am not finding useful information relevant to this problem in my searches.

Edited April 20, 2016 by Hoytopher

[comment]

You must quote text constants. And use the & operator to concatenate string values. For example, the following formula:

"http://www.publishersmarketplace.com/pm/search?ss_q=" & Contacts::First Name & "+" & Contacts::Last Name & "&ss_c=dealmaker"  

would return the string:

http://www.publishersmarketplace.com/pm/search?ss_q=Bobby+Byrd&ss_c=dealmaker

 

 

Edited April 20, 2016 by comment

[Hoytopher]

Thanks so much for the script! It works perfectly, yet creates a new problem. I have to log in to that webpage each time. Is it possible to generate the URL, and have a button that goes to the generated URL? I cannot use your script when used as the URL in the button, as it shows up as ::First/Last in the search bar.

 

[comment]

I am afraid you have lost me at this point.

 

19 minutes ago, Hoytopher said:

I have to log in to that webpage each time.

Are you using this in an Open URL[] script step? IMHO, if you're logged in to the site, calling another search should not log you out. Does the same thing happen if you paste a new search URL into the browser's location bar manually?

 

19 minutes ago, Hoytopher said:

Is it possible to generate the URL, and have a button that goes to the generated URL?

Not sure what that means.

 

19 minutes ago, Hoytopher said:

it shows up as ::First/Last in the search bar.

Or this.