Hi everyone,
I have been using ChronoForms on my Joomla websites and I now install it on all my Joomla websites.
I have a new project to create a kind of listing webssite and I was told ChronoConnectivity is the way to go, but I'm stuck with a few problems:
[list] 1. How do I create a view file to view records from the ChronoConnectivity list[/list]
[list] 2. How do I restrict the number characters of returned text in the list using Javascript or PHP[/list]
[list] 3. How do I filter the listing to display a list based on URL e.g index.php/list?status=available[/list]
[list] 4. How do I integrate with ChronoForms for update and edit in the Front end? I don't get the instructions inside ChronoConnectivity[/list]
[list] 5. I need to link to the users table to get the users name and another table to get the picture. How do I go about that?[/list]
[list] 6. How do I create an advanced search form in ChronoForms and link it to ChronoConnectivity?[/list]
Thank you all for a great extension.
Regards,
Dan.
Hi Dan,
I will try to answer all your questions:
#1- You can simply use the auto listing, which is handled by Connectivity, or a custom listing, where you just use your own HTML code in the connection's configuration.
#2- There is a "Fields Limits" box for that feature, please check its description.
#3- There is a filter setting for that as well, please check the description, you will only need to provide the expected filter parameter name (status in your case).
#4- We have tutorials on this under the FAQs page.
#5- Please use the "Multi tables" settings for that, you will need to do this correctly, this is a faq tutorial on this part as well.
#6- You don't have to use both to build a search page, each one of them can do it, Chronoforms can handle this for simple stuff, Connectivity should give you more options.
Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
@max Thanks for the reply. But I still have some issues:
1. What I mean is that after creating the listing successfully, how can I create a details view so that when a user clicks on a record on the listing, the details of that record is displayed?
2. Thanks! I've been able to fix that.
3. I have entered the field name I want to use as search parameter in both 'search fields' and 'filter field names', but the listing is not being filtered to show only records containing the search parameter. How can I fix that?
4. Can you provide a link to the tutorial? The Connectivity on the only tutorial I saw does not look like the one I am using(v4.0 RC3.2). If there is no other tutorial, can someone kindly explain how to do this in my current version?
5. I can't find the FAQ tutorial, can you please post a link?
6. Okay. Can you kindly explain how do go about this on Connectivity? The form I want is kind of complex, and I want it to be on a standalone page.
Once again thanks.
Dan.
Hi Dan,
For the tutorials, please click the FAQ link above then select 'CCv4 Tutorials' in the Category drop-down.
Bob
Thanks Bob for pointing that out.
How about the rest? Numbers 1,3 and 6
Hello,
A bit late, sorry!
#1- You will need to assign a form to your connection, then add one or more of your connection fields to the "editable" fields list, clicking any of those fields will load the "on load" event of your form, if your form fields names match the table columns names then the data will be loaded into the fields, you may also use a "Show thanks message" action to parse the data.
#3- Did you try to pass the a value fort hat parameter in the query ? e.g:
connection_link?searc_param=search_vale
#6- Connectivity already has the feature ready out of the box as explained in #3, just set it up correctly and run the test above and hopefully it will work, if you are using a model id then the field name in the query should include that model id as well, did you simply try to enable the search box and use it ?
Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.