Links in 2 Connectivity problem

Hi All,

I am pleased to see the new version of Chronoform & ChronoConnectivity😀 realy nice work !

I encounter a problem ( a noob problem😶 ) with relation in two Connectivity table.
I wish some fields become clickable to link to another chronoConnectivity.
eg: Client A >>> Item A / B / C

My first chronoConnectivity table works fine with the custom Listing Settings.

I made a sketch to explain what I want to achieve, perhaps the solution is in the Linkable Field ? but I do not understand how to use it..

My sketch :



Could someone help me please ?

Hi dec13els,

I'm not very familiar with the new ChronoConnectivity but looking at the hint text I don't think the Linkable Fields will do what you need (they seem to be linked to built in tasks). My best guess is that you need to do this with the Custom Listing Settings where you can build a standard <a> tag link to the second listing.

Bob

Thank you Bob for your help.

I tried to extract the field variable using session and to switch it in my second connectivity, but does not work. I also tried ($variable = $MyRow->field) and ($variable = $row->field) without success.

Do you have any idea ?

My fist connectivity Body :

    <tr<?php if ($i % 2) echo ' style="background-color: #E1E1E1;"';?>>
    <td><div>{proprio_deno}</div></td>
    <td><div>
<?php
// Get the field & set variable to export
$session = JFactory::getSession();
$session->set('proprio_nom', $export_nom);
echo $export_nom;
?>
<a href="index.php?option=com_chronoconnectivity&chronoconnection=liste_client2">
{proprio_nom} {proprio_prenom}</a></div></td>
    <td><div>{proprio_secteur}</div></td>
    <td><div>{proprio_adresse}</div></td>
    <td><div>{proprio_postal}</div></td>
    <td><div>{proprio_ville}</div></td>
    <td><div>{proprio_tel}</div></td>
    <td><div>{proprio_mail}</div></td>
    <td><div>{_EDIT_}|{_DELETE_}</div></td>
</tr>
<?php $i++ ?>

My 2nd CC WHERE code :

proprio_nom = '
<?php
// Get the variable from CC1
$session = JFactory::getSession();
$export_nom = $session->get('proprio_nom');
echo $export_nom;
?>'

Now, the sessions code work. But i can't set my field in variable😢

of course $nom= '{proprio_nom}' is not working, can someone tell me by what I can replace it ?

My Body code for CC1

$nom= '{proprio_nom}';
$session = JFactory::getSession();
$session->set('nom', $nom);

My WHERE box code for CC2

proprio_nom = "
<?php
$session = JFactory::getSession();
echo $session->get('nom');
?>"

I found this solution, works fine for me 😀

The link field in body CC1

<a href="index.php?option=com_chronoconnectivity&chronoconnection=liste_client + &record_selector={cf_id}">{proprio_nom} {proprio_prenom}</a>

The WHERE code in CC2

cf_id="<?php echo JRequest::getVar('record_selector') ; ?>"

Hi dec13els,

Well done :-)

Bob

yes thank Bob, but i have a new problem :mrgreen:

the cf_id are different between my two table.. :? and I forgot it..

Why in my href link &record_selector={cf_id} works and &record_selector={proprio_nom} not ?

can i export other field than cf_id with my href link ?

Any idea ?

Hi dec13els,

I think that the difference is that the {column_name} format will work on HTML but not in PHP tags; there you need to use $row (at least I think it is now $row) for example $row['proprio_nom']

Bob

Thank you Bob 😀

Variable code :

$proprio_nom = $row['proprio_nom'];

Link code :

<a href="index.php?option=com_chronoconnectivity&chronoconnection=liste_bien + &record_selector=<? echo $proprio_nom ?>">{proprio_nom} {proprio_prenom}</a>

The link works !