Secure online form submission for medical records

Hi Bob,
A couple of years ago Fredrik & you helped me set this up in Joomla 1.5. Once done worked beautifully.

Here's an outline of the setup we used:

When form is submitted, the info goes to site server database, a "thank you someone will follow up shortly" message appears, and an email is sent to the admin assistant notifying her of the submission. She then retrieves a formatted record for to create a patient folder.

We used ChronoConnectivity to format the retrieval.

Now we've upgraded to Joomla 2.5 and also needed to change web hosts. I have now upgraded to latest ChronoForms and ChronoConnectivity. I have the 2013 version of the form coded in html and have entered that as custom coding.

I've looked at the tutorials, tried entering the settings but fear I've got a ways to go. I'm not clear on correct setup for form events or for ChronoConnectivity.

When I submit a form, I get the thank you message but no email arrives.
Link to form front end:https://helptherapist.com/index.php?option=com_chronoforms&chronoform=rF2013-OLD

I vaguely remember there were ways to look for errors in emailing also. Perhaps you can remind me.

Thanks,
Scott

Hi Scott,

All I can tell from the front-end is that the form appears to submit correctly.

Please drag a Debugger action into the On Submit event, then submit the form and post the debug - including the 'dummy emails' results here.

Note: if you are using the Easy Wizard you can turn on Debug on the Others tab.

It may also help to check the Email FAQs for setup and common problems.

Bob

Hi Bob,
Below is what Debugger returned. Also, no tables were created it seems.
Thanks,
Scott

Data Array:

Array
(
    [option] => com_chronoforms
    [chronoform] => rF2013-OLD
    [event] => submit
    [Itemid] => 
    [Clients_name] => Scott Johnson
    [Date] => 
    [DOB] => 
    [Street_address] => 1234 Loire Circle
    [City] => San Diego
    [State] => CA
    [Zip] => 92131
    [Telephones] => 858-xxx-xxxx
    [Social_Security_Number] => 
    [Referred_by] => 
    [rPhone] => 858-xxx-xxxx
    [Agency_Name] => Scott Johnson
    [rFax] => 
    [rEmail] => scottxxx@gmail.com
    [rMd] => Scott Johnson
    [r2Phone] => 858-xxx-xxxx

    [mCal] => 
    [mCIDate] => 
    [Medicare_Number] => 
    [Primary_Insurance] => 
    [piid] => 
    [pigp] => 
    [Secondary_Insurance] => 
    [siid] => 
    [sigp] => 
    [Primary_Physician] => 
    [Telephone_Number] => 858-xxx-xxxx
    [psychiatrist] => Scott Johnson
    [psTelephone_Number] => 858-xxx-xxxx
    [Psychotropic_Meds] => 
    [Support_System] => 
    [Reason_For_Referral] => 
    [Notes] => 
    [1CLINICIAN_ASSIGNED] => 
    [acceptancedate] => 
    [REQUEST_FOR_PSYCHIATRIST] => 
    [psydate] => 
    [notes] => 
    [Submit] => Submit
    [fd89864d2ae0753ff74a90eb527350c1] => 1
)

Validation Errors:

Array
(
)

Bob, redid after watching email video with improved results.
received email body:

Submitted by 76.xx.xx.xx

Scott

Data Array:

Array
(
    [option] => com_chronoforms
    [tmpl] => component
    [chronoform] => rF2013-OLD
    [event] => submit
    [Itemid] => 
    [Clients_name] => David Johnson
    [Date] => 
    [DOB] => 
    [Street_address] => 1234 Scripps Ranch BLVD #xxx
    [City] => 
    [State] => 
    [Zip] => 92131-1825
    [Telephones] => 
    [Social_Security_Number] => 
    [Referred_by] => 
    [rPhone] => 
    [Agency_Name] => David Johnson
    [rFax] => 
    [rEmail] => scottxx@gmail.com
    [rMd] => David Johnson
    [r2Phone] => 
    [mCal] => 
    [mCIDate] => 
    [Medicare_Number] => 
    [Primary_Insurance] => 
    [piid] => 
    [pigp] => 
    [Secondary_Insurance] => 
    [siid] => 
    [sigp] => 
    [Primary_Physician] => 
    [Telephone_Number] => 
    [psychiatrist] => David Johnson
    [psTelephone_Number] => 
    [Psychotropic_Meds] => 
    [Support_System] => 
    [Reason_For_Referral] => 
    [Notes] => 
    [1CLINICIAN_ASSIGNED] => 
    [acceptancedate] => 
    [REQUEST_FOR_PSYCHIATRIST] => 
    [psydate] => 
    [notes] => 
    [Submit] => Submit
    [fd89864d2ae0753ff74a90eb527350c1] => 1
)

Validation Errors:

Array
(
)

