OPEN URL vs. container field

[kwatson]

In FMP6 and previous versions we had a simple script which said Open URL(fieldname) where field contains the complete URL of a .pdf containing submitted documentation. For some reason with FMP7 this has ceased to work on some of my users machines, but not all.

I guess the workaround would be to put the .pdf's in a container field, but before I start converting everything...any clues why it won't work and what are the advantages/disadvantages of using a container field to do this?

Any help will be appreciated.

[CyborgSam]

URLs in a calculation need to have backslashes quoted. See below:

FileMaker uses the [color:blue] (backslash) as an escape character within text strings in the calculation dialog. To insert a [color:blue]" (double-quote) into a text string, insert [color:green]". To insert a [color:blue] (backslash), insert [color:green]. To insert a [color:blue]¶ (paragraph mark), insert [color:green]¶. The paragraph mark's character may not show properly in all web browsers...

Examples as they appear in a calculation:

To get the text [color:red]"This is a quote." enter it as [color:green]""This is a quote.""

To get the text [color:red]c:Documents and SettingsmeDesktop enter it as [color:green]"c:Documents and SettingsmeDesktop"

To get the text:

[color:red]This text is

on two lines. enter it as [color:green]"This text is¶on two lines."

[-Queue-]

Alternately, you can often enclose text within the Quote() function to produce the desired result.