Chronoform to Chronoconnectivity

Hi again!

I've installed connectivity now, but as I'm using IE7, I've had to patch it with an updated admin.php file found in the forum, as the input screen was blank!

I've made a basic connection that lists the match details I am after, which is fantastic for now, but the volume of data will soon become to large to display on screen.

I was thinking that a Chronoform linking to the connection limits the query to a specific date would be a good starting point. How can I link the action on a button in a chronoform to a connection?

Hi Jim,

Well, why you just stay displaying all data but at the same time display a pagination support at the end of the page ? so user can select less records..look at the legend tab for how to show pagination!🙂

let me know how it goes!

Max

Hi Max,

now you've helped me with the other error I was getting due to my table, I've come back to trying this one.

I've created 2 connectors on the same table, so I can show a long list of matches (with pagination as suggested), with hyperlinks to the details of the individual match.

http://www.eddpl.co.uk/index.php?option=com_chronoconnectivity&connectionname=match-list

The website covers two divisions, and 13 matches per week, so I'd like to be able to give the users a form where they can select which week, which division etc, as the intent for this page is to allow members to contest a published result.

I've tried to create a chronoform to that allows you to select the match by number, and send the results to the connector in the same way the 2 connectors interact, but I've not been able to get it to work yet.

I've tried changing between PUT and GET and I've changed the ACTION URL to
"/index.php?option=com_chronoconnectivity&connectionname=test"
but I'm unable to get the chronoform to add the cf_id field to the end of the url, eg:
/index.php?option=com_chronoconnectivity&connectionname=test&cf_id=5

Where am I going wrong? I've only made forms in Chrono, though I have been manually creating the HTML / javascript for them in notepad++ while I learn, so I may be missing something obvious! 🤣

Jim

Hi Jim,

just use the Chronoform and make the action URL : index.php?option=com_chronoconnectivity&connectionname=test

now at the connection page, in the WHERE statement write : WHERE week='<?php echo $_POST['week_field_name_in_Chronoform']; ?>'

how does this work ?

Hi Max,

yes, that works perfectly. 😀

I now have:
a form to select match date;
a connection to display brief details for that date;
another connection to show full details for the selected match.

all working from here if you are interested:
http://www.eddpl.co.uk/index.php?option=com_chronocontact&chronoformname=find-match-results
(note only matches on 1st september so far!)

Just need a bit of HTML needed to smarten the layout, plus I think I may be better off using the smoothbox to show the full details. Can smoothbox be used to bring up another connection, or will I have to have the full data view as part of my list of matches, but within a smoothbox class? Another new toy for me to try out!

Hi jim,

Can smoothbox be used to bring up another connection,

No

or will I have to have the full data view as part of my list of matches, but within a smoothbox class?

yes!

Cheers

Max

Thanks again Max!

This looks brilliant, I've had to do a little messing with smoothbox to get it going. I'm using field names in curly brackets as DIV IDs, and in the smoothbox details, and its all good except the 'tip' element of the smoothbox. I didn't necessarily want the tips, but I get an object error for a NULL object without it.

I'm using something like:
<a class="smoothbox" name="{HomeTeam} Vs {AwayTeam}" href="#TB_inline?height=450&width=350&inlineId=match_{cf_id}_box" id="match_{cf_id}" >Details</a>
for the hyperlink, then 2 divs for the box and the tip:

<div id="match_{cf_id}_box" style="display: none;">

<div id="match_{cf_id}_tip" style="display: none;">

The smoothbox is fine, but strangely the tip is giving a full URL for the form! 😲 I'll keep plugging away!

ah, I finally got it (thanks to viewing source on your FAQ page!)

I needed to end the text within the _TIP DIV with ::

Thanks again, what a top Joomla! extension! 8)