FileMaker and Hook

I would like to be able to paste Hook links into individual records of a FileMaker database, but this does not seem to be possible at the moment. Is there any possibility of being able to do this?

I’m not following — what is happening when you try to do this currently?

I should have been clearer—the link is pasted but only as plain text, and does not behave like a link. Or am I missing something?

This is a FileMaker limitation — only certain protocols are recognised for some reason.

You could ask FileMaker to support all protocols the system recognises. As a work around you could probably add a button by the field that opens the URL (been a while but I’m sure there must be a function in FM to pass a string to the web browser or open any URL directly).

I’m sure you are right. Until now I have been linking to other files via a “container field,” but I thought it would be nice to be able to use Hook links without using a special field.

The list of protocols says file:// is supported. That means you could insert URLs for Hook files and they’ll be clickable — which then allows you to link to anything without a special field.

By URLs, do you mean a Hook link or something else? If the latter, I suspect that this discussion is moving beyond my capabilities and I will have to stick with a special field.

This is slightly convoluted, but should be pretty quick once you’ve done it once.

If you have the Pro version of Hook, you can:

  1. First, setup the automator service described here. Just need to do this once.
  2. Make a Hook file instead of copying a Hook link (so, works on anything you’d normally use Hook for). So just open Hook then press SHIFT+CMD+H
  3. When you have made the file it will automatically be revealed in Finder, where you can right-click and select the service you created in step 0.
  4. Paste that link into FileMaker where you currently do.

Then, when you click the file:// link you put in FileMaker Hook will take you to wherever you Hooked to, even if those Hook links weren’t working in FileMaker previously. You could probably automate that whole thing if you wanted, but the above should be pretty low friction once setup.

Many thanks for the detailed explanation. Unfortunately the link for the automator service does not appear to be working.

thanks, @pubay for asking, and @stevelw for answering.

Hook’s AppleScript does provide a bookmark from url that may be relevant. The bookmark contains three attributes: title, hook URL, and POSIX file path.

We intend to provide a Copy file:// Link which would be enabled when the Title or selected Link points to a file. The link’s URL’s scheme would be file://. The command would place Markdown, RTF and HTML variants in clipboard. We may also provide a “Copy Path” command which would work for all linkable resources.

1 Like

Sorry, had an extra character in link. Should work now.

Thanks for all your help, but it still doesn’t work for me. The file path copied by the automator service doesn’t begin with “file://” and so isn’t recognized as a link by FM.

You’re right, they didn’t include that bit. Here’s a macOS Quick Action (AKA Service) which will give you the URL for the currently selected file.

How To: Install a macOS Service - BrettTerpstra.com

Many thanks. That now works, although I have to select the entire link, right-click, and then select the Quick Action.

Im not sure what you’re doing — it should be a file you’re right-clicking and using the quick action on, not text.

I meant that the link pasted into FM is not a clickable link and I have to select it before right-clicking.

Hmm, file:// links should work in FM. Which version of FM are you running?

I’m using File Maker 17.

I’ve just spotted in their documentation that in FM you can’t just click on a URL to open it for some reason, however:

You can also hold down the Alt key (Windows) or the Command key (macOS) while clicking any part of the URL text to open the URL.

Which then means you won’t need to right click then select open from the menu.

For some reason that doesn’t work for me. But in terms of time and effort, I don’t suppose that it is noticeably different from clicking three times to select the link.