Open URL Q

[cyberjaz]

Hey Guys,

 

Just bought FMP 8.5 and am getting used to it, i dont remember how i used to keep track of everything in excel lol.

 

Anyway i have a simple question i think.

 

I want to link a url with a field ie. http://www.domain.com/{field} how do i configure the open url script to substitute the {field} from a set field?

 

Jaz smiley_cool

[CobaltSky]

Just bought FMP 8.5 and am getting used to it

Hi cyberjaz,

Welcome to the Café!

 

how do i configure the open url script to substitute the {field} from a set field?

The Open URL[ ] command provides you with two options.

 

The first is to click on the "Specify..." button and enter a URL as text (ie as a literal value). You can put the URL in quotes, or, if you don't, FileMaker will add them when you click the OK button.

 

However at the upper right of the dialog into which you enter the URL as text, is another button, also labeled "Specify..." and if you click on it, you'll be presented with a calculation dialog into which you can enter any calculation expression. This can be used to refer to a field (ie to source a URL from a text field and pass it to the Open URL[ ] command) or a variable, or to use text functions and operations to "assemble" a URL from a variety of elements. IOW you can calculate the URL on the fly.

 

So, if your Set Field[ ] command has placed a URL into a field, you'll be able to use the second (calculation) option to point the Open URL[ ] command at the same field. It will then retrieve the URL and pass it to the user's browser. smiley_cool

[cyberjaz]

Thats fantastic and i get that but what commands do i use for this?

 

Ie. i want to produce this domain from the field {domain}

 

http://www.test1.com/query.php?{domain}

 

What calculation steps do i need ?

 

I tried "http://www.test1.com/query.php?"{domain} but no luck

[CobaltSky]

What calculation steps do i need ?

 

I tried "http://www.test1.com/query.php?"{domain} but no luck

You're close.

 

To append two elements within a calculation, you should use the ampersand (&) operator, so if you have a field called "domain" in a table called "YourData"; the syntax required to append it to the text literal URL stem would be:

 

"http://www.test1.com/query.php?" & YourData::domain

[cyberjaz]

Wow cool thanks heaps RAY !

 

Thats awesome !!

 

You rock!!!!