form html revised; outputs to old version

The setup: forms are submitted securely and when a form is submitted an email is sent to the admin assist letting her know. She then logs in and retrieves the form and prints it out. We're using ChronoForms/Chronoconnectivity to do this.

Client decided she wanted some of the text areas changed. Made changes in html and replaced the html in ChronoForms. New version shows up correctly on website. When I fill it in with test data then access it - or client accesses it - it's still the old version.

What am I missing?

Thanks and best wishes for a healthy and prosperous new year.

Scott

Hi Scott,

There's nothing clever in ChronoForms that would do this. Is site caching enabled? Are you working on the right version of the site (I've worked on a test site before instead of the live site and had the same problem)?

Bob

Thanks, Bob. Was hoping there was.

Working on correct version. System cache set to off. Cleaned cache for modules that use it.

I did have a copy of the form with same name (I had used as a backup). I changed it's name to try to fix this. Would that have caused this (they both use same database table name)? If so, how would I safely repair this?

Hi Scott,

Never have copies of the form with the same name, change one to make it different e.g. my_form_backup.

ChronoForms uses the name to get the form info from the database to display it. If you have two forms with the same name then you will get whichever version MySQL finds first. In my experience that's usually the older one but it could be either.

Bob

Hi Bob,

I seem to learn everything the hard way - could have read the warning in red...

Now, I've changed the names of the backup databases but the problem persists. I'm guessing there's something in the database tables that needs to be cleared. Suggestions?

Thanks,

Scott

Hi Scott,

Have you changed the names of the *forms* so that there aren't any duplicates?

Bob

Hi Bob,

In Forms Manager I opened each form and renamed all but the new one as such, referral_sheet2, referral_sheet3. Originally they were all referral_sheet.

Now referral_sheet is the new version we want to use and referral_sheet2 & referral_sheet3 are the backups.

Hi Scott,

That's good - and you are still seeing different versions show up from the same form link?

Bob

Hi Bob,

Yes.

Scott

Hi Scott

Then I'm out of ideas . . . if it's not a cached version; not a duplicate form; and not a duplicate site then I don't know what it is :-(

Bob

I think it has to do with the database tables. They each have used the same ones.

I think I create a new form - identical html but new name and replace current one with it.
If I knew more about Databases, I'd clean out for data in the tables and start over.

Hi Bob,

I didn't update the admin settings (Data View Fields Names & Data View Columns titles) in ChronConnectivity. It will thus only show the old fields which are still there.

Best,

Scott

Update:
In ChronoConnectivity, under the General tab, I edited the body section of the connection view settings to correspond with the new form html. Saved. No change in the fields in the database. Also, no change in the Data View Fields Names under the Admin Settings.

Q: How do I update these areas so the change is reflected in the database fields and so in the form the admin assistant sees?

Thanks,

Scott

Hi Scott,

Sorry, I don't understand how all of this links together? I thought that the problem was that you were calling a form from a form link and getting different versions of the form displaying??

Even so, if the form name is still the same as far as I can see you shouldn't need to make any changes in ChronoConnectivity. Nor should the database have anything to do with it.

Puzzled ? ? ?

Bob

Hi Bob,

Sorry I'm not being more clear.

I, too, thought minor changes in the html of the form code would be accommodated automatically.

When I edited the html, some field names were added; others changed. These changes were not reflected in the database table used by the form.

Since the admin assistant retrieves the form info from the server where the submitted data are stored via ChronoConnectivity, I thought that by editing that the database table would be updated to reflect the changed field names. Didn't happen.

Review: the changed form shows up correctly on the website. When filled and submitted an email is sent to admin assist. What she finds (and I too when I go in the back way) is the old version filled in with the new info where there are fields for them.

Example:
Say old version had fields for name, address, and phone.
Say new version has these fields plus email address.
Submitted form: name, address, phone, email.
Received form: name, address, phone (no email).

Hope something in this clarification triggers an "ah ha."

Best,

Scott

Hi Bob,

Owner is desperate to get this fixed ASAP. Please, add any suggestions you might have.

Scott

Hi Bob,

Some progress but owner, admin assist impatient.

The new fields now come through but unformated:

