- Issue created by @Tankeroo
After form submission, many fields are not sent to Google Sheets
Create a webform and add some fields into different webform pages. Special fields I used are: computed TWIG and Wizard pages.
I'm not sure what is causing the issue.
Here's my webform configuration:
uuid: 538778e2-6c8a-4171-a760-2cdb67bd081d
langcode: en
status: open
dependencies:
module:
- commerce_webform_order
- webform_googlesheets
- webform_product
third_party_settings:
webform_product:
please_specify_which_camp_the_camper_will_be_attending_:
options:
'Discovery Camp': '270.00'
'Camp Impact': '315.00'
'':
top: ''
options:
'I understand that payment must be made immediately after submitting this form': ''
order_id:
top: ''
order_url:
top: ''
order_status:
top: ''
grade:
top: ''
options:
5: '350'
6: '350'
7: '350'
8: '350'
9: '405'
10: '405'
11: '405'
12: '405'
home_church:
top: ''
options:
'Asian American Baptist Church': ''
'Chinese Baptist Church': ''
'Clear Lake Chinese Church': ''
'Comfort Community Church': ''
'Houston Chinese Church': ''
'Evangelical Formosan Church - NASA Campus': ''
'Evangelical Formosan Church - Stafford Campus': ''
'Katy Christian Community Church': ''
'New Hope Christian Church': ''
'Pearland Chinese Church': ''
'Southwest Chinese Baptist Church': ''
'West Houston Christian Church': ''
covid_testing:
top: ''
shirt_size:
top: ''
options:
Small: ''
Medium: ''
Large: ''
X-Large: ''
dcamp_registration:
top: ''
pastoral_discount:
top: '0.00'
confirmation_payment:
top: ''
dcamp_price:
top: '330'
impact_price:
top: '375'
no_discount:
top: ''
payment_submission:
top: ''
options:
'Yes, I verify': ''
actions:
top: ''
payment:
top: ''
payment_agreement:
top: ''
d_code:
top: ''
transgender:
top: ''
paying_online:
options:
'Yes': ''
'No': ''
online_payment_understanding:
options:
i_understand: ''
registrant_release_23:
options:
'I understand': ''
confirmation_email:
options:
'Yes, I understand': ''
registrant_release:
options:
read_and_agree: ''
confidential_info:
options:
'I have read and accept the statement above': ''
'I have read and do not accept the statement above': ''
registering_with_discount:
options:
'Yes': ''
'No': ''
media_release:
options:
'Permission Granted': ''
payments_will_be_made_to_ministry_events_hcchome_org_via_paypal_:
options:
'Charge Disputes': ''
weight: 0
open: null
close: null
uid: 105
template: false
archive: false
id: 2025_d_camp_camp_impact_registra
title: '2025 D-Camp & Camp Impact Registration'
description: '<p>2025 D-Camp & Camp Impact Registration Form (using new commerce handler)</p>'
categories:
- 'Youth Ministry'
elements: |-
order_id:
'#type': hidden
'#title': 'Order ID'
'#private': true
order_status:
'#type': hidden
'#title': 'Order Status'
'#default_value': Completed
'#private': true
'#access': true
camper_information:
'#type': webform_wizard_page
'#title': 'Camper Information'
home_church:
'#type': webform_select_other
'#title': "What is the camper's home church?"
'#options':
'Asian American Baptist Church': 'Asian American Baptist Church'
'Chinese Baptist Church': 'Chinese Baptist Church'
'Clear Lake Chinese Church': 'Clear Lake Chinese Church'
'Comfort Community Church': 'Comfort Community Church'
'Houston Chinese Church': 'Houston Chinese Church'
'Evangelical Formosan Church - NASA Campus': 'Evangelical Formosan Church - NASA Campus'
'Evangelical Formosan Church - Stafford Campus': 'Evangelical Formosan Church - Stafford Campus'
'Katy Christian Community Church': 'Katy Christian Community Church'
'New Hope Christian Church': 'New Hope Christian Church'
'Pearland Chinese Church': 'Pearland Chinese Church'
'Southwest Chinese Baptist Church': 'Southwest Chinese Baptist Church'
'West Houston Christian Church': 'West Houston Christian Church'
'#other__option_label': 'Other Church...'
'#required': true
personal_info:
'#type': container
camper_name:
'#type': webform_name
'#title': camper-name
'#title__access': false
'#first__title': 'First Name'
'#first__required': true
'#middle__title': 'Middle Name'
'#last__title': 'Last Name'
'#last__required': true
'#suffix__access': false
'#degree__access': false
'#required': true
name_address:
'#type': address
'#title': 'Name & Address'
'#available_countries':
- US
'#field_overrides':
givenName: hidden
additionalName: hidden
familyName: hidden
organization: hidden
addressLine1: required
addressLine2: optional
postalCode: required
sortingCode: hidden
dependentLocality: hidden
locality: required
administrativeArea: required
'#required': true
dob:
'#type': date
'#title': 'Date of Birth'
'#required': true
'#date_date_format': ''
age:
'#type': number
'#title': 'Age Now'
'#required': true
'#min': 10
'#max': 20
'#step': 1
gender:
'#type': select
'#title': Gender
'#description_display': after
'#options':
Male: Male
Female: Female
'#required': true
transgender_yn:
'#type': select
'#title': 'Do you identify as transgender and/or nonbinary? '
'#description': '<p>*In order to create a safe space for all our students, Camp staff will evaluate these applications on a case to case basis. For more information about the transgender option, please see the <a href="https://dcampandimpact.weebly.com/faqs.html" target="_blank">FAQ</a>.</p>'
'#description_display': after
'#options':
'No': 'No'
'Yes': 'Yes'
'#required': true
transgender:
'#type': webform_message
'#states':
visible:
':input[name="gender"]':
value: 'I am transgender*'
'#message_type': warning
'#message_message': '<p>*In order to create a safe space for all our students, Camp staff will evaluate these applications on a case to case basis. For more information about the transgender option, please see our <a href="https://dcampandimpact.weebly.com/faqs.html" target="_blank">FAQ</a>.</p>'
'#message_close': true
'#message_close_effect': fade
school:
'#type': textfield
'#title': 'What school does the camper attend?'
'#required': true
grade:
'#type': select
'#title': 'Grade completed at end of 2025 school year:'
'#options':
5: 5th
6: 6th
7: 7th
8: 8th
9: 9th
10: 10th
11: 11th
12: 12th
'#required': true
camp_info:
'#type': container
dcamp_registration:
'#type': webform_message
'#states':
visible:
- ':input[name="grade"]':
value: '5'
- or
- ':input[name="grade"]':
value: '6'
- or
- ':input[name="grade"]':
value: '7'
- or
- ':input[name="grade"]':
value: '8'
'#display_on': both
'#message_message': '<p>The camper will be registered and attending Discovery Camp.</p>'
'#message_close_effect': hide
impact_registration:
'#type': webform_message
'#states':
visible:
- ':input[name="grade"]':
value: '9'
- or
- ':input[name="grade"]':
value: '10'
- or
- ':input[name="grade"]':
value: '11'
- or
- ':input[name="grade"]':
value: '12'
'#display_on': both
'#message_message': '<p>The camper will be registered and attending Camp Impact.</p>'
'#message_close_effect': hide
christian_yn:
'#type': select
'#title': 'Is the camper a Christian?'
'#options':
'Yes': 'Yes'
'No': 'No'
'#required': true
attendance:
'#type': radios
'#title': 'How many years has the camper attended camp?'
'#options':
'First time': 'First time'
'2 years': '2 years'
'3 years': '3 years'
'4 years': '4 years'
'5 years': '5 years'
'6 years': '6 years'
'7 years': '7 years'
'8 years': '8 years'
'#required': true
camper_email:
'#type': email
'#title': "Please enter the camper's email address"
'#required': true
camper_phone:
'#type': tel
'#title': "Please enter the camper's cell phone number"
'#required': true
please_specify_the_camper_s_t_shirt_size:
'#type': select
'#title': "Please specify the camper's t-shirt size"
'#description': '<p>Adult Sizing</p>'
'#options':
Small: Small
Medium: Medium
Large: Large
X-Large: X-Large
'#required': true
language:
'#type': select
'#title': "What is the camper's primary spoken language?"
'#options':
English: English
'Chinese (Mandarin)': 'Chinese (Mandarin)'
'Chinese (Cantonese)': 'Chinese (Cantonese)'
'#required': true
translation_help:
'#type': radios
'#title': 'Will the camper need translation help?'
'#options':
'Yes': 'Yes'
'No': 'No'
'#required': true
registration_intro:
'#type': webform_wizard_page
'#title': 'Registration Details'
will_you_be_registering_with_a_scholarship_or_pastoral_discount_:
'#type': select
'#title': 'Will you be registering with a scholarship or pastoral discount?'
'#options':
'Yes': 'Yes'
'No': 'No'
'#required': true
d_code:
'#type': textfield
'#title': 'Please type your registration code for the scholarship / pastoral discount.'
'#description': '<p><span class="Strong Red"><strong>You chose that you are registering with a scholarship / pastoral discount. You will need to get in touch with the Camp Director </strong></span><a href="mailto:dcampandimpact@gmail.com"><span class="Strong Red"><strong>dcampandimpact@gmail.com</strong></span></a><span class="Strong Red"><strong> to get your registration code. </strong></span>Once you have received the code, come back to this registration page to register.</p>'
'#required': true
'#pattern': '[A-Za-z]*-[A-Za-z]*-scholarship(100|50)'
'#pattern_error': 'Wrong Discount Code'
'#states':
visible:
':input[name="will_you_be_registering_with_a_scholarship_or_pastoral_discount_"]':
value: 'Yes'
'#format_items': comma
registration_total:
'#type': webform_computed_twig
'#title': 'Registration Price: '
'#template': |
{% set camp_grade = data.grade %} {# Enter the field Key data.FIELD_KEY we are getting the data from. #}
{# Enter number only. After = sign #}
{% set dcamp_min = 5 %} {# DCamp Grade Minimum #}
{% set dcamp_max = 8 %} {# DCamp Grade Maximum #}
{% set dcamp_price = 385 %} {# Normal Price for DCamp #}
{% set impact_min = 9 %} {# Impact Grade Minimum #}
{% set impact_max = 12 %} {# Impact Grade Maximum #}
{% set impact_price = 440 %} {# Normal Price for Impact #}
{# Enter code with single quotes #}
{% set full_discount_code = 'scholarship100' %} {# Code for Full Discount #}
{% set half_discount_code = 'scholarship50' %} {# Code for 50% off #}
{# DO NOT EDIT BELOW THIS LINE UNLESS YOU KNOW WHAT YOU'RE DOING #}
{# Calculates current age of form user. Disabled. Using Calculate by grade
DOB: {{ data.dob|date('Y') }} <br />
Current Date: {{ 'now' | date('Y') }}<br />
{% set age = ('now' | date('Y') - data.dob|date('Y')) %}
#}
{% if camp_grade >= dcamp_min and camp_grade <= dcamp_max %}
{% set price = dcamp_price %}
{% endif %}
{% if camp_grade >= impact_min and camp_grade <= impact_max %}
{% set price = impact_price %}
{% endif %}
{% if full_discount_code in data.d_code %}
{% set price = 0 %}
{% endif %}
{% if half_discount_code in data.d_code %}
{% set price = (price/2) %}
{% endif %}
{{ price }}
'#whitespace': trim
'#store': true
'#ajax': true
parental_information:
'#type': webform_wizard_page
'#title': 'Parental Information'
parental_info:
'#type': container
parental_relationship:
'#type': webform_radios_other
'#title': 'Parental Relationship'
'#options':
Mother: Mother
Father: Father
'#required': true
parent_name:
'#type': webform_name
'#title': 'Parent Name'
'#title__access': false
'#first__title': 'Parent First Name'
'#first__required': true
'#middle__access': false
'#last__title': 'Parent Last Name'
'#last__required': true
'#suffix__access': false
'#degree__access': false
'#required': true
parent_email:
'#type': email
'#title': 'Parent Email'
'#required': true
'#format_items': comma
email_confirmation:
'#type': checkboxes
'#title': "This email will be connected to all important documents related to this camper's registration."
'#options':
'I understand': 'I understand'
'#required': true
parent_daytime_phone:
'#type': tel
'#title': 'Parent Daytime Phone'
'#required': true
parent_evening_phone:
'#type': tel
'#title': 'Parent Evening Phone'
'#required': true
parent_other_phone:
'#type': tel
'#title': 'Parent Other Phone'
emergency_yn:
'#type': radios
'#title': "Would you like to use the parental contact information as the camper's emergency contact?"
'#options':
'Yes': 'Yes'
'No': 'No'
'#required': true
emergency_contact:
'#type': container
'#states':
visible:
':input[name="emergency_yn"]':
value: 'No'
emergency_contact_name:
'#type': webform_name
'#title': 'Emergency Contact Name'
'#title__access': false
'#first__title': 'Emergency Contact First Name'
'#first__required': true
'#middle__access': false
'#last__title': 'Emergency Contact Last Name'
'#last__required': true
'#suffix__access': false
'#degree__access': false
emergency_daytime_phone:
'#type': tel
'#title': 'Emergency Contact Daytime Phone'
'#required': true
emergency_evening_phone:
'#type': tel
'#title': 'Emergency Contact Evening Phone'
'#required': true
emergency_other_phone:
'#type': tel
'#title': 'Emergency Contact Other Phone'
'#required': true
health_information:
'#type': webform_wizard_page
'#title': 'Health Information'
insurance_yn:
'#type': radios
'#title': 'Does the camper have health insurance?'
'#options':
'Yes': 'Yes'
'No': 'No'
'#required': true
health_insurance:
'#type': container
'#states':
visible:
':input[name="insurance_yn"]':
value: 'Yes'
insurance_groupnumber:
'#type': textfield
'#title': "What is the camper's insurance group number?"
'#required': true
insurance_policynumber:
'#type': textfield
'#title': 'What is the insurance policy number for the camper?'
'#required': true
doctor_name:
'#type': textfield
'#title': 'What is the name of the doctor for the camper?'
doctor_phone:
'#type': tel
'#title': "What is the doctor's phone number?"
tetanus_yn:
'#type': radios
'#title': 'Has the camper had a tetanus shot?'
'#options':
'Yes': 'Yes'
'No': 'No'
'#required': true
tetanus_date:
'#type': date
'#title': 'What is the date of the last tetanus shot?'
'#required': true
'#states':
visible:
':input[name="tetanus_yn"]':
value: 'Yes'
'#datepicker': true
'#date_date_format': m/d/y
medication_info:
'#type': container
medical_conditions:
'#type': checkboxes
'#title': 'Does the camper have any of the following:'
'#options':
'Medications taken for current medical condition (asthma, allergies, etc.)': 'Medications taken for current medical condition (asthma, allergies, etc.)'
'Medications taken occasionally (headaches, etc.)': 'Medications taken occasionally (headaches, etc.)'
'Recent serious injury': 'Recent serious injury'
'Recent surgery': 'Recent surgery'
'Chronic medical condition': 'Chronic medical condition'
'Other health concerns': 'Other health concerns'
None: None
'#required': true
medications:
'#type': textarea
'#title': 'Please describe the medications taken for current medical condition:'
'#required': true
'#states':
visible:
':input[name="medical_conditions[Medications taken for current medical condition (asthma, allergies, etc.)]"]':
checked: true
medications_occasional:
'#type': textarea
'#title': 'Please describe the medications taken occasionally:'
'#required': true
'#states':
visible:
':input[name="medical_conditions[Medications taken occasionally (headaches, etc.)]"]':
checked: true
medications_at_camp:
'#type': radios
'#title': 'Do you plan to bring these or any other medications to camp with you?'
'#options':
'Yes': 'Yes'
'No': 'No'
'#required': true
'#states':
visible:
- ':input[name="medications"]':
checked: true
- or
- ':input[name="medications_occasional"]':
checked: true
medication_information_blurb:
'#type': webform_message
'#states':
visible:
- ':input[name="medical_conditions[Medications taken for current medical condition (asthma, allergies, etc.)]"]':
checked: true
- or
- ':input[name="medical_conditions[Medications taken occasionally (headaches, etc.)]"]':
checked: true
'#message_message': '<p><strong>State law requires all medications to be placed in the camp Health Center. All medications must be brought in the original bottle (prescription or over-the-counter), properly labeled as prescribed by law.</strong></p>'
medical_conditions_info:
'#type': textarea
'#title': 'Please describe health information:'
'#description': '<p>Please go into detail about all of the following - recent serious injury, recent surgery, chronic medical condition, and/or other health concerns. </p>'
'#title_display': before
'#description_display': after
'#required': true
'#states':
visible:
- ':input[name="medical_conditions[Recent serious injury]"]':
checked: true
- or
- ':input[name="medical_conditions[Recent surgery]"]':
checked: true
- or
- ':input[name="medical_conditions[Chronic medical condition]"]':
checked: true
- or
- ':input[name="medical_conditions[Other health concerns]"]':
checked: true
allergy_info:
'#type': container
allergies:
'#type': webform_checkboxes_other
'#title': 'Please specify if the camper has any allergy or dietary restrictions:'
'#options':
'Special diet': 'Special diet'
'Food allergies': 'Food allergies'
'Drug allergies': 'Drug allergies'
'Allergies to Insect Stings / Bites': 'Allergies to Insect Stings / Bites'
None: None
'#other__option_label': 'Other allergies...'
'#required': true
dietary_needs:
'#type': textarea
'#title': "Please describe the camper's special dietary needs:"
'#title_display': before
'#description_display': after
'#required': true
'#states':
visible:
':input[name="allergies[checkboxes][Special diet]"]':
checked: true
food_allergies:
'#type': textarea
'#title': "Please describe the camper's food allergy:"
'#title_display': before
'#description_display': after
'#required': true
'#states':
visible:
':input[name="allergies[checkboxes][Food allergies]"]':
checked: true
drug_allergies:
'#type': textarea
'#title': "Please describe the camper's drug allergy:"
'#title_display': before
'#description_display': after
'#required': true
'#states':
visible:
':input[name="allergies[checkboxes][Drug allergies]"]':
checked: true
insect_allergies:
'#type': textarea
'#title': "Please describe the camper's insect stings / bites allergy:"
'#title_display': before
'#description_display': after
'#required': true
'#states':
visible:
':input[name="allergies[checkboxes][Allergies to Insect Stings / Bites]"]':
checked: true
other_allergies:
'#type': textarea
'#title': "Please describe the camper's other allergy:"
'#title_display': before
'#description_display': after
'#required': true
'#states':
visible:
':input[name="allergies[other]"]':
checked: true
special_needs:
'#type': textarea
'#title': 'Special Needs'
'#description': '<p>Does the camper have any special needs, disabilities, or accommodations that would help us better support them during camp? (e.g., physical, cognitive, sensory, behavioral, or learning-related needs) If yes, please provide details so we can ensure the best possible experience for your child.</p>'
'#required': true
confirmation_payment:
'#type': webform_wizard_page
'#title': Confirmation
confirmation_email:
'#type': checkboxes
'#title': 'Confirmation Email'
'#description': '<p>I understand that a confirmation email will be sent to me for each child to verify registration and that I am then held responsible for each child''s registration henceforth. (You may need to check your SPAM box. The sender email is "<a href="mailto:youth@hcchome.org">youth@hcchome.org</a>")</p>'
'#options':
'Yes, I understand': 'Yes, I understand'
'#required': true
payment_submission:
'#type': checkboxes
'#title': 'Payment Submission'
'#description': '<p>Do you verify that upon submission of this registration, you agree to pay the registration? Any unpaid registrants will become invalid.</p>'
'#options':
'Yes, I verify': 'Yes, I verify'
'#required': true
media_release:
'#type': radios
'#title': 'RELEASE OF PHOTOGRAPHS, VIDEO, AUDIO AND RELATED MEDIA FORMATS TO CAMP:'
'#description': '<p>I understand that as a participant of activities sponsored by Discovery Camp / Camp Impact, my child may be photographed or videotaped. I understand that these photographs/videos may be used in promotional materials, publications, and video presentations of the church. I also understand that these photographs/videos may be posted on the Camp website and Social Media and do hereby give my permission for such use.</p>'
'#title_display': before
'#description_display': before
'#options':
'Permission Granted': 'Permission Granted'
'#required': true
confidential_info:
'#type': radios
'#title': 'Confidential Information Disclosure'
'#description': '<p>Discovery Camp / Camp Impact staff and volunteers (the “Receiving Party”) may receive confidential information from campers (“Disclosing Party”). “Confidential Information” shall mean information that could be deemed personal and confidential obtained by the Receiving Party from the Disclosing Party by way of verbal discussion, written letters, email, text or electronic media and arising from church classroom sessions, forums, activities, counseling or sponsored church functions including retreats and camps. Receiving Party from time to time may use confidential information for statistical tracking, monitoring and reporting. The Receiving Party agrees to hold in confidence any and all confidential information and not share or disclose individual names of Disclosing Party with the exception of Confidential Information received from a Disclosing Party that is illegal by Local, State and Federal government jurisdictions. Receiving Party agrees to destroy all written information after a 5 five year period from receipt.<br>I hereby give permission for my child to participate in the activities of Discovery Camp / Camp Impact. I have read in full and understand the Confidential Information Disclosure and indemnify and hold harmless Discovery Camp / Camp Impact Staff and designated volunteers as well as other participants from any and all liabilities, actions, damages and claims of any kind or nature that may arise.</p>'
'#title_display': before
'#description_display': before
'#options':
'I have read and accept the statement above': 'I have read and accept the statement above'
'I have read and do not accept the statement above': 'I have read and do not accept the statement above'
'#required': true
registrant_release:
'#type': checkboxes
'#title': 'Registrant Release Form'
'#description': '<p>On behalf of myself and any other parent or guardian named, I, the undersigned, as the parent or guardian of the registrant(s) thereby grant permission for the my child(ren) to participate in Discovery Camp/Camp Impact. Furthermore, on behalf of myself and any other parent or guardian of the person named I do release unto the staff and volunteers of Discovery Camp/Camp Impact authority and responsibility to authorize any and all medical treatment necessary for the protection of the health and well-being of the aforementioned child. This authorization shall permit any and all medical treatment as determined by a qualified medical personnel, pursuant to express authorization, whether by written or oral consent of the aforementioned representatives. This permission shall be effective for Discovery Camp/Camp Impact July 21-28 or until it is expressly revoked. I hereby release the staff and volunteers of Discovery Camp/Camp Impact from any and all claims and liabilities of whatsoever nature that may arise from my child’s participation in this camp. I understand that I will be financially responsible for any damages caused by my child to any property (facility, etc.) and understand that I will be responsible to pick up my student from camp in the case of disciplinary action.</p>'
'#options':
read_and_agree: 'I have read and fully understand this release of liability, and sign of my own free will.'
'#required': true
camper_signature:
'#type': webform_signature
'#title': "Camper's Signature"
'#description': '<p>Please have the camper sign this form.</p>'
'#description_display': after
'#required': true
parent_signature:
'#type': webform_signature
'#title': "Parent's Signature"
'#description': ''
'#description_display': after
'#required': true
comments:
'#type': textarea
'#title': 'Additional questions / comments'
'#description': '<p>Please let us know if you have any additional questions or comments about Discovery Camp / Camp Impact.</p>'
'#description_display': before
paypal_confirmation:
'#type': webform_wizard_page
'#title': 'Paypal Confirmation'
online_payment_understanding:
'#type': checkboxes
'#title': 'Please note that a payment must be made immediately after submitting this form. If you do not, this form will be deleted and not sent to organizers (you might still receive a confirmation email). If you are registering siblings, please make sure you pay first before starting a new form.'
'#options':
i_understand: 'I understand that payment must be made immediately after submitting this form.'
'#required': true
payments_will_be_made_to_ministry_events_hcchome_org_via_paypal_:
'#type': checkboxes
'#title': 'Payments will be made to ministry.events@hcchome.org via paypal. If charges are disputed, a $25 processing fee will be charged.'
'#options':
'Charge Disputes': 'I have read and understand the above statement'
'#required': true
actions:
'#type': webform_actions
'#title': 'Submit button(s)'
css: ''
javascript: ''
settings:
ajax: false
ajax_scroll_top: form
ajax_progress_type: ''
ajax_effect: ''
ajax_speed: null
page: true
page_submit_path: ''
page_confirm_path: ''
page_theme_name: ''
form_title: source_entity_webform
form_submit_once: false
form_open_message: ''
form_close_message: ''
form_exception_message: ''
form_previous_submissions: true
form_confidential: false
form_confidential_message: ''
form_disable_remote_addr: false
form_convert_anonymous: false
form_prepopulate: true
form_prepopulate_source_entity: false
form_prepopulate_source_entity_required: false
form_prepopulate_source_entity_type: ''
form_unsaved: false
form_disable_back: false
form_submit_back: false
form_disable_autocomplete: false
form_novalidate: false
form_disable_inline_errors: false
form_required: false
form_autofocus: false
form_details_toggle: false
form_reset: false
form_access_denied: default
form_access_denied_title: ''
form_access_denied_message: ''
form_access_denied_attributes: { }
form_file_limit: ''
form_attributes: { }
form_method: ''
form_action: ''
share: false
share_node: false
share_theme_name: ''
share_title: true
share_page_body_attributes: { }
submission_label: ''
submission_exception_message: ''
submission_locked_message: ''
submission_log: false
submission_excluded_elements: { }
submission_exclude_empty: false
submission_exclude_empty_checkbox: false
submission_views: { }
submission_views_replace: { }
submission_user_columns: { }
submission_user_duplicate: false
submission_access_denied: default
submission_access_denied_title: ''
submission_access_denied_message: ''
submission_access_denied_attributes: { }
previous_submission_message: ''
previous_submissions_message: ''
autofill: false
autofill_message: ''
autofill_excluded_elements: { }
wizard_progress_bar: true
wizard_progress_pages: false
wizard_progress_percentage: false
wizard_progress_link: false
wizard_progress_states: false
wizard_start_label: ''
wizard_preview_link: false
wizard_confirmation: true
wizard_confirmation_label: ''
wizard_auto_forward: true
wizard_auto_forward_hide_next_button: false
wizard_keyboard: true
wizard_track: ''
wizard_prev_button_label: ''
wizard_next_button_label: ''
wizard_toggle: true
wizard_toggle_show_label: ''
wizard_toggle_hide_label: ''
wizard_page_type: container
wizard_page_title_tag: h3
preview: 0
preview_label: ''
preview_title: ''
preview_message: ''
preview_attributes: { }
preview_excluded_elements: { }
preview_exclude_empty: true
preview_exclude_empty_checkbox: false
draft: all
draft_multiple: false
draft_auto_save: true
draft_saved_message: '<p>Your form has been successfully saved.</p><p>SAVE this link to return to your draft: <a href="[webform_submission:token-update-url]">[webform_submission:token-update-url]</a></p>'
draft_loaded_message: ''
draft_pending_single_message: ''
draft_pending_multiple_message: ''
confirmation_type: none
confirmation_url: 'https://en.hcchome.org/dcampimpact2022'
confirmation_title: ''
confirmation_message: ''
confirmation_attributes: { }
confirmation_back: true
confirmation_back_label: ''
confirmation_back_attributes: { }
confirmation_exclude_query: false
confirmation_exclude_token: false
confirmation_update: false
limit_total: null
limit_total_interval: null
limit_total_message: ''
limit_total_unique: false
limit_user: null
limit_user_interval: null
limit_user_message: ''
limit_user_unique: false
entity_limit_total: null
entity_limit_total_interval: null
entity_limit_user: null
entity_limit_user_interval: null
purge: draft
purge_days: 120
results_disabled: false
results_disabled_ignore: false
results_customize: false
token_view: false
token_update: false
token_delete: false
serial_disabled: false
access:
create:
roles:
- anonymous
- authenticated
users: { }
permissions: { }
view_any:
roles: { }
users: { }
permissions: { }
update_any:
roles: { }
users: { }
permissions: { }
delete_any:
roles: { }
users: { }
permissions: { }
purge_any:
roles: { }
users: { }
permissions: { }
view_own:
roles: { }
users: { }
permissions: { }
update_own:
roles: { }
users: { }
permissions: { }
delete_own:
roles: { }
users: { }
permissions: { }
administer:
roles:
- church_staff
users: { }
permissions: { }
test:
roles: { }
users: { }
permissions: { }
configuration:
roles: { }
users: { }
permissions: { }
handlers:
dcamp_and_impact_email:
id: email
handler_id: dcamp_and_impact_email
label: 'Dcamp and Impact Email'
notes: ''
status: true
conditions: { }
weight: -48
settings:
states:
- completed
to_mail: dcampandimpact@gmail.com
to_options: { }
bcc_mail: ''
bcc_options: { }
cc_mail: ''
cc_options: { }
from_mail: youth@hcchome.org
from_options: { }
from_name: _default
reply_to: ''
return_path: ''
sender_mail: ''
sender_name: ''
subject: _default
body: '<p>[webform_submission:values]</p><p>Submitted on [webform_submission:created] by [webform_submission:user]</p>'
excluded_elements: { }
ignore_access: false
exclude_empty: true
exclude_empty_checkbox: false
exclude_attachments: false
html: true
attachments: false
twig: false
theme_name: ''
parameters: { }
debug: false
registration_confirmation_email:
id: email
handler_id: registration_confirmation_email
label: 'Registration Confirmation Email'
notes: ''
status: true
conditions: { }
weight: -47
settings:
states:
- completed
to_mail: '[webform_submission:values:parent_email:raw]'
to_options: { }
bcc_mail: ''
bcc_options: { }
cc_mail: '[webform_submission:values:camper_email:raw]'
cc_options: { }
from_mail: youth@hcchome.org
from_options: { }
from_name: _default
reply_to: Dcampandimpact@gmail.com
return_path: ''
sender_mail: ''
sender_name: ''
subject: 'D-Camp/Camp Impact Registration Confirmation'
body: '<p>[webform_submission:values]</p><p>Submitted on [webform_submission:created] by [webform_submission:user]</p>'
excluded_elements: { }
ignore_access: false
exclude_empty: true
exclude_empty_checkbox: false
exclude_attachments: false
html: true
attachments: false
twig: false
theme_name: ''
parameters: { }
debug: false
commerce_webform_order_handler:
id: commerce_webform_order
handler_id: commerce_webform_order_handler
label: 'Commerce Webform Order Handler'
notes: ''
status: true
conditions: { }
weight: -49
settings:
store:
store_entity: '3'
bypass_access: true
order_item:
order_item_id: ':input[name="order_id"]'
purchasable_entity_type: commerce_product_variation
purchasable_entity: '1'
title: ''
overwrite_price: false
amount: ':input[name="registration_total"]'
currency: ''
quantity: '1'
order_item_bundle: webform
fields: { }
checkout:
new_cart: false
empty_cart: true
combine_cart: true
owner: ':input[name="parent_email"]'
owner_id: ''
billing_profile_id: ''
billing_profile_bypass_access: false
payment_gateway_id: null
payment_method_id: null
cancel_url: null
hide_add_to_cart_message: false
redirect: true
order_state: ''
order_data: ''
sync: true
webform_states:
- completed
order_states:
- _new_order_
- 'order_default:draft'
- 'order_fulfillment_validation:draft'
prevent_update: false
debug: false
remote_post:
id: remote_post
handler_id: remote_post
label: 'Remote post for Zapier v2'
notes: ''
status: true
conditions: { }
weight: -50
settings:
method: POST
type: x-www-form-urlencoded
excluded_data:
serial: serial
sid: sid
uuid: uuid
token: token
uri: uri
created: created
completed: completed
changed: changed
in_draft: in_draft
current_page: current_page
remote_addr: remote_addr
uid: uid
langcode: langcode
webform_id: webform_id
entity_type: entity_type
entity_id: entity_id
locked: locked
sticky: sticky
notes: notes
order_id: order_id
order_status: order_status
custom_data: ''
custom_options: ''
file_data: true
cast: false
debug: false
completed_url: 'https://hooks.zapier.com/hooks/catch/14508853/2xu6345/'
completed_custom_data: ''
updated_url: ''
updated_custom_data: ''
deleted_url: ''
deleted_custom_data: ''
draft_created_url: ''
draft_created_custom_data: ''
draft_updated_url: ''
draft_updated_custom_data: ''
converted_url: ''
converted_custom_data: ''
message: ''
messages: { }
error_url: ''
google_sheets:
id: googlesheets
handler_id: google_sheets
label: 'Google Sheets'
notes: ''
status: true
conditions: { }
weight: -46
settings:
spreadsheet_url: 'https://docs.google.com/spreadsheets/d/17elayBhz7xZmTnWywgLd8QIWjwBWX8vjBcpCwtYZf8s/edit?usp=sharing'
spreadsheet_id: 17elayBhz7xZmTnWywgLd8QIWjwBWX8vjBcpCwtYZf8s
spreadsheet_sheet_id: 0
google_api_client: 0
multivalue_limit: 0
multivalue_empty: true
comma_separate: true
sort_data: false
convert_date: true
date_format: default_short_date
custom_date_format: ''
included_data:
serial: serial
sid: sid
uuid: uuid
token: token
uri: uri
created: created
completed: completed
changed: changed
in_draft: in_draft
current_page: current_page
remote_addr: remote_addr
uid: uid
langcode: langcode
webform_id: webform_id
entity_type: entity_type
entity_id: entity_id
locked: locked
sticky: sticky
notes: notes
order_id: order_id
order_status: order_status
google_api_credential_type: google_api_service_client
google_api_service_client: webform_googlesheets
variants: { }The only fields that are send to Google Sheets are Below:
NOTE: the "registration_total" field is sent to Google Sheets but does not reflect actual submission value.
This field is a computed TWIG field and depending on two other fields the value changes. The value sent to Google Sheets is either {% set dcamp_price = 385 %} or {% set impact_price = 440 %} which is dependent on the "grade" field. But does not send the final value when a "d_code" is entered and there is an additional discount. However, in submissions/results tab this value is submitted correctly.
I don't see any error in the logs so I'm not sure what is causing this issue. Thank you.
Active
2.1
Code