Extra actions on a ChronoConnectivity?

Hi,

I'm building with ChronoConnectivity and so far the results are great. I really like the product and if it continues to do what i want I surely will pay the $25 to support the dev.

Currently I'm stuck with an idea..before testing it endlessly I would like to know if it's possible at all:

I have created a ChronoConnectivity page where the user can select multiple options...
Now I want this top happen:
1) For certain options the users MUST make a selection...if the user doens't make a selection the search should not run.
Do I enter this in the header? Do I need to use another script?

2) I would like to give the user the possibility to add a name and email adres before he presses the submit button.
If the user did indeed fill out his name and userID (if an email is given the username may not be blank) then the following actions should happen:

Once submitted ofcourse the data should be displayed on the screen;
The data should be emailed to the user.
The users email and name should be stored in a database. If at all possible: in the table that is used for the module CCNewsletter!
(and to make this more complex: if the user is already in that table..he should not be added but the email should still be sent)

Most code to add/check the name/email in the CCnewslettertable I asume I can reuse from CCnewsletter?

So..this is quite some requests and I'm sure it will take a lot of code..but I wonder: would this be possible to intergrate?

Hi DannyH,

You can do this with ChronoForms pretty easily . . . I don't know about ChronoConnectivity, it's not intended for this kind of work though it may be possible.

Bob

Hi Bob,

This is the bigger picture maybe I shouldn't use ChronoConnectivity at all?

A user makes a couple selections, the result is displayed on a page and, if selected, the data is emailed to the user.

Option 1 (values:1,2,3,4) required
Option 2 (values:a,b,c,d) required
Option 3 (values a1,b1,b2) optional
Option 4 (values dd,ee,vv,ee) optional
enter name (required if email is entered in else optional)
enter email (optional)
send email/agreem to terms: Tick box. (required if email is entered out else optional)

submit/search

All the options are predefined option 2 is a huge list of placenames.

So: after submit the results of the search should be displayed and the email send. Ofcourse only after checking if the required fields are correct.

Which should I use: Chronoforms? Or ChronoConnectivity?

Danny

Hi Danny,

ChronoForms without any doubt (in my mind at least). It has all the functionality you need to do this, with a bit of coding needed to do the selections.

ChronoConnectivity is the tool to use when you want to display a list of similar results from a database table - like twenty users, or a list of hotels.

Bob

Okay. Chronoforms it is...I will play around with that for a bit.

Now comes the tricky part.
All the possible options a user can select from are in different tables in the same (joomla) database.
I would *love* to see that the values a client can choose from in his drop downbox be filled with the contents of the tables automatically. Besides my own skills, would anything in Choroforms stop me from doing this?

Then, after the user made the selections the query should run and display the data as a result list. I've not got this one working but I asume I will be able to. Emailing the results would be the next step. So far I can only email the entered information..not the queried information.
I assume this content should be placed in : On Submit code - after (of before) sending email?
What if I don't want to recieve an email? Will this code still works?

Finally I want to store the users email (if correctly) in a CCnewsletter table (with his name) but also in a different table I want to the other options he choosen. Should this extra save be done in: "Saving Data/Emails order" (i thought I read something in a post along those lines. In this case the update for CCnewsletter should be done in Saving Data/emails order and have the values from the selection besaved by CF?

Am I correct his is all possible but it will just take a LOT of coding?

ps: with your one liner about chronoconnectivity I just thought up for a wonderfull usage!

Hi Dannyh,

You can certainly get database entries and show them in dropdowns. Here's an example that I happen to have in front of me

<?php
$db =& JFactory::getDBO():
$query = //some sql
$db->setQuery($query);
$table_fields = $db->loadResultList();
        foreach ( $table_fields[$tablename] as $k => $v) {
            $fields_array[$k] = JHTML::_('select.option', JText::_($k));
        }

    	echo JHTML::_('select.genericlist', $fields_array,
                'params[field_name]', '', 'value', 'text',
                '', 'field_name' );

This isn't perfect for what you want but it will give you the idea.

It doesn't matter enormously which OnSubmit box you use - excpet for the obvious, if you want to affect the email you have to use the Before box. HTML+PHP in either box will output to the browser.

You can add to more than one table automatically (I think) but this works best if the column names are planned so that only those with shared values have shared names.

Bob

Hi Bob,

Thanks for the suggestion. Just now I've placed a post in the paid serivces...seems I will be able to do it myself but although the idea is clear in my head I'm missing to much hands on knowledge do to this myself in a reasonable enough time. (although reasonable can be streched if it will be costly🙂 ).