This topic is locked
[SOLVED]

 UPS Tracking Field

5/13/2008 9:22:12 AM
ASPRunnerPro General questions
M
mardisr author

In my package details table i have a tracking number field i.e. 1z564646465465656546456 If possible how can i make this field a link when clicked will store the value and goto another page like an xml lookup to pull tracking information on a package. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8464&image=1&table=forumtopics' class='bbc_emoticon' alt=':huh:' />

J
Jane 5/13/2008

Robert,
use Custom format on the "View as" settings dialog on the Visual Editor tab.

Here is a sample:

strValue = "< href=""http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status&tracknums_displayed=1&TypeOfInquiryNumber=T&loc=en_US&InquiryNumber1="; & strValue & "&track.x=0&track.y=0"">" & strValue & "</a>"

M
mardisr author 5/13/2008

Robert,

use Custom format on the "View as" settings dialog on the Visual Editor tab.

Here is a sample:



I tried the solution buy it only displays the text as copied into the view as custom. Is there something else i need to do <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=29205&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />

Admin 5/13/2008

Here is the correct one:

strValue = "<a href=""http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status&tracknums_displayed=1&TypeOfInquiryNumber=T&loc=en_US&InquiryNumber1="; & strValue & "&track.x=0&track.y=0"">" & strValue & "</a>"
M
mardisr author 5/13/2008

Here is the correct one:


strValue = "<a href=""http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status&tracknums_displayed=1&TypeOfInquiryNumber=T&loc=en_US&InquiryNumber1="; & strValue & "&track.x=0&track.y=0"">" & strValue & "</a>"



This works great but is there a way too open it in another windows so that if the user closes the windows it won't close the app.
Secondary to this is there a way to also get Fedex numbers and use if structures to distinguish which code to use i.e.
If field like '1Z' then use this code

Else

Use this code

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=29210&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />

J
Jane 5/14/2008

Robert,
please check this code:

if Ucase(left(strValue,2))="1Z" then

strValue = "<a target=_blank href=""http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status&tracknums_displayed=1&TypeOfInquiryNumber=T&loc=en_US&InquiryNumber1="; & strValue & "&track.x=0&track.y=0"">" & strValue & "</a>"

else

'another code

end if

M
mardisr author 5/14/2008

Robert,

please check this code:



Again another successful fix. This company by far provides the "Best Support". Thank you very very much. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=29251&image=1&table=forumreplies' class='bbc_emoticon' alt=':P' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=29251&image=2&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />

M
mardisr author 5/14/2008



Again another successful fix. This company by far provides the "Best Support". Thank you very very much. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=29260&image=1&table=forumreplies' class='bbc_emoticon' alt=':P' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=29260&image=2&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />



I have one more request on this post. Is it possible to also define the color of the link. I have tried several things but they fail as this has become a complex link. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=29260&image=3&table=forumreplies' class='bbcemoticon' alt='<<' />

J
Jane 5/14/2008

Robert,
please see my changes in Bold:

strValue = "<a style=""color:red;"" target=_blank href=""http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status&tracknums_displayed=1&TypeOfInquiryNumber=T&loc=en_US&InquiryNumber1="; & strValue & "&track.x=0&track.y=0"">" & strValue & "</a>"

M
mardisr author 5/14/2008

Robert,

please see my changes in Bold:



Works Great!!!!!!!!! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=29266&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=29266&image=2&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />