1 Reply Latest reply on Dec 30, 2010 9:24 AM by philmodjunk

    How to Use Web Viewer?? Help!!

    MikeHaddon

      Title

      How to Use Web Viewer?? Help!!

      Post

      I finally got brave enough to insert a Web Viewer.  I am trying to create my own URL dynamically, and it never is going to a valid website.  (by the way, it would be nice to see what the dynamically created URL is, so I might see where I have gone wrong in constructing it).

      I track legislation in Utah.  Each bill can be viewed online at a consistently formatted URL.  Therefore, I am trying to allow users to view the online bill text using the Web Viewer.  The dynamic URL takes a couple fields in my table to create a viable URL.  Here is what I created:

      "http://le.utah.gov/~2011/bills/" & If (( GetField ( tblBills::House )="H") ; "hbillint/" ; "sbillint/" ) & GetField (tblBills::BillID)  & ".htm"

      Here is what it is supposed to do:

      1.  Insert the constant piece of the URL:  http://le.utah.gov/~2011/bills/

      2.  Now I need to determine if it is a House Bill or Senate Bill, as that will change the URL.  I have combined the If and GetField functions here.  It is getting the House field (either "H" or "S"), and then is supposed to be inserting the proper next string of the URL (either hbillint or sbillint)

      3.  Next I need to grab the actual bill number, so I have another GetField statement.  It should append the bill number into the string.

      4.  Finally, I append the ".htm" to complete the URL.

      So, for example, in my table for a specific bill, House="H" and BillID="HB0011"

      The URL string I was hoping to create would be:  http://le.utah.gov/~2011/bills/hbillint/hb0011.htm

      If you go to that URL,  you will see it the text of that bill.  Can anyone tell me where this is messed up?  Thanks!

        • 1. Re: How to Use Web Viewer?? Help!!
          philmodjunk

          I don't think you need get field here. Get field allows you to access the contents of a field whose field name is the parameter. Thus, GetField ( tblBills::House )="H" is comparing the contents of the field whose name is stored in tblBills::House to the letter H.

          it would be nice to see what the dynamically created URL is, so I might see where I have gone wrong in constructing it

          Copy and paste your expression into a Show Custom Dialog script step or a calculation field set to return text.