zap a form submission to google sheets

😎https://docupletionforms.com/formbuilder/forms/facebook/0 – submit the form and it sends the submission data via a webhook to zapier and then zaps it to google sheets. you can set the EXACT data you want to capture on the sheet. it also sends the message to the DocupletionForms Facebook Page (https://www.facebook.com/DocupletionFormscom-334900587305585/) and Twitter Page (https://twitter.com/docupletion). All FREE via DocupletionForms.com!

Contact Admin and we will setup a webhook from your form to your Zapier. You can Zap to Gmail or ActiveCampaign!

You can setup a Zap inside of your FREE Zapier Account to connect a Webhook by Zapier to your Gmail or your ActiveCampaign.  Just send us the Webhook URL in a message on our contact (example of just our basic auto-responder) form along with the name of the form you want it connected to as well as your account email address and Admin will connect your Webhook.  Simple.   an example of the Gmail Integration is our sample form. —  an example of our ActiveCampaign Integration is the FREE GUIDE Signup on ApexLawService.com.  —

😎https://docupletionforms.com/formbuilder/forms/facebook/0 – submit the form and it sends the submission data via a webhook to zapier and then zaps it to google sheets. you can set the EXACT data you want to capture on the sheet. it also sends the message to the DocupletionForms Facebook Page (https://www.facebook.com/DocupletionFormscom-334900587305585/) and Twitter Page (https://twitter.com/docupletion). All FREE via DocupletionForms.com!

here is a link to the google sheet https://docs.google.com/spreadsheets/d/1tYHeP16GOPmPrzEG1HYR1wKglzj-FOF02GCBNffedC8/edit?usp=sharing

 here is a blog about just the zap to google sheets

Disable a Hidden Field that is Required When Shown!

1. if you have a checkbox that you want checked so that people filling out your form, you have to uncheck to deselect it rather than check it to select it, type the following:   

                                                         |check   

right after the selection in the checkbox just like the illustration below.

2. then in the field that you want shown if somebody leaves the checkbox checked, click required so that we can then go to the conditional logic to show you how to properly conditionally disable and enable the required field.

3. check to disable the field in the add action when the checkbox is not checked.  then make sure to make a second rule (at the very bottom) that hides the field is the checkbox is not checked.  this way you do not set the field to be required and when it is hidden have a form that cannot be submitted because there is a hidden yet still required field.  fun, fun, fun.  

link to the form so you can see the disabled element be required and enabled when selected and shown.

https://docupletionforms.com/formbuilder/forms/example-conditional-logic-form

Confirmation, Notification and Embed/Link Settings

1. click the settings tab in the actions drop down menu in the form tab.
2. click the circled elements and make sure to enter the appropriate information so that the person submitting their form receives a confirmation email.  i circled the redirect to another page setting, but you can select the two options that give the person submitting the form a message rather than redirecting them anywhere.

3. click the circled elements and make sure to enter the appropriate information so that you yourself receive a preset notification email.

4. click the publish & share tab in the actions drop down menu in the form tab.

5. click either the embed full form tab (gives you an html code to embed into your page where you want to embed the form.  our name will not appear at the top of your form), the embed pop up form tab (gives you an html code and it is really nice looking the way it makes the form pop over the page where you embed it.  it can cause problems with the spacing on your desktop viewed website pages and it can also interfere with smartphones.  you just have to fiddle with it.  it is super nice looking.  our name will not appear at the top of your form), or the share link tab (leave the without box checkbox unchecked at the bottom friendly link section and our name will show at the top of your form, check it and it will not show, but it will be a full page.)


6. click the

How to set conditional logic rules in a form.

1. Made a simple contact form with 3 fields we do not need to show unless the answer to the previous question indicates that the person filling out the form has one or more of the following: phone number, website or Facebook.

2. So then we save the form and click the 3rd option at the bottom so that you can use the Form Manager to set the conditional logic rules.  

3. In the Form Manager click actions and conditional rules.

4.  Then click add rule, condition and action 3 times or however many times you need to set as many rules as you want.  These are simple rules for showing a text field question if the person has indicated in the check box that they have any of the following: phone, website, Facebook. Simple. 

The link to this form is: https://docupletionforms.com/formbuilder/forms/example-conditional-logic-form

Hope this helps.  – James

How to signup to use the FREE Form Editor inside of DocupletionForms.com

This is a quick tutorial with pictures of how to setup a conditional logic form.  At the end there is a link to an article on our our professional association site NAOLDP on how to use the Data-Merge.  Thanks for reading.  – James

1. go to www.DocupletionForms.com, click to signup for the free form editor.

2. click the signup button

3. enter an email and a password

4. click create form

5. drag, drop & customize as many contact form elements as you want to inside of the form editor screen.  make sure to add a submit button, and click save.

6. you have 3 options, but we are going to click the 3rd finished option that says take me to the form manager so that we can set conditional logic rules.  conditional logic rules are what tell your form to ask different next questions of the people filling out your form based on their answers to the previous questions in the form.  

7. to the right of the form you are working on, click the action button and select the conditional rules tab from the drop down menu.

8. click add rule.

9. set a condition and set an action.  make sure to click the green save button.

10. go back to the forms screen and select the submissions tab from the drop down menu.

11. click the eye button to the right to see the submission.

12. i wrote a neo-irish blessing for fun.

13. below is the form reader that can be accessed by paying $5 for the Paid Data-Merge on the front page of DocupletionForms.com.  

 

 14. Click Here for a link to an instructional on how to use the Data-Merge.  


thanks for checking out the free form editor.  

 

Regards,

James F. Polk, Founder of DocupletionForms

 

Our New Logo!

DocupletionForms.com is a FREE Contact Form Program with a $5 Data-Merge element that can be added.

The FREE Contact Form Program has Conditional-Logic Capabilities.  This means you have the capacity to set rules after you make and save a form, so that the form will ask different next questions of the people filling out your form based on their last answers.

The $5 Data-Merge element allows you to upload and complete .PDF documents with just a few clicks.

Thanks for reading the blog.

Regards, James F. Polk, Founder of DocupletionForms.