I have a script that takes the contents of the “Brand” and “Model” fields from the “Products” table and formulates a URL for a Google search. It them sets the “gWeb” field from the “Products” table equal to this URL and opens the URL contained in gWeb. Unfortunately, it doesn’t work – FMP adds an extra character to my URL!
Here is the calculation that I use to formulate the URL:
"&Products::Brand
&"+"
&Products::Model
&"&btnG=Search"
So, if Brand=Ford and Model=Freestar, the URL should look like this:
This URL yields a valid Google search (try it yourself). And when the “Confirm URL” dialog box comes up, this is exactly what the URL looks like. BUT, when I click OK, the address that ends up in my IE address bar is:
Notice the extra slash (“/”) after the “.com”. Needless to say, that is enough to render the URL useless. I have also tried running this without the Confirm URL dialog, same result. I have other scripts doing the same thing for other search engines, and I have the same problem with others (but not all of them). For example, Yahoo shopping also has the problem, but the Price Grabber URL gets entered and accessed correctly.
Any ideas? Any other way to accomplish this goal? Thanks!
Here is the calculation that I use to formulate the URL:
"&Products::Brand
&"+"
&Products::Model
&"&btnG=Search"
So, if Brand=Ford and Model=Freestar, the URL should look like this:
This URL yields a valid Google search (try it yourself). And when the “Confirm URL” dialog box comes up, this is exactly what the URL looks like. BUT, when I click OK, the address that ends up in my IE address bar is:
Notice the extra slash (“/”) after the “.com”. Needless to say, that is enough to render the URL useless. I have also tried running this without the Confirm URL dialog, same result. I have other scripts doing the same thing for other search engines, and I have the same problem with others (but not all of them). For example, Yahoo shopping also has the problem, but the Price Grabber URL gets entered and accessed correctly.
Any ideas? Any other way to accomplish this goal? Thanks!