Link in email to a specific filemaker record

[FredP]

I may have asked for this before, but never found a solution so I am asking again in a better more specific question.

 

I am sending out a notification of a record change in filemaker.

 

Is it possible to include a link in that email that filemaker is sending out, that would allow the user to click on it, and go directly to that specific record in filemaker?

 

Something like this is what I would imagine it would be (in non-specific terms) :

 

FileOpen:\\networkdrive\\database.fmp -layout "Form" -recordID# "00123"

 

Something like that so that the user receiving the notification can click one thing, and go directly to that record in filemaker

 

It would have to work whether the database was already opened or not.

 

Any help would be appreciated.

[AHunter3]

If your end users have FileMaker Pro (NOT accessing the db via web browser, i.e., this is NOT an IWP routine we're talking about), you can send them an actual FileMaker Pro FILE as a file attachment; the file would have a different name depending on who you send it to, and you can trap in the hosted (main) file for DatabaseNames and hence use the name of the file you sent to abstract out any specific info.

 

Example: You send your users "LaunchMe_123.fp7", user double-clicks that, it has a run-on-open script to open the main hosted file, main hosted file does this in ITS run-on-open script:

 

If [PatternCount (Databasenames, "LaunchMe_")>0]

..Set Variable [$Snippet, Middle (DatabaseNames, Position (Databasenames, "LaunchMe_", 1, 1)+Length ("LaunchMe_"), Length (Databasenames) )]

..Set Variable [$SerialToGoTo, [Middle ($Snippet, 1, Position ($Snipped, "¶", 1, 1)-1)]

.. Go to Layout ["Layout You Want"]

..Enter Find Mode []

..Set Field [YourTable::Serial Nunmber, $SerialToGoTo]

..Set Error Capture [On]

..Perform Find []

..If [Get(FoundCount) = 0]

.... Exit Script

..End If

End If

Comment [do other stuff here for folks getting in via method other than launcher file they received]

[Norma_Snockurs]

I may have asked for this before, but never found a solution ... Is it possible to include a link in that email that filemaker is sending out, that would allow the user to click on it, and go directly to that specific record in filemaker?

Fred, did you not ever have any luck getting the method I suggested in this thread to work then? It was admittedly somewhat convoluted but it was working reliably for me during testing.

I have not come across an easier way of doing this since.

 

Unfortunately the new 'Send Link' function of FM9 stops short of opening individual records and allows for simply opening a specific database file only.

 

 

..and Alan is there a typo in your code? Should variable '$Snipped' be '$Snippet'? I couldn't see where '$Snipped' gets set up. Like the dynamic file naming approach though. It's quite obvious when you think about it.

The only problem with this attachment method is that it does leave 'evidence' of the record accessed by the user which may not work well with some security models. Having the record key in the actual fp7 file name itself is quite blatant.

[FredP]

Both your original post Norma and Hunters are both good solutions, absolutely. I think part of me was hoping something new in FM 9 might have been discovered, or uncovered

 

Email attachments worry me, a little, because of email abuse, but it might be the only way? thank you

 

Fred

[AHunter3]

..and Alan is there a typo in your code? Should variable '$Snipped' be '$Snippet'? I couldn't see where '$Snipped' gets set up.

 

Not any more And yes it should. thanks for the heads-up!