however, it returns an error that the result must be text. When I put essentially the same formula in an action button using @URLOpen() it opens the correct document in the frame.
database := @ReplaceSubstring(@Subset(@DbName;-1);“\”;“/”);
server := @Name([CN]; @Subset(@DbName; 1));
UNID := @Text(@DbLookup(“”:“NoCache”;Server:Database;“(HTMLNavs)”;“CTM”;2));
@ReplaceSubstring(“HTTP://” + @GetHTTPHeader(“Host”) + “/” + @Subset(@DbName;-1) + “/0/” + UNID + “?OpenDocument”;" “;”+")
I’m at a loss as to what needs to be done to make this work.
Any ideas?
Subject: I have tried this formula in a frame URL launch.
Check if Host is available when you launch the frame. Return value of @GetHTTPHeader() is Text if it exists, but null if the field does not exist.
Subject: RE: I have tried this formula in a frame URL launch.
I have placed the same formula in a compoted text field on a form and it produces the correct URL. The problem is that the designer does not does not recognize it as a valid URL syntax, and probably correctly so because it is being executed in the designer client not a web client. So a URL that is placed in the @ field on the frame Launch must resolve to a valid URL at design time even though it might resolve correctly at run time.