Thank you for submitting your referral. You will be contacted by HELP.
Debug Data

    email
        3
            Result An email has been SENT successfully from (admin)webmaster@helptherapist.com to scottnsd@gmail.com
            Body Submitted by 76.89.76.76
            Attachments array ( )

Powered By ChronoForms - ChronoEngine.com

Hi Scott,

An empty email body suggests that there is no template set up - or an empty one.

This input starting with a number may well cause problems and should be changed. 1CLINICIAN_ASSIGNED

Bob

Bob,
I removed the number in front of client, Thanks.

The email is to notify Admin assistant that form has been submitted. I want only a brief message to her with link to report.

Here's message I had:

<p>Denise, A form has been submitted for</p>
<p><label>Client's name: {Clients_name} </label> <label>Date: {Date} </label></p>

It returned only the client's name.

This returned more (but not in desired form):

<p>
    <label>Client's name:  
      {Clients_name}: a from has been submitted for this client, Denise.
  </p>

 Debug Data

    email
        3
            Result An email has been SENT successfully from (admin)webmaster@helptherapist.com to scottnsd@gmail.com
            Body Client's name: scott: a from has been submitted for this client, Denise. Submitted by 76.89.xx.xx
            Attachments array ( )

Getting closer. Will experiment more.

What do I do to have the data stored in the database?

Best,
Scott

Hi Scott,

I'm not quite sure what <label> tags will do there, usually they are used with form inputs.

You can save the data with a DB Save action. Please see this FAQ

Bob

Hi Bob,

Thanks for the note on the<label>. Email set.

And Thanks for the link to the video - what I was looking for but missed. Is their a similar video for ChronoConnectivity?

When I create table the following is the result:

Check table query below:

CREATE TABLE IF NOT EXISTS `#__chronoforms_data_rF2013_OLD` ( `cf_id` INT(11) NOT NULL auto_increment, `cf_uid` VARCHAR(255) NOT NULL, `cf_created` DATETIME NOT NULL, `cf_modified` DATETIME NOT NULL, `cf_created_by` INT(11) NOT NULL, `cf_modified_by` INT(11) NOT NULL, `cf_ipaddress` VARCHAR(255) NOT NULL, `cf_user_id` INT(11) NOT NULL, `Clients_name` VARCHAR(255) NOT NULL, `Date` VARCHAR(255) NOT NULL, `DOB` VARCHAR(255) NOT NULL, `Street_address` VARCHAR(255) NOT NULL, `City` VARCHAR(255) NOT NULL, `State` VARCHAR(255) NOT NULL, `Zip` VARCHAR(255) NOT NULL, `Telephones` VARCHAR(255) NOT NULL, `Social_Security_Number` VARCHAR(255) NOT NULL, `Referred_by` VARCHAR(255) NOT NULL, `rPhone` VARCHAR(255) NOT NULL, `Agency_Name` VARCHAR(255) NOT NULL, `rFax` VARCHAR(255) NOT NULL, `rEmail` VARCHAR(255) NOT NULL, `rMd` VARCHAR(255) NOT NULL, `r2Phone` VARCHAR(255) NOT NULL, `mCal` VARCHAR(255) NOT NULL, `mCIDate` VARCHAR(255) NOT NULL, `Medicare_Number` VARCHAR(255) NOT NULL, `Primary_Insurance` VARCHAR(255) NOT NULL, `piid` VARCHAR(255) NOT NULL, `pigp` VARCHAR(255) NOT NULL, `Secondary_Insurance` VARCHAR(255) NOT NULL, `siid` VARCHAR(255) NOT NULL, `sigp` VARCHAR(255) NOT NULL, `Primary_Physician` VARCHAR(255) NOT NULL, `Telephone_Number` VARCHAR(255) NOT NULL, `psychiatrist` VARCHAR(255) NOT NULL, `psTelephone_Number` VARCHAR(255) NOT NULL, `Psychotropic_Meds` VARCHAR(255) NOT NULL, `Support_System` VARCHAR(255) NOT NULL, `Reason_For_Referral` VARCHAR(255) NOT NULL, `Notes` VARCHAR(255) NOT NULL, `CLINICIAN_ASSIGNED` VARCHAR(255) NOT NULL, `acceptancedate` VARCHAR(255) NOT NULL, `REQUEST_FOR_PSYCHIATRIST` VARCHAR(255) NOT NULL, `psydate` VARCHAR(255) NOT NULL, `notes` VARCHAR(255) NOT NULL, PRIMARY KEY (`cf_id`) );

No idea what the NOT NULL means here.

Thanks,
Scott

Hi Scott,

I tested your query in MYSQL Workbench and get the error message

Error Code: 1060. Duplicate column name 'notes'

For more about NOT NULL see this StackOverFlow answer

Bob

Hi Bob,

Renaming one of the "Notes" got it. Wonder why one duplicate field name returned all those NOT NULL errors. Will need to study MySQL.

