Web object getting data from fields

[Answers]

This seems like a fairly simple problem,. perhaps I am missing something. I previously had a web object on a layout that would grab information from 2 fields, so the result of the search would be displayed for that record. The web address I used before in my web viewer: Case( CARRIERS::MC# > ""; "http://li-public.fmcsa.dot.gov/LIVIEW/pkg_carrquery.prc_carrlist?n_dotno=&s_prefix=MC&n_docketno="&CARRIERS::MC# &"&s_legalname=&s_dbaname=&s_state=~~&pv_vpath=LIVIEW "; CARRIERS::FF# > ""; "http://li-public.fmcsa.dot.gov/LIVIEW/pkg_carrquery.prc_carrlist?n_dotno=&s_prefix=FF&n_docketno="&CARRIERS::FF# &"&s_legalname=&s_dbaname=&s_state=~~&pv_vpath=LIVIEW ")

Now the website has changed and I can't seem to have it grab the information to display in the record..The website is: "https://safer.fmcsa.dot.gov/CompanySnapshot.aspx" and basically I want it to fill in the MC#, I've tried using the method I used before. I viewed the source of the website but cannot seem to figure out the correct syntax.

Any help would be greatly appreciated.

[Steve Martino]

If I follow correctly, you want to take a value in your database and put it in the form on the website?

[Steve Martino]

Lines 56-69

 

<TH SCOPE="ROW"><div class="hidden">Information</div></TH>

<TD NOWRAP="nowrap"><input id="1" type="radio" name="query_param" value="USDOT"

checked>  

<LABEL for="1">USDOT Number</LABEL></TD>

<TD NOWRAP="nowrap"><input id="2" type="radio" name="query_param" value="MC_MX"

>

<LABEL for="2">MC/MX Number</LABEL></TD>

<TD NOWRAP="nowrap"><input id="3" type="radio" name="query_param" value="NAME"

 

You'll need to move 'checked' to after "MC_MX to have 'MC_MX' checked as default, then you can put your number into the search box.

[Answers]

On 7/9/2018 at 4:16 PM, Steve Martino said:

Lines 56-69

 

<TH SCOPE="ROW"><div class="hidden">Information</div></TH>

<TD NOWRAP="nowrap"><input id="1" type="radio" name="query_param" value="USDOT"

checked>  

<LABEL for="1">USDOT Number</LABEL></TD>

<TD NOWRAP="nowrap"><input id="2" type="radio" name="query_param" value="MC_MX"

>

<LABEL for="2">MC/MX Number</LABEL></TD>

<TD NOWRAP="nowrap"><input id="3" type="radio" name="query_param" value="NAME"

 

You'll need to move 'checked' to after "MC_MX to have 'MC_MX' checked as default, then you can put your number into the search box.

Hi Steve,

Yes you were correct, pass a value from our database to the web form. Thank you so much for your reply. I'm going to try it right now!

Caroline

[Answers]

Solution at last!

Anyway this is what I put in my web viewer object, "https://safer.fmcsa.dot.gov/query.asp?searchtype=ANY&query_type=queryCarrierSnapshot&query_param=MC_MX&query_string="&CARRIERS::MC#