Dev {Tricks}

  • Home
  • WordPress
  • OJS
  • Oxwall
  • Server and Hosting
You are here: Home / Archives for Wordpress / Plugins / Contact Form 7

February 22, 2021 by dev

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

Filed Under: Contact Form 7, Find and Fix, How to, Plugins, Wordpress

February 7, 2021 by dev

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"]

 

 

 

Filed Under: Contact Form 7, How to Tagged With: Contact form, Contact form 7, drop down menu, first as label, include blank, placeholder, select an option, select option

August 19, 2019 by dev 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

Filed Under: Contact Form 7, Email Solutions, Google Spreadsheet

August 19, 2019 by dev 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

Filed Under: Contact Form 7, Email Solutions, Google Spreadsheet, How to Tagged With: google spreadsheet, google spreadsheet id, sheet excell, sheet id, spreadsheet id, spreedsheet

April 8, 2018 by dev 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);
});
});

Filed Under: Contact Form 7, Plugins, Wordpress

  • Upwork
  • Freelancer
  • Fiverr
  • Guru
  • PPH

Recent Posts

  • MariaDB Upgrade to the new version | Plesk – CentOS 7 / RHEL 7
  • Google Workspace MX record values
  • Could not open input file
  • How to remove journal path for single journal OJS website.
  • How to Clean the YUM Cache in CentOS
  • How to run php file through command line? How do I enable PHP?
  • How to disable functions using the PHP disable_functions directive in php ini
  • Error 503 Backend fetch failed
  • Unblock iRedMail IP
  • Most Read Articles
  • Import export database | Linux
  • How to reset MySQL root password | CWP
  • MariaDB Upgrade to the new version | CWP
  • Install Optimize with optimize.js (sync)
  • Journey to Laravel & Vue – December to February 2022/2023
  • Elementor
  • Java Errors
  • How to Install Zip/Unzip
  • Redirect www to non-www and vice versa
  • How to change Time Zone in Debian 11 / Debian 10

Categories

  • Affiliate Marketing (1)
  • Customization (3)
    • CSS (1)
  • Email Solutions (20)
    • FrontApp (1)
    • Google Spreadsheet (2)
    • Microsoft Outlook (1)
    • PHP Email Form (3)
    • PolyMail (1)
    • Recaptcha (1)
    • Roundcube (3)
    • Thunderbird (2)
    • WebMail (4)
  • Games (1)
  • How to (75)
  • Joomla (6)
    • Akeeba (1)
    • Fix & Tricks (3)
  • jQuery (3)
  • jQuery Plugins (4)
    • BX Slider (1)
    • Slick (1)
  • Laravel (1)
  • Marketplace (5)
  • Miscellaneous (26)
  • OJS (52)
    • Help (35)
    • Installation (9)
      • Issues (5)
    • Plugins (7)
    • Theme (6)
      • Templates (6)
        • Frontend (5)
        • legacy (1)
    • Theme Customization (9)
    • Theme Development (13)
    • TPL CSS JS (2)
    • Upgrade (11)
  • Oxwall (3)
  • Payment Methods (1)
    • Paypal (1)
  • PC Tips and Tricks (12)
    • MS Office (1)
      • PowerPoint (1)
    • Windows (3)
  • PHP Parse error (2)
  • phpBB (1)
  • Server and Hosting (174)
    • Billing and Management (10)
      • Blesta (5)
      • Boxbilling (2)
      • WHMCS (5)
    • Debian (5)
    • Email (9)
      • Postfix (3)
    • Error and Fix (16)
    • FTP (2)
    • Mail Server Solusion (5)
      • iRedMain (4)
    • MySQL (9)
    • Providers (54)
      • AWS (23)
      • Bluehost (23)
      • Cloudcone (12)
      • Contabo (26)
      • Digitalocean (54)
      • HostGator (22)
      • VPSDime (24)
    • Security (18)
      • SSH (6)
    • VPS Management (60)
    • Web Control Panel (125)
      • CentOS Web Panel (36)
      • cPanel (24)
      • DirectAdmin (89)
        • Find & fix (38)
      • ISPConfig (11)
      • Plesk (20)
      • Webmin (19)
        • Usermin (2)
        • Virtualmin (11)
      • WHM (13)
  • Uncategorized (14)
  • Wordpress (86)
    • Elementor (2)
    • Find and Fix (9)
    • Functions (5)
    • Genesis (9)
    • Glossary (1)
    • How to (20)
    • Neuron TD (15)
      • Console Error (1)
      • functions (5)
        • register_post_type (1)
        • register_sidebar (1)
        • theme_files (1)
        • theme_supports (1)
      • Image Directory (1)
      • Menu (2)
      • Query (4)
    • Plugins (12)
      • Contact Form 7 (5)
      • Duplicator (1)
      • Essential Grid (2)
    • Softaculous (3)
    • Speed and Security (4)
    • Stock Theme Development (6)
      • Header Footer (1)
      • PHP (1)
      • VC (1)
    • Theme Development (2)
      • Issues (1)
      • Menu (1)
    • Timer Theme Development (3)
    • Update (2)
    • Woocommerce (2)
    • WP Basic Guideline (8)

Important DEV links

  • Premium Themes
    • Themeforest
    • Envato Market
  • Built With (What Theme is That?)
    • What WP theme is that
    • Joomla Template Detector
    • Drupal Template Detector
    • Prestashop Template Detector
    • Shopify Theme Detector
    • Squarespace Template Detector
    • OpenCart Detector
    • WordPress.com Theme Detector
  • Domain/IP history checker
    • Who IS request
    • Hosting Info
  • Check DNS Propagation
    • DNS Checker
    • intoDNS
  • What is my IP
    • What is My IP Address
    • What is My IP
    • IP location
    • What is My IP
    • Porkbun
  • SEO Tools
    • Visitor Traffic
    • Broken Link
    • Website Speed Test
      • SEMrush
      • GTmetrix
      • Pingdom
      • PageSpeed Insights
      • DebugBear
      • keyCDN
  • Photo Image
    • Remove Background 50 Free Preview Image 375 × 666 per month
  • Domain Registrars
    • 123-Reg
    • Porkbun
    • Freenom
    • Namecheap NEWCOM598
  • Hosting Providers
    • Bluehost
    • Hostgator
    • Inmotion
  • Hosting Control Panel
    • CWPpro (FREE)
    • DirectAdmin (Trial 60 Days, One account $2/month)
    • ISPConfig (Free)
  • Webmaster Tools
    • Google
    • Bing
    • Yandex
  • Miscellaneous
    • Time Calculator

 

  • Home
  • WordPress
  • OJS
  • Oxwall
  • Server and Hosting

Copyright © 2023 · Executive Pro Theme on Genesis Framework · WordPress · Log in