Driving Directions in Web Viewer

[FM-Monster]

I'm trying to use the web viewer to show directions from one customer record to the next customer record.

I have the string that will map two sets of information and show the driving directions in the web viewer(by google maps). But I'm struggling with getting the info from two seperate records into the string. I want to use a calculation that will pull the info(address) from the previous record and put it in the current record, so I can use the info to fill the string properly.

The person using the directions will always go from the previous record to the next record when driving (it is a found set that is sorted and printed)

I'm hoping that there is a simple function or calculation that could pull info from a previous record.

[stefanshotton]

After sorting, run a script that starts at the first record copies the zip code/postcode to a variable, loops to next record and set another field with the information held in the variable.

You can then use the variable in the calc for the web viewer.

[FM-Monster]

That sounds easy enough. Thanks for the help.

[rellis32]

I think an easier way to do this would be the GetNthrecord calculation:

GetNthRecord(addressField ; Get(RecordNumber) - 1)

[FM-Monster]

I was going to use the GetNthRecord function at first but I couldn't figure out the "Record Number". I assume that is a field that I have to create...

If true then in my found set I have to "renumber" all of the records and then the function will work properly. Correct??? Can I "renumber" them in a script?

[Heathbo]

Funny, I'm struggling with the string. Can you tell me what string your using to unite two different records? ie. the calculation

[rellis32]

here is a very simple example. Hope this clears it up!

Bob

DrivingDirections.zip