Command Script

[Bluedidz]

Hi,

I am trying to replicate an Access database command in Filemaker (see original Microsoft Access script below)

=IIf([NodeEasting] Is Null Or [NodeNorthing] Is Null,"No data","http://195.49.180//DorsetExplorer/?easting=" & Val([NodeEasting]) & "&northing=" & Val([NodeNorthing]) & "&zoom=200&Layers=1,2,3,4,5,6,7&ptx=400000&pty=100000&version=fwma")

I have the Easting and Northing fields in my FM database and I need to set up a button which 'on click' will generate the right URL address according to the Easting & Northing for each record and open the web browser.

Help much appreciated.

[comment]

See if this helps:

http://www.filemaker.com/11help/html/scripts_ref2.37.63.html#1029602

[Fitch]

Regarding "is null":

http://fmhelp.filemaker.com/fmphelp_11/en/html/func_ref3.33.12.html#1028095

Regarding displaying a message like "No data" in a web viewer (not sure if that's what you're doing):

http://sixfriedrice.com/wp/filemaker-9-tip9-web-viewers-without-the-web/

[Bluedidz]

Thank you for your replies. I am familiar with the web functionality, the problem is that for each database records the Easting & Northings will be different. I am trying to find a way (if possible) for FileMaker to look at both fields and replace the Easting & Northings within the url address. In an Access database this is a straight forward function to add.

[Fitch]

Where you have "Val([NodeEasting])," simply use the name of the field.