Answers.Body: <p><a href="https://www.webwash.net/integrate-webform-and-google-sheets-using-zapier-in-drupal-8/" rel="nofollow noreferrer">https://www.webwash.net/integrate-webform-and-google-sheets-using-zapier-in-drupal-8/</a></p>
  <ol>
  <li><p>Drupal 8 you can install Webform Remote Handlers module <a href="https://www.drupal.org/project/webform_remote_handlers" rel="nofollow noreferrer">https://www.drupal.org/project/webform_remote_handlers</a>
  Drupal 7 has a similar module (Webform Remote Post) that also works but it is no longer maintained. .</p>
  </li>
  <li><p>Create a Zap in Zapier to connect the results to a Google Sheet.</p>
  </li>
  </ol>
  <p>Now when someone submits a webform, the results are added as a line on the Google Sheet. This allows your non-techy staff to view, edit, sort in a format they are very comfortable with.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-11-14T06:00:08.743Z
Answers.LastActivityDate: 2020-11-14T06:00:08.743Z
Answers.UserDisplayName: Iowa Boy
Answers.Body: <p>Here's another possible solution 
  <a href="https://www.drupal.org/project/webform_import" rel="nofollow noreferrer">https://www.drupal.org/project/webform_import</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-06-22T02:48:34.733Z
Answers.LastActivityDate: 2019-06-22T02:48:34.733Z
Answers.UserDisplayName: Zachary
Body: <p>We have a webform that is used for a complex event registration, with all of the registration details stored in the webform and nothing in CiviCRM except the contribution record.</p>
  
  <p>We'd like to be able to edit some of the registration details that users have submitted to the webform, but using the edit submission link leads to the payment part of the submission - requiring that payment details be entered again.</p>
  
  <p>Is there any way to simply edit some of the webform submission values, which aren't connected to the payment, without resubmitting the payment?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-18T01:10:10.903Z
Comments.Text: I'd love to see your webform! You might check out an approach of viewing the submission results in a view and then using something like this (https://drupal.stackexchange.com/questions/189636/editable-webform-fields-in-views) or editable views module to edit without re-submitting
Comments.UserDisplayName: Zachary
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-18T01:13:09.593Z
Comments.Text: Here's the public side of the webform:https://secure.wildsight.ca/get-wild-summer-day-camp-2019-registration
Comments.UserDisplayName: Lars SG
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-18T01:21:19.120Z
Comments.Text: Another weird approach might be to create a role that did not have permission to the payment component and try editing/saving that way: https://www.drupal.org/project/webform_component_roles
  note - this is untested wild hypothesis :)
Comments.UserDisplayName: Zachary
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-18T07:47:29.800Z
Comments.Text: @LarsSG which payment processor are you using?
Comments.UserDisplayName: Tapash
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-18T07:49:14.600Z
Comments.Text: @LarsSG also could you please tell me how did you add T&C page to weborm? thanks
Comments.UserDisplayName: Tapash
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-18T10:37:30.643Z
Comments.Text: @Tapash We're using IATS
  The waiver is just a page break, a markup field for all the wording, a text field for the initials and a radio select that you accept the waiver terms (there is only one option, "Yes", and the field is required, so you can't submit the form without agreeing to the waiver terms).
Comments.UserDisplayName: Lars SG
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-18T11:49:45.770Z
Comments.Text: @LarsSG Thanks so much for your reply
Comments.UserDisplayName: Tapash
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-11-14T20:43:19.110Z
Comments.Text: surprised to hear that using 'edit submission' takes you back to the payment form. will have to go look
Comments.UserDisplayName: petednz - fuzion
Tags: <webform-civicrm>
Title: Can you edit webform submission values without invoking payment?
ThreadText: # Can you edit webform submission values without invoking payment?
  
  (Asked by: username_0 on 2019-06-18)
  
  We have a webform that is used for a complex event registration, with all of the registration details stored in the webform and nothing in CiviCRM except the contribution record.
  
  We'd like to be able to edit some of the registration details that users have submitted to the webform, but using the edit submission link leads to the payment part of the submission - requiring that payment details be entered again.
  
  Is there any way to simply edit some of the webform submission values, which aren't connected to the payment, without resubmitting the payment?
  
  **Tags:** webform-civicrm
  
  > **Comments:**
  > **username_1**: I'd love to see your webform! You might check out an approach of viewing the submission results in a view and then using something like this (https://drupal.stackexchange.com/questions/189636/editable-webform-fields-in-views) or editable views module to edit without re-submitting  
  > **username_0**: Here's the public side of the webform:https://secure.wildsight.ca/get-wild-summer-day-camp-2019-registration  
  > **username_1**: Another weird approach might be to create a role that did not have permission to the payment component and try editing/saving that way: https://www.drupal.org/project/webform_component_roles note - this is untested wild hypothesis :)  
  > **username_2**: @username_0 which payment processor are you using?  
  > **username_2**: @username_0 also could you please tell me how did you add T&C page to weborm? thanks  
  > **username_0**: @username_2 We're using IATS The waiver is just a page break, a markup field for all the wording, a text field for the initials and a radio select that you accept the waiver terms (there is only one option, "Yes", and the field is required, so you can't submit the form without agreeing to the waiver terms).  
  > **username_2**: @username_0 Thanks so much for your reply  
  > **username_3**: surprised to hear that using 'edit submission' takes you back to the payment form. will have to go look  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_4 on 2020-11-14. Score: 0
  
  <https://www.webwash.net/integrate-webform-and-google-sheets-using-zapier-in-drupal-8/>
  
  1. Drupal 8 you can install Webform Remote Handlers module <https://www.drupal.org/project/webform_remote_handlers>
     Drupal 7 has a similar module (Webform Remote Post) that also works but it is no longer maintained. .
  2. Create a Zap in Zapier to connect the results to a Google Sheet.
  
  Now when someone submits a webform, the results are added as a line on the Google Sheet. This allows your non-techy staff to view, edit, sort in a format they are very comfortable with.
  
  
  ---
  
  ### Answer by username_1 on 2019-06-22. Score: 0
  
  Here's another possible solution
  <https://www.drupal.org/project/webform_import>
  
  
  ---
  
  