HELP Referral Sheets denise zirpolo record number: 370 Record time: 2012-01-03 - 13:23:07 Client's Name: denise zirpolo Date: Birthdate: Street Address: City: State: Zip: Telephone 1: {phones} Telephone 2: {phones2} SSN: Referred by: {referredby} Referrer's phone: {rphone} Agency: {agency_name:} Fax#:{rfax} Email: {remail} Referring MD Name: {rmdname} Phone:{rmdphone} Insurance Verification Info: {insuranceinfo} Medicare #: Effective Date: Secondary Insurance: {otherinsurance} ID Number: {second_ins} Group#: {second_ins_group} Primary MD: {primaryphysician} P.'s Phone:{telephone} Psychiatrist: Psychiatrist phone:{telephonenumber:} Reason for referral: {reasonforreferral:} Psychotropic Meds: {psychotropicmeds} Client's Support System: {clientssupport} 1st Clinician Assigned {first_clinician} Sent Date:{sent_date} Acceptance date: 2nd Clinician Assigned: {second_clinician} Reason: {reason} Sent Date: {second_sent_date} Acceptance date: {accept_date2} New Record Edit Record Delete Record
This is the end of the this referral sheet record.

I have no idea what caused the change unless it is reflecting the edits I made under the General tab in Chronoconnectivity after some delay in the server.

Will tinker more with ChronoConnectivity to get it formatted but not clearly understanding the flow.

Suggestions?

Some progress: formatted but not all fields are populating. Some data here is dummy but otherwise all fields were entered in submitted form:

Scott Johnson
record number: 373
Record time: 2012-01-03 - 17:44:40

Client's Name : Scott Johnson Date: Birthdate:
Street Address: 12000 Loire City: San Diego State: CA Zip: 92101 Telephone 1: {phones} Telephone 2: {phones2} SSN: 2345453657

Referred by: {referredby} Referrer's phone: {rphone}
Agency: {agency_name:} Fax#: {rfax}
Email: {remail}

Referring MD Name: {rmdname} Phone: {rmdphone}

Insurance Verification Info: {insuranceinfo}
Medicare #: dffg Effective Date: dgff
Secondary Insurance: {otherinsurance}
ID Number: {second_ins} Group#: {second_ins_group}

Primary MD: {primaryphysician} P.'s Phone: {telephone}
Psychiatrist: der565 Psychiatrist phone: {telephonenumber:}

Reason for referral: {reasonforreferral:}

Psychotropic Meds: {psychotropicmeds}
Client's Support System: {clientssupport}

1st Clinician Assigned: {first_clinician}
Sent Date: {sent_date} Acceptance date:

2nd Clinician Assigned: {second_clinician} Reason: {reason}
Sent Date: {second_sent_date} Acceptance date: {accept_date2}

Also, when I look at "Show Data" in Forms Manager
1. No data shows
2. New data field headers are there

When I then click on one of the records to edit, the data I entered is there.

I think the fields that return the {field names} are the edited fields - the ones I've changed but have not been able to change in the Data View Fields Names of the Admin settings tab.

How to update that?

Ran form with debug on:

Form passed first SPAM check OK
Form passed the submissions limit (if enabled) OK
Form passed the Image verification (if enabled) OK
Form passed the server side validation (if enabled) OK
$_POST Array: Array ( [Clients_name] => xxxxx [Date] => today [DOB] => long time [Street_address] => 9974 way [City] => San Diego [State] => CA [Zip] => 92103 [Telephones] => 5555555558 [textfield] => 555555555 [Social_Security_Number] => 45657ryjeghj [Referred_by] => test 9 [rPhone] => 34345 [Agency_Name] => xxxx John [rfax] => w435 [remail] => [email]scoddd@mail.com[/email] [rmdname] => xxxx yyyy [rmdphone] => 35435 [Insurance_verification] => sfsfgjfghmgjh,h, [Medicare_Number] => 34345 [Effective_Date] => 335 [Other_Insurance] => sfsfg [2nd_ins_id] => 3545 [2nd_ins_group] => 535 [Primary_Physician] => dfyhj [Telephone_Number] => sfgsfghj [psychiatrist] => dfhfhj [psTelephone_Number] => sfgrh [Reason_For_Referral] => sdvdgnfn [Psychotropic_Meds] => csfgn [Clients_Support_System] => xfbfhn [1st_clinician] => dghfj [sent_date] => sfbfn [textfield3] => sfbdgn [second_clinician] => sdfbf [reason] => cvb [second_sent_date] => xcbvbn [accept_date] => zvd [Submit] => Submit [edf0d0b170b18544df2f30a82b8d6386] => 1 [1cf1] => ce9f68c512d7d042a2c9271748b9e6c7 [chronoformname] => referral_sheet )
$_FILES Array: Array ( )
Form passed the plugins step (if enabled) OK
An email has been SENT successfully from (form)form@cccc.com to [email]deni@ccc.com[/email]
Debug End

