Forums

DB Save and Emails worked prior. I added Google Save - works great. Field names are setup as GSheet[firstname] for example.

Debugger shows emails being sent - all fields are empty. No emails are actually coming through now (and not in spam).

DB Save is only saving the cf_id, uniq_id, user_id, and created. No other fields are populating in the table. Setup is:
[list]Save Under Model ID: Yes
Model Id: GSheet[/list]

What am I missing?

Hi mduda,

Did you change the input names to work with Google Save? If so then you need to change the Email template to match the new names. The same with the DB Save action - but here it may be enough to set the Model ID to GSheet.

Bob

Yes, you are correct - I had changed the names to work w/Google Save. I have since changed the names to coincide with the model, and they are now loading😀 The one I was missing was the dynamic email! Changed it to the model, and we are in business! Still not getting other emails, but I think that is a hosting issue - as I'm testing it on a temporary url.

The DB Save - enabled to save under Model and set the Model ID to GSheet, The field names in the actual table do not have the model array format...just the actual field name. Do I need to save the table using the model array format - example GSheet[firstname] ? That seems odd. Or is there a custom code I need to use to separate the model prior to saving? What do you think?

Hi mduda,

It sounds as though you have the DB Save set up correctly - I'm not sure why it isn't saving all the columns. Please drag a Debugger action into the On Submit event, then submit the form and post the debug results here.

Bob

Here's the debugger...

Array
(
    [GSheet] => Array
        (
            [user_id] => 835
            [firstname] => Willy
            [lastname] => Wonka
            [email] => mduda14@comcast.net
            [phone] => 8326276531
            [emergencyname] => Geoff
            [emergencyphone] => 1111111111
            [student1name] => Will
            [student1grade] => 11
            [student2name] => 
            [student2grade] => 
            [student3name] => 
            [student3grade] => 
            [volunteerareas] => check_all,Main Office Helper,Workroom,Textbook Room,Spirit Wear,Nurse,Communications,PTSA/Student Council Activities,KEYS Mentor,Class Activities,Jr. Achievement,Hospitality,Data Entry,Deposit Prep
            [volcomments] => email...???
            [cf_id] => 8
        )

    [chronoform] => VolunteerInterest
    [event] => submit
    [page1button] => Next Page
    [page2button] => Next Page
    [page3button] => Next Page
    [button49] => Submit
    [ip_address] => 98.200.42.25
)

Array
(
)

Errors

Array
(
)

Debug Info