Thanks for pointing this out and for the StackOverFlow link. I need to study MySQL more.

Now on to setting up ChronoConnectivity. Not clear from the tutorials & FAQs how to do this so Admin. Assist. can display one record at a time to print out. Any tips greatly appreciated.

Best,
Scott

Bob,

In ChronoConnectivity (CC) I've entered comma separated field names and set settings I've understood.

When I select "Front End View" in CC I receive this

        Access Denied.

Array
(
    [Approx_Memory_Usage] => 78760
    [Approx_Time] => 0.001115083694458
    [check_permissions] => Array
        (
            [list] => 0
        )

)

Admin List returns:

Array
(
    [Approx_Memory_Usage] => 1119576
    [Approx_Time] => 0.046802997589111
    [check_permissions] => Array
        (
            [list] => 1
            [search] => 0
        )

    [SQL] => Array
        (
            [0] => SELECT * FROM `tpi_chronoforms_data_referral2013` ORDER BY `cf_id` LIMIT 0,20
        )

    [data] => Array
        (
            [0] => Array
                (
                    [cf_id] => 1
                    [cf_uid] => 79b2180c02dea1868231d044c8a86967
                    [cf_created] => 2013-02-09 12:34:30
                    [cf_modified] => 0000-00-00 00:00:00
                    [cf_created_by] => 0
                    [cf_modified_by] => 0
                    [cf_ipaddress] => 76.89.76.76
                    [cf_user_id] => 0
                    [Clients_name] => Array
                        (
                        )

                    [Date] => 
                    [DOB] => 
                    [Street_address] => Array
                        (
                        )

                    [City] => 
                    [State] => 
                    [Zip] => Array
                        (
                        )

                    [Telephones] => 
                    [Social_Security_Number] => 
                    [Referred_by] => 
                    [rPhone] => 
                    [Agency_Name] => Array
                        (
                        )

                    [rFax] => 
                    [rEmail] => Array
                        (
                        )

                    [rMd] => Array
                        (
                        )

                    [r2Phone] => 
                    [mCal] => 
                    [mCIDate] => 
                    [Medicare_Number] => 
                    [Primary_Insurance] => 
                    [piid] => 
                    [pigp] => 
                    [Secondary_Insurance] => 
                    [siid] => 
                    [sigp] => 
                    [Primary_Physician] => 
                    [Telephone_Number] => 
                    [psychiatrist] => Array
                        (
                        )

                    [psTelephone_Number] => 
                    [Psychotropic_Meds] => 
                    [Support_System] => 
                    [Reason_For_Referral] => 
                    [Notes] => 
                    [CLINICIAN_ASSIGNED] => 
                    [acceptancedate] => 
                    [REQUEST_FOR_PSYCHIATRIST] => 
                    [psydate] => 
                    [cnotes] => 
                )

        )

)

There is this error when I submit data to the list:

Validation Errors:

Array
(
)

Not at all clear about what I'm missing...

Best,
Scott

Hi Scott,

The NOT NULL aren't errors, they are a normal part of the Create Table command.

I really don't know much about the new ChronoConnectivity. At a guess you haven't got front end permissions set up and you have some kind of debugger code turned on?

Bob

Hi Bob,

You were correct - I missed the front end permissions tab & I had ChronoConnectivity debugger on.

Selecting Front End View returns record number and CF_ID but no data:
https://helptherapist.com/index.php?option=com_chronoconnectivity&chronoconnection=ReferralSheet2013

Scott

Hi Scott,

Thanks for the link but it isn't publicly visible :-(

What do you have in the List View Fields box?

Bob

Hi Bob,
List View Fields box:

Clients_name,Date,DOB,Street_address,City,State,Zip,Telephones,Social_Security_Number,Referred_by,rPhone,Agency_Name,rFax,rEmail,rMd,r2Phone,mCal,mCIDate,Medicare_Number,Primary_Insurance,piid,pigp,Secondary_Insurance,siid,sigp,Primary_Physician,Telephone_Number,psychiatrist,psTelephone_Number,Psychotropic_Meds,Support_System,Reason_For_Referral,Notes,CLINICIAN_ASSIGNED,acceptancedate,REQUEST_FOR_PSYCHIATRIST,psydate,cnotes

For both Front End View and Admin List: with the addition of # CF_ID and these show across the top. Down the left are the record numbers. Data fields are blank.

Scott

Bob,
Here's photos of
Front End View:

&
Admin List:



Scott

Hi Scott,

So you are getting the column titles showing in place of the data for some columns and blanks for the remainder :-( I don't know how to do that . . . maybe Max will have a suggestion.

Bob

Thanks, Bob. I'll keep plugging away.

Should I move this to the CC forum or will Max see this here?

Best,
Scott

Hi Scott,

He'll probably see it here - but it might speed it up if you send the link to him through the Contact Us tab above.

Bob