Am editing database columns in phpMyAdmin. Have not figured out how to add new columns.
1. Is editing database columns the way to fix this?
2. If so, how to add new columns? [edit: found it; now adding and editing - Scott]
Thanks,
Scott

Hi Bob,

I've edited and submitted some forms. There are still some fields which are not filling in with the data I enter. Will see if server resets or whatever it did overnight yesterday.

Meanwhile, I think the field names (id) in the form and in the body of General tab in ChronoConnectivity are the same. What else might be off?

Thanks,
Scott

Nothing changed overnight. Suggestions?
Thanks,
Scott

Hi Bob,

Clues: browsing SQL results shows
1. Not all data fields filled.
2. Some of the filled ones are newly added or edited so it's not rejecting edits out of hand.

Will look again at ChronoForm html and database field names.

Other thoughts welcome.

Scott

Hi Bob,

The form html, the ChronoConnectivity code for body under General tab and sql column names are all the same. That is,
Report sample:

Primary_MD: Telephone_Number
Psychiatrist: Scott Johnson psTelephone_Number {telephonenumber:}

Reason_for_referral: {reasonforreferral:}

Form code for same area:

 <p>
    <label>PRIMARY PHYSICIAN:
      <input name="Primary_MD" type="text" id="primaryphysician" size="30" maxlength="40" />
    </label>
    <label>PHONE:
      <input name="Telephone_Number" type="text" id="telephone" size="15" maxlength="20" />
    </label>
  </p>
  <p>
    <label>PSYCHIATRIST:
      <input name="psychiatrist" type="text" id="psychiatrist:" size="40" maxlength="40" />
    </label>
    <label>PHONE:
      <input name="psTelephone_Number" type="text" id="telephonenumber:" size="15" maxlength="15" />
    </label>
  </p>
  <p>
    <label><strong>REASON FOR REFERRAL:
      </strong>
      <textarea name="Reason_For_Referral" id="reasonforreferral:" cols="75" type="text" rows="10"></textarea>
    </label>
</p> 

Connection View Settings in ChronoConnectivity:

<p><strong>Primary_MD: </strong> {primaryphysician}  <strong> Telephone_Number </strong>{telephone} <br>
    <strong>Psychiatrist: </strong>{psychiatrist}  <strong>psTelephone_Number  </strong>{telephonenumber:}
  <p><strong>Reason_for_referral: </strong> {reasonforreferral:}

From database:

primaryphysician varchar(255) utf8_general_ci No None
telephone varchar(255) utf8_general_ci No None
psychiatrist varchar(255) utf8_general_ci No None
telephonenumber varchar(255) utf8_general_ci No None
reasonforreferral text utf8_general_ci No None

What am I overlooking?

Feels so close but....maybe it's better to take a fresh start. How would I do that? Change name of form, set up new Chronoform and Chronoconnectivity files?

Thanks,

Scott

Hi Scott,

The only real problem that I can see is that the names don't all match up. I made a table of (a) the column names from the Database tabke; (b) the form input names and (c) the names in the ChronoConnectivity body box and only a few of them match exactly.

You also have a few names that start with numbers - which are not permitted; and a couple of entries in the CC Listing with colons at the end which mismatch them.

Bob

Thank you, Bob for looking at this and preparing this table.

Will use tables going forward; much better than tabbing back and forth.

Best,
Scott

Hi Bob,

Reconciling these fixed 99%

Exception:Client's Support System.

Database:

clientsupport

Form input name:

<p>
    <label>CLIENT'S SUPPORT SYSTEM:
      <textarea name="clientsupport" cols="75" rows="4" id="clientsupport"></textarea>
    </label>
  </p>

CC listing:

    <strong>Clients_Support_System: </strong> {clientsupport}
  

I reconciled by cutting/pasting.

Scott

Hi Scott,

That one seems to be working OK now too.

Bob

Hi Bob,

Yes. Did you do something or was it a matter of something working it's way through the system?

Thank you.

Scott

Hi Scott,

I didn't so anything except check the names for that item and post a test form to see what was happening.

Bob