Adding a web site link to a database

[gavh24]

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.

[EddyB]

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

[Jeff Spall]

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

[Sintax]

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

[EddyB]

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.

[Sintax]

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

[Sintax]

Got it!

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

Thanks Man!