Dev {Tricks}

You are here: Home / Archives for Wordpress / Plugins / Contact Form 7

by

Contact Form 7 – Google Sheet Integration

  • Connect google sheet with contact form 7

CF7 Google Sheets Connector

  • Install “CF7 Google Sheets Connector” Plugin which will send the Contact Form’s data to the Google Sheet.

Google Spreadsheet

  • Create a google sheet at https://docs.google.com/spreadsheets
  • In Google Sheets, provide the Columns name in Row 1. (For eg. “your-name”, “your-email”, “your-subject”, “your-message”, etc).
  • Name the first column as “date” if you want to keep the record of the date.

Google Sheet Settings

From dashboard click on the form and go to the Google Sheets tab.

  • Google Sheet Name
  • Google Sheet Id
  • Google Sheet Tab Name
  • Google Tab Id

by

Contact form 7 default select option value

  • Contact form 7 default select option value
  • Contact form 7 default select value
  • Contact form 7 set default value
  • Contact form 7 default select placeholder

Use first_as_label

[select fieldName first_as_label "Select Option" "Option 1" "Option 2" "Option 3" "Option 4"]

Use include_blank

[select fieldName include_blank "Option 1" "Option 2" "Option 3" "Option 4"]

 

 

 

by Leave a Comment

Create Spreadsheet. How to get Google Sheet as json file?

  1. Create spreadsheet at https://docs.google.com/spreadsheets/u/0/
  2. Publish the created spreadsheet on the web.
  3. You will get spreadsheet url at google drive like https://docs.google.com/spreadsheets/d/15w2MY4pmzHmS8zC6X-EVxEGCtAVeUsFNJwrPu0/edit#gid=8699371
  4. Using the spreadsheet url you can get json endpoint file as follows
    https://spreadsheets.google.com/feeds/cells/YOURGOOGLESHEETCODE/SHEETPAGENUMBER/public/full?alt=json
  5. Replace
    YOURGOOGLESHEETCODE with 15w2MY4pmzHmS8zC6X-EVxEGCtAVeUsFNJwrPu0
    SHEETPAGENUMBER to 1
  6. Now the url will look like https://spreadsheets.google.com/feeds/cells/15w2MY4pmzHmS8zC6X-EVxEGCtAVeUsFNJwrPu0/1/public/full?alt=json
  7. Browse the final url and you will get json.

Thanks

by Leave a Comment

How to get Google Spreadsheet ID and sheet ID?

Google Spreadsheet ID and Google Sheet ID can be find easily in doc url.

https://docs.google.com/spreadsheets/d/spreadsheetId/edit#gid=sheetId

https://docs.google.com/spreadsheets/d/this-is-spreadsheet-id/edit#gid=this-is-sheet-id

Read more at https://developers.google.com/sheets/api/guides/concepts#sheet_id

by 2 Comments

Limit checkbox select

Contact form 7

[checkbox* SelectTree class:SelectTree "Flowering Dogwood" "Red Maple" "Sugar Maple" "Service Berry (Amelanchier Canadensis)" "Service Berry (Amelanchier arborea)" "River Birch" "Elm (Canopy tree)" "Fruitless Sweet Gum (Canopy tree)" "American Linden (Canopy tree)" "American Hornbean (Canopy tree)" "American Hazelhut (Fruit tree)" "Apples (Fruit tree)" "BlueBerry (Fruit tree)" "Pears (Fruit tree)"]

Jquery (Limit select 3)

jQuery(function(){
var max = 3;
var checkboxes = jQuery('.SelectTree input[type="checkbox"]');

checkboxes.change(function(){
var current = checkboxes.filter(':checked').length;
checkboxes.filter(':not(:checked)').prop('disabled', current >= max);
});
});