Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Open URL Q


cyberjaz
 Share

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use