Array
(
    [24] => Array
        (
            [Google Spreadsheet Save] => Array
                (
                    [Authentication] => Success
                    [SheetURL] => Found!
                    [Columns] => Array
                        (
                            [0] => firstname
                            [1] => lastname
                            [2] => email
                            [3] => phone
                            [4] => volemployermatch
                            [5] => emergencyname
                            [6] => emergencyphone
                            [7] => student1name
                            [8] => student1grade
                            [9] => student2name
                            [10] => student2grade
                            [11] => student3name
                            [12] => student3grade
                            [13] => volunteerareas
                            [14] => volcomments
                            [15] => volarea1
                            [16] => volarea2
                            [17] => volarea3
                            [18] => volarea4
                            [19] => volarea5
                            [20] => volarea6
                            [21] => volarea7
                            [22] => volarea8
                            [23] => volarea9
                            [24] => volarea10
                            [25] => volarea11
                            [26] => volarea12
                            [27] => volarea13
                            [28] => volarea14
                            [29] => mainofficehelper
                            [30] => workroom
                            [31] => textbookroom
                            [32] => spiritwear
                            [33] => nurse
                            [34] => communications
                            [35] => ptsastudentcouncilactivities
                            [36] => keysmentor
                            [37] => classactivities
                            [38] => jr.achievement
                            [39] => hospitality
                            [40] => dataentry
                            [41] => depositprep
                        )

                    [AddResult] => <?xml version='1.0' encoding='UTF-8'?><entry xmlns='http://www.w3.org/2005/Atom' xmlns:gsx='http://schemas.google.com/spreadsheets/2006/extended' xmlns:gd='http://schemas.google.com/g/2005' gd:etag='"QwYaemUjbit7ImA9WBdWThMP"'><id>https://spreadsheets.google.com/feeds/list/18FvuXw1itK2FtQLyarEjA0VO4clNWcCTVUnSPX6IL4Q/od6/dqi9q</id><updated>2015-04-27T14:04:12.525Z</updated><app:edited xmlns:app='http://www.w3.org/2007/app'>2015-04-27T14:04:12.525Z</app:edited><category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#list'/><title>Willy</title><content>lastname: Wonka, email: mduda14@comcast.net, phone: 8326276531, emergencyname: Geoff, emergencyphone: 1111111111, student1name: Will, student1grade: 11, volunteerareas: check_all,Main Office Helper,Workroom,Textbook Room,Spirit Wear,Nurse,Communications,PTSA/Student Council Activities,KEYS Mentor,Class Activities,Jr. Achievement,Hospitality,Data Entry,Deposit Prep, volcomments: email...???</content><link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/18FvuXw1itK2FtQLyarEjA0VO4clNWcCTVUnSPX6IL4Q/od6/private/full/dqi9q'/><link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/18FvuXw1itK2FtQLyarEjA0VO4clNWcCTVUnSPX6IL4Q/od6/private/full/dqi9q'/><gsx:firstname>Willy</gsx:firstname><gsx:lastname>Wonka</gsx:lastname><gsx:email>mduda14@comcast.net</gsx:email><gsx:phone>8326276531</gsx:phone><gsx:volemployermatch></gsx:volemployermatch><gsx:emergencyname>Geoff</gsx:emergencyname><gsx:emergencyphone>1111111111</gsx:emergencyphone><gsx:student1name>Will</gsx:student1name><gsx:student1grade>11</gsx:student1grade><gsx:student2name></gsx:student2name><gsx:student2grade></gsx:student2grade><gsx:student3name></gsx:student3name><gsx:student3grade></gsx:student3grade><gsx:volunteerareas>check_all,Main Office Helper,Workroom,Textbook Room,Spirit Wear,Nurse,Communications,PTSA/Student Council Activities,KEYS Mentor,Class Activities,Jr. Achievement,Hospitality,Data Entry,Deposit Prep</gsx:volunteerareas><gsx:volcomments>email...???</gsx:volcomments><gsx:volarea1></gsx:volarea1><gsx:volarea2></gsx:volarea2><gsx:volarea3></gsx:volarea3><gsx:volarea4></gsx:volarea4><gsx:volarea5></gsx:volarea5><gsx:volarea6></gsx:volarea6><gsx:volarea7></gsx:volarea7><gsx:volarea8></gsx:volarea8><gsx:volarea9></gsx:volarea9><gsx:volarea10></gsx:volarea10><gsx:volarea11></gsx:volarea11><gsx:volarea12></gsx:volarea12><gsx:volarea13></gsx:volarea13><gsx:volarea14></gsx:volarea14><gsx:mainofficehelper></gsx:mainofficehelper><gsx:workroom></gsx:workroom><gsx:textbookroom></gsx:textbookroom><gsx:spiritwear></gsx:spiritwear><gsx:nurse></gsx:nurse><gsx:communications></gsx:communications><gsx:ptsastudentcouncilactivities></gsx:ptsastudentcouncilactivities><gsx:keysmentor></gsx:keysmentor><gsx:classactivities></gsx:classactivities><gsx:jr.achievement></gsx:jr.achievement><gsx:hospitality></gsx:hospitality><gsx:dataentry></gsx:dataentry><gsx:depositprep></gsx:depositprep></entry>
                )

        )

    [27] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `uh46v_cf_VolunteerInterest` (`user_id`, `uniq_id`, `created`) values ('835', '587bef1871348ea1157c4069757a15b3826275fb', '2015-04-27 09:10:15');
                        )

                )

        )

    [11] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:volunteers@tompkinshsptsa.org
                    [2] => Subject:New Interest in Volunteering
                    [3] => From name:Tompkins High School PTSA
                    [4] => From email:forms@tompkinshsptsa.org
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:
                    [10] => Array
                        (
                        )

                    [11] => Body:
