Display data as a URL in a web database

[mossadagent]

Is it possible to display the found contents of a field as a url in a web published database?

I am using a filemaker 6.0 database with web companion, there is a field for users to input their favorite web pages, they use the full URL, such as http://www.apple.com and create a new record. Now when they do a search they find this URL but it is in text form and not a link, is there a way to display this URL as a link from the found data that can be clicked on and launched?

This is for a class of 7th graders to share their favorite links, ideally they should do a seach, find a URL and click on it to launch it, now they find it but have to copy and paste it. The test database is at:

http://www.nanothink.com/kent/

any help will be appreciated

TIA

[Vaughan]

You can with Custom Web Publishing, but not with Instant.

[mossadagent]

indeed I am using custom and not instant, could you please eloborate on how I would implement this.

[Vaughan]

Believe it or not, the same way you would make a url with normal text. Say your url was in a field called "urlfield" and the url in the field is a complete and correct (starts with "http://" contains no spaces etc) then the code to produce a clickable url where the clickable text is the same as the url would be:

<a href="[FMP-Field: urlfield]">[FMP-Field: urlfield]</a>

Also I'm not sure of the encoding for the [FMP-Field: urlfield] CDML tag: you might have to change it to "raw" to work.

[Steve T.]

Hi, mossadagent! Here's a line directly out of our code (actually, it looks just like Vaughan's):

<A HREF="[FMP-field:Web Site]">[FMP-field:Web Site]</A>

We did not specify enc here, but this is what we used on the original FORM where the session begins...

ENCTYPE="x-www-form-urlencoded

Pretty cool, eh? BTW, we set ours up so "http://" must be typed in or it won't work. You may want to refine this if you want folks to be able to type just "www.wherever.com".

[PotzUK]

<A href="[fmp-if: webfield.ncn.http]http://[/fmp-if][fmp-field: webfield]" target="_new">[fmp-field: webfield]</a>