FM-Monster Posted August 30, 2006 Share Posted August 30, 2006 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. Link to comment Share on other sites More sharing options...
stefanshotton Posted August 30, 2006 Share Posted August 30, 2006 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. Link to comment Share on other sites More sharing options...
FM-Monster Posted August 30, 2006 Author Share Posted August 30, 2006 That sounds easy enough. Thanks for the help. Link to comment Share on other sites More sharing options...
rellis32 Posted August 30, 2006 Share Posted August 30, 2006 I think an easier way to do this would be the GetNthrecord calculation: GetNthRecord(addressField ; Get(RecordNumber) - 1) Link to comment Share on other sites More sharing options...
FM-Monster Posted August 30, 2006 Author Share Posted August 30, 2006 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? Link to comment Share on other sites More sharing options...
Heathbo Posted October 12, 2006 Share Posted October 12, 2006 Funny, I'm struggling with the string. Can you tell me what string your using to unite two different records? ie. the calculation Link to comment Share on other sites More sharing options...
rellis32 Posted October 17, 2006 Share Posted October 17, 2006 here is a very simple example. Hope this clears it up! Bob DrivingDirections.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6422 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 accountSign in
Already have an account? Sign in here.
Sign In Now