Jump to content

Adding a web site link to a database


gavh24
 Share

This topic is 6515 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

  • 4 weeks later...

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6515 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.