Forums

I have an image map of counties each with a unique url to connect with a chronoform that will send back a report of that county's statistics, but I am not sure how to write the url or what code to put into the report code. Should the unique url look something like this?

http://www.domainname.com/index.php?option=com_chronocontact&chronoformname=CountyReport&County=Allen

What code do I put into the chronoform report code to select just the row with Allen as the county name?

Thanks for your help.

Actually, I know how to write the MySQL query, just not sure how to make the county variable Allen.

Hi rstevens,

You can use a DB Record Loader in the On Load action with County as the 'Token' name. That will let you check the database for the record that matched the value of County.

Bob

Thanks!

I tried to buy you a beer, but when I click on checkout, I am returned to an empty form even though there is one item in my cart. I can't get to the form for my credit card information.

In any case, I realized your reply did not answer my question because I do not want to create 92 form for 92 counties. I want to create one form that will use the name of county I select in the image map to return the row for that county.

Problem solved, but I still don't know how to buy you a beer.

Hi rstevens,

Sorry to hear that you had a problem with the beer-buying checkout* - I have had a couple bought today so you may have hit a bad time :-(

The parameter suggestion I made will allow you to use one form for all the countries.

Bob

* I just checked and it works here - though you have to click the Process Order button at the last step. I should probably remove the basket - it's mostly there to help people who buy several items at the same time but they are the minority of users.