Forums

CC View action to link to another CC table?

farmington 10 Mar, 2015
I've gotten my CC tables to link fine to CF forms using the "linkable" attributes and the "Form Events" in the view and edit actions.

However, in another case, I would like one CC table to link to another CC table. So, the first would display a list of polls that people have voted in. The "View" link should then bring up another CC table that uses that selected poll_id to filter a set of results.

So, I would like clicking on the Poll Name in this view: https://thieves.demojoomla.com/view-polls
to bring up a filtered version of this view https://thieves.demojoomla.com/poll-results

I'm sure there's a very elegant solution for this, but I haven't been able to find it in the FAQ or forums.

Thanks
NickOg 11 Mar, 2015
I seem to be following in your foot steps.🙂

One could resort to adding a <a> tag to the data but hopefully there is some 'very elegant solution'.

My need is perhaps slightly different - to be able to have two edit links on the same connection - one to a form to edit a receipt and the other to a form to edit the bookings on that receipt.

is that possible?

Nick
farmington 12 Mar, 2015
:D Yes, we seem to be working on the same types of tasks with this great extension.
If you are linking to two CF forms, you could just use the View link and the Edit link to do two different things, and use the Form event attributes for the View and Edit actions link to the two CF forms. Or is one a link to a form, and the other a link to a different CC table?
I'm actually planning to use those two links separately as well - one will link to taking the poll, and the other will link to a CC table with the results of the poll. I'm just stuck on the code to use, in place of the FORM_NAME:EVENT_NAME structure that pops it to a CF form. I'm guessing it probably has something to do with passing a parameter in the URL string, and then setting up the second CC table to parse it, but I'm just not sure how to do it. It may have been addressed elsewhere in the forum, but I just haven't been able to find it.
NickOg 16 Mar, 2015
One approach that I thought I might take is to adapt the link that CC5 generates.
<a href="/index.php?option=com_chronoconnectivity5
      &cont=lists
      &ccname=TestBed
      &act=edit
      &Itemid=449
      &gcb=1800">
      1800
      </a>
      

and to hard code that into fields in the table that I generate.
[attachment=0]chronoMultiEdit.jpg[/attachment]
That is the link to 1800 in the second row. I thought that I could adapt that to link to a different form. I presume that Itemid=449 fields identifies the target form but have no idea where that comes form.😲

any ideas.

Regards

Nick
farmington 18 Mar, 2015
I believe that the itemid in that link refers to the menu item that opens that form. I've had to create menu items on a hidden menu that will link to these CF and CC forms, even though I never open them from a menu. It seems odd to me that the link isn't directly to a form id, but is to a menu's itemid. Perhaps there is a way to do it without the menu itemid, but I haven't found it.
kwok 04 Apr, 2015
I am also looking for a solution to link two CC:
CC #1 displays header file fields. The id of the header file is the foreign key of the detail file (say field offer_id).
id is set to be view linkable. Upon click, it should trigger CC #2 to display detail records that have offer_id = id.
This topic is locked and no more replies can be posted.