Jump to content

Create a Hyperlink TO a FM record


elwood00
 Share

This topic is 5689 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am not even sure if this is the right section of the forum....

using FM7

OK, here is my problem - we have a database with customers that are mapped in DeLorme, our drivers use GPS to get to them, upon arrival, they need to fill out a report which is in filemaker - now, one would think by looking at the customer number on the DeLorme map, and then searching for that number in FM7 they would enter their data into the correct customer record - well, seems like dislexia is well and kicking in our company.... the best way to eliminate the problem would be, if there was a way to use the hyperlink that DeLorme offers in a map-tag to jump to THAT customer in FM..... is that possible?

Link to comment
Share on other sites

I am unfamiliar with DeLorme, but maybe you could take the URL and parse out the info that you want. You could paste the URL into a global field and then have a script find which record to go to via the parsed data, if the data in the URL matches some data for each of your customer records.

Link to comment
Share on other sites

I think i can handle finding the site once I have something in filemaker... it does not have to be DeLorme it can be any application surpporting hyperlinks... Lets just assume it is a regular HTML page (local not on the net) - Is there a way to specify in a hyperlink to go to/open Filemaker and point a specific record or run a specific script?

Kind of like you have a hyperlink on a webpage and when you click on it, it opens google-earth and goes to a certain map tag.....

Edited by Guest
Link to comment
Share on other sites

Well, how about using the GET or POST option in a URL to feed a fx.php query or have fx.php feed some fields like the recID and userID then pass it onto an IWP session

How are they entering the data in FMP now? IWP over the web? Since you are wanting a URL to go to a specific record I'm presuming web entry of some sort...

Link to comment
Share on other sites

no this solution is 100% local - a notebook computer with FM7 and DeLorme Street Atlas installed - no internet at all- the reason for a url is that the DeLorme mapping software only offers hyperlinks to 'communicate' with the outside world.

Right now it is very basic - they use DeLorme to get to the customer, then they open FM and search for the customer, create a new report and fill it out. Should work fine in theory, but in reality, too often customer 7557 gets billed for work done for customer 7575.....

Thanks for the other suggestions - I am sure once I have read them a couple hundred times, I will sort of understand what needs to be done :

I am fairly new to all this....

Link to comment
Share on other sites

Well if the application is local, you can not change the the "execution" of your application from a web address to FileMaker without changing the application itself.

One possiblities that you may be able to implement is trying to see what the hyperlink passes in its query string. If there is data that you can pull from that string then either you can copy and paste that URL & parse the data in FM, or as Leland said, you may be able to use PHP.

Link to comment
Share on other sites

I can make that hyperlink say whatever it needs to say - basically every mappoint can contain information like address, name, lat, long, etc. and one of the fields I have available is a hyperlink - normally you would use it to go to the website for that mappoint, i guess. I wanted to see if there is a way that i can use that hyperlink to jump to a certain record in FM - I know how to start FM from the hyperlink, but how do I get it to go to that record? In the 'good ole' days there were certain things you could pass on in the command line when starting an application (like word would start a certain document c:xxxword.exe test.doc)- does FM support that at all or something like it?

Edited by Guest
Link to comment
Share on other sites

This topic is 5689 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.