<p>You have a new applicant for volunteering! Here is the info for Willy Wonka:</p>
<table>
<tbody>
<tr>
<td>First Name</td>
<td>Willy</td>
</tr>
<tr>
<td>Last Name</td>
<td>Wonka</td>
</tr>
<tr>
<td>Email</td>
<td>mduda14@comcast.net</td>
</tr>
<tr>
<td>Phone</td>
<td>8326276531</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Does Your Employer Match Volunteer Hours? (Example: BP and Exxon Mobil employees receive this benefit)</td>
<td></td>
</tr>
<tr>
<td>Emergency Contact Name</td>
<td>Geoff</td>
</tr>
<tr>
<td>Emergency Contact Phone</td>
<td>1111111111</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Student's Name</td>
<td>Will</td>
</tr>
<tr>
<td>Student's Grade</td>
<td>11</td>
</tr>
<tr>
<td>Student's Name</td>
<td></td>
</tr>
<tr>
<td>Student's Grade</td>
<td></td>
</tr>
<tr>
<td>Student's Name</td>
<td></td>
</tr>
<tr>
<td>Student's Grade</td>
<td></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Area(s) of Interest</td>
<td>check_all,Main Office Helper,Workroom,Textbook Room,Spirit Wear,Nurse,Communications,PTSA/Student Council Activities,KEYS Mentor,Class Activities,Jr. Achievement,Hospitality,Data Entry,Deposit Prep</td>
</tr>
<tr>
<td>Comments / Additional Info</td>
<td>email...???</td>
</tr>
</tbody>
</table><br /><br />IP: 98.200.42.25
                )

        )

    [26] => Array
        (
            [Email] => Array
                (
                    [0] => An email with the details below was sent successfully:
                    [1] => To:mduda14@comcast.net
                    [2] => Subject:Your Interest In Volunteering 
                    [3] => From name:Tompkins High School PTSA
                    [4] => From email:forms@tompkinshsptsa.org
                    [5] => CC:
                    [6] => BCC:
                    [7] => Reply name:
                    [8] => Reply email:
                    [9] => Attachments:
                    [10] => Array
                        (
                        )

                    [11] => Body:
<p>Dear Willy Wonka,</p>
<p>Thank you for sharing your interest in volunteering at Tompkins! Below is the information you submitted:</p>
<table>
<tbody>
<tr>
<td>First Name</td>
<td>Willy</td>
</tr>
<tr>
<td>Last Name</td>
<td>Wonka</td>
</tr>
<tr>
<td>Email</td>
<td>mduda14@comcast.net</td>
</tr>
<tr>
<td>Phone</td>
<td>8326276531</td>
</tr>
<tr>
<td>Does Your Employer Match Volunteer Hours? (Example: BP and Exxon Mobil employees receive this benefit)</td>
<td></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Emergency Contact Name</td>
<td>Geoff</td>
</tr>
<tr>
<td>Emergency Contact Phone</td>
<td>1111111111</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Student's Name</td>
<td>Will</td>
</tr>
<tr>
<td>Student's Grade</td>
<td>11</td>
</tr>
<tr>
<td>Student's Name</td>
<td></td>
</tr>
<tr>
<td>Student's Grade</td>
<td></td>
</tr>
<tr>
<td>Student's Name</td>
<td></td>
</tr>
<tr>
<td>Student's Grade</td>
<td></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Area(s) of Interest</td>
<td>check_all,Main Office Helper,Workroom,Textbook Room,Spirit Wear,Nurse,Communications,PTSA/Student Council Activities,KEYS Mentor,Class Activities,Jr. Achievement,Hospitality,Data Entry,Deposit Prep</td>
</tr>
<tr>
<td>Comments / Additional Info</td>
<td>email...???</td>
</tr>
</tbody>
</table>
<p>Thank you for getting involved at Tompkins! We will be in touch with you soon.</p><br /><br />IP: 98.200.42.25
                )

        )

)

Hi Mduda,

Looks OK - apart from the DB Query - please try clicking the Delete Cache icon in the Forms Manager toolbar and see if that brings the table records up to date.

Bob

You're a genius! That did it ! Thank you 😀