I am creating a database and i was wondering if there is a way to add a website link, that can be clicked on in the databease, and bring the user to the selected website.

Hi Gavin,

Welcome to the forum!

Yes this is possible using the go to URL script

Are you having the URL in a field or are you just typing the text onto one of your layouts?

Regards

Ed

Hi, in its simplest form, I do it with two fields:

Description

URL (the full url)

and the code:

<A HREF="[FMP-Field:url.RAW]">[FMP-Field:description]</A>

or, if you want to make it work better, use a calulation field to make sure that it's only delivered if there really is a link:

"linkfield"=

If(IsEmpty(link_desc), "","<BR><A HREF=" & url & ">" & link_desc & "</A><BR>")

then the code in the page is just:

[FMP-Field:linkfield.RAW]

regards, jeff

Hoping you might be able to help me out:

I want to be able to click on an image in a container field in my database (I know how to do all of that) and have it go to a website where the Title field fills in part of the URL (I don't know how to do that).

This is what I am looking for:

http://www.gamestop.com/search.asp?sortby=title&searchtype=quicksearch&searchcount=12&keyword=<<Title>>

Where "<<Title>>" is the text in the "Title" field for that record. Is this possible at all?

Thanks!

Version: v7.x

Platform: Mac OS X Panther

Hi Sintax,

Create another field, lets call it LinkURL, this will be a calculation field where the result is text.

LinkURL=

"http://www.gamestop.com/search.asp?sortby=title&searchtype=quicksearch&searchcount=12&keyword=" & Title

Now in your script that is activated by clicking on the container you need to have:

Open URL["LinkURL"]

HTH

Ed.

Well I think I did it correctly but nothing happens. Let me walk you through step by step of what I did:

1) Define > Database

2) Field Name: LinkURL Type: Calculation

3) LinkURL = "http://www.gamestop.com/search.asp?sortby=title&searchtype=quicksearch&searchcount=12&keyword=" & Title

4) Calculation result is: Text

5) Scripts > ScriptMaker > New

6) Open URL [No dialog; "LinkURL"]

7) Applied the script to my container filed

So there it is... what did I miss or do wrong?

Thanks!

Version: v7.x

Platform: Mac OS X Panther

Got it!

It should have been: Open URL [No dialog; "Database::LinkURL"]

Thanks Man!