Data Source for Contact Form 7 vs Participants Database

Data Source for Contact Form 7 plugin allows populating the “Contact Form 7” fields (text, email, URL, drop-down menu, …) with data stored in external data sources, like a database, CSV file, URL parameters, users information, post data, taxonomies, Advanced Custom Fields (ACF) – Secured Custom Fields, and JSON objects. Data Source for Contact Form 7 includes two new controls in the controls bar of Contact Form 7, recordset and recordset field link. The “recordset” control reads the information from the external data source (a database, a CSV file, or any other data source supported), and the “recordset field link” control for linking the recordsets and form fields to populate them with the recordset data. A form can include several “recordset” fields, and it is possible to link multiple “recordset field link” controls to the same recordset. The new SQL-Generator module. It generates the database queries in a more conversational style. Just describe the information needed, and get the DB query without any prior database knowledge. How to create the simplest contact form from our practical examples. The plugin includes other complementary controls in the controls bar in addition to the “recordset” and “recordset field link”. The “Print Form” button for printing the form area, “Data Table” control for inserting an advanced table with the recordset records, “copy to clipboard” functionality for copying the values of the fields into the clipboard, and the “Search box in dropdown menu” functionality to make easy the selection in long dropdown menus. Features: Set the information of external data sources available for the Contact Form 7 fields. Easy to use, includes two new controls in the controls bar to define the recordsets and the link fields. Includes the “URL Parameters” data source to populate the form’s fields with the values of the URL parameters. Includes the “Users Information” data source to populate the form’s fields with the users’ information. Includes the “Posts Information” data source to populate the form’s fields with the posts’ data, pages, and custom post types (like the WooCommerce products). Includes the “Taxonomy” data source to populate the form’s fields with taxonomy terms, like categories, posts tags, or any other custom taxonomy. Includes the “Database” data source to populate the form’s fields with the information of a database. Allow defining even complex queries. SQL Generator module. It generates the database queries in a more conversational style. Includes the “Javascript Function” data source to populate the form’s fields with the information returned from a Javascript function. Allows using the fields’ values for filtering the recordset records. Complementary Controls add-on. Includes additional controls and functionalities, such as the “Print Form” button, the addition of the search box to the drop-down menu, copy to clipboard functionality, and Data Table to display the data source records. Features in Premium version: All features of the free version of the plugin. Includes the “Advanced Custom Fields (ACF) – Secured Custom Fields” data source to fill the form filds with data stored in the Advanced Custom Fields or Secured Custom Fields in post, users, comments, taxonomies, widgets, and options. Includes the “CSV” data source to populate the form’s fields with the data store into a CSV file. Includes the “JSON” data source to populate the form’s fields with the data store into a JSON file. There are hundreds of services whose outputs are JSON objects. PDF Generator add-on. It generates PDF files with the information collected by the form and attaches them to the notification emails (Supports the “Conditional Fields for Contact Form 7” plugin tags in the PDF file content if the “Conditional Fields for Contact Form 7” plugin is installed on the website). Post Generator add-on. It generates new posts (posts, pages, or any custom post) with the information collected by the form. User Registration add-on to convert contact forms into user registration forms. CSV Generator add-on to populate a CSV file with the information collected by the form. JSON Generator add-on to populate a JSON file with the information collected by the form. Server Side add-on to implement server side functions to call from the Recordset controls and get the list of records. Data Source Fields Data Source for Contact Form 7 includes two new controls in the controls bar of Contact Form 7, recordset and recordset field link. The recordset control reads the information from the external data source and makes it available on the form. A recordset field can read one or many records from the data source. To insert a recordset field in the form, press the “recordset” button in the controls bar. This action opens a dialog to define the recordset. The insertion dialog includes common attributes for all data sources and specific attributes for the data source selected. The “recordset field link” control links a recordset field to other fields in the form to populate them with the recordset data. To insert a link field in the form, press the “recordset field link” button in the controls bar. This action opens a dialog to define the relationship between a recordset and a form’s field. The link dialog includes the attributes to define the relationship between the recordset field and the form’s fields. Cases of Use Get the information of the registered user and populate the form fields for his name and email: Your name [text* your-name] Your email [email* your-email] Subject [text* your-subject] Your message (optional) [textarea your-message] [cf7-recordset id="cf7-recordset-434" type="user" attributes="first_name, user_email" logged="1"] [cf7-link-field recordset="cf7-recordset-434" field="your-name" value="first_name"] [cf7-link-field recordset="cf7-recordset-434" field="your-email" value="user_email"] [submit "Submit"] Filling a plain text in the form with the first name and last name of the logged user: Hello Enter your address [textarea address] [cf7-recordset id="cf7-recordset-434" type="user" attributes="first_name, last_name" logged="1"] [cf7-link-field recordset="cf7-recordset-434" field="first-name" value="first_name"] [cf7-link-field recordset="cf7-recordset-434" field="last-name" value="last_name"] [submit "Submit"] Populates the list of WooCommerce products and get the price of the selected one: Products List [select menu-719] Product Price [number number-534] [cf7-recordset id="cf7-recordset-619" type="database" engine="mysql" query="SELECT ID,post_title,meta_value as price FROM {wpdb.posts} posts, {wpdb.postmeta} meta WHERE posts.post_type='product' AND posts.ID=meta.post_id AND meta.meta_key='_regular_price'"] [cf7-link-field recordset="cf7-recordset-619" field="menu-719" value="ID" text="post_title"] [cf7-link-field recordset="cf7-recordset-619" field="number-534" value="price" condition="record['ID']=={field.menu-719}"] [submit "Submit"] Using templates to create complex data structures. Displaying the title and excerpt of every published post: {attribute.post_title} {attribute.post_excerpt} [cf7-recordset id="cf7-posts" type="post" attributes="post_title,post_excerpt" condition="post_status='publish' AND post_type='post'"] [cf7-link-field recordset="cf7-posts" field="posts-list" value="{template.summary}"] The form includes a template tag to design a complex data structure. To access the records attributes from the template, use {attribute.attribute-name} format. Ex. {attribute.post_title} You can use the templates for the fields’ values or texts. The format for referring to templates is {template.template-id}. You should replace “template-id” with the id of the template tag. Ex. {template.summary} [cf7-link-field recordset="cf7-posts" field="posts-list" value="{template.summary}"] Using Javascript to Access the Recordset Data The recordset fields trigger the “cf7-recordset” event after receiving the information from the data source, allowing you to access this information with Javascript. In this example, the recordset field reads motivational phrases from a third-party service and displays the first of them into a DIV tag on the form. Add ons (Extensions) Complementary Controls add-on PDF Generator add-on Post Generator add-on User Registration add-on CSV Generator add-on JSON Generator add-on Server Side add-on

This plugin offers all the functionality needed to build and maintain a database of people or anything you want. The database is fully configurable, allowing you to define all the fields of information you want to store for each record. The records can be entered individually in the WordPress admin section, imported with a CSV file, or let the individuals themselves create their own record. Display lists of records can be sorted and filtered by any field, and the result exported as a CSV file. This plugin was developed for an organization with the mission of educating and empowering voters. This organization needed to quickly build a database of concerned voters, supporters, and volunteers, giving them an ability to collect input and feedback, organize volunteers, and mobilize its voter constituency with actions such as petition drives and voter education campaigns. This database could be of use to any organization that needs to build and maintain lists of constituents, supporters, members, volunteers, etc. for any purpose. It is designed to be easy to use and serve multiple purposes, with several very powerful features to customize its functionality to the needs of your organization, club, sports team, or any other large group of people. The plugin can be easily adapted to work as a database for other applications such as indexes, directories, catalogs, or anything, really. The plugin uses a system of customizable templates for all its displays, and an API for the customization and extension of its capabilities. The plugin is fully internationalized with a growing set of translations. GDPR Compliance Information for users of Participants Database Some of the features of the Participants Database Plugin: fully configurable database for holding any kind of information about people (or anything, really!) customizable forms for collecting and maintaining records plugin enhancements and add-ons are available from a growing list of free and premium downloads on xnau.com shortcode for inserting a configurable sign-up short form into WordPress pages, posts, etc. completing the sign-up form can direct visitors to another page for a thank you message or reward shortcode for inserting a full-length form for people to fill out and maintain their own records shortcode for displaying the list on the site, including the ability to select and order columns to display, sorting and filtering rules to determine which records are shown and in what order shortcode for showing a search form that takes the user to the search results page email notification and confirmation with secure individual access link email notification when a user edits a record searchable, sortable record listings in the WordPress admin many form elements to choose from including dropdowns, checkboxes, radio buttons, image upload, rich text, etc. export CSV files for interacting with other databases, mass email, print records import CSV files to add large numbers of records from spreadsheets such as Open Office or Google Docs forms can be organized into groups of fields, making long forms easier to navigate and fill out comes with a comprehensive API for deep customization of the plugin functionality Database The heart of this plugin is the participants database, which is completely configurable. It comes pre-filled with standard fields such as name, address, phone, etc., but you can define any fields you want, including the type of field, validation, help text and a print title for each field. Fields are also organized into groups so large amounts of information can be better managed, and long forms broken up into logical sections. Fields can be defined as text-lines, text-areas, rich text (with a rich-text editor), single and multiple-select dropdowns, checkboxes, radio buttons or image uploads. Each field has its own validation which can be required, not required, or validated with a regular expression. Sign Up Form The plugin provides a shortcode for a sign-up form that presents a customizable subset of the fields for a quick signup. For example, your signup form could ask only for a name and email address, creating an easy point-of-entry for new members, supporters or volunteers. The signup can generate two emails: one to an administrator to notify them of the signup, and also to the person signing up. Their email can contain a link to their full record, which they can return and fill out at their leisure. This full form (which is placed on the website with another shortcode) can include any information you want to collect from your signups. Signup forms are produced by a template, making it easy to add extra functionality and match the presentation of the form to your theme. Frontend Record Edit Form This is where people who have signed up can fill in any additional information about themselves you wish to collect. It can be additional demographic info, survey questions, what they would be willing to offer in support. This form is accessible to the signups via an individual link containing an ID number, which is emailed to them when they sign up. They don’t need to register as a user or enter a password, they just need the link. Backend Record Editing For your backend users, the ability to edit and enter new records is provided. This backend form can also contain administrative fields that won’t be visible to the front-end (not logged-in) user, so organization staff can keep internal records of volunteer activities, availability, contributions, personal notes, etc. The backend form is set up for rapid manual entry of multiple records, such as after a signup drive, doorbelling, or public event. For textarea fields, a rich-text editor will be used if enabled in the settings. List Display Display the list on your website with the [pdb_list] shortcode. You can determine which fields get shown, and for long lists, the list can be broken up into pages. You can specify which records get displayed and in what order. Optionally, search and sorting controls can be displayed. Each record listing can be linked to the full record showing all the details of the record. Record Display Each individual record can be displayed using a shortcode and accessed by the ID if the record. A template file formats the output of the shortcode. A plugin setting determines how a link to the individual record may be placed on the list of records. Import/Export Records All records can be exported as a CSV-formatted text file that can be read by spreadsheet applications and used for mass email campaigns, hard-copy lists, and other applications. The records exported can be filtered by column values: for instance, only people who have consented to receive a newsletter will be included. Records may also be sorted by any column. Which fields are included in the export/import is determined by the “CSV” column of the field definition. Records can also be mass-imported with a CSV file, allowing you to use existing lists from spreadsheets, or for offline compilation of records using a spreadsheet such as Libre Office or Google Docs. A blank spreadsheet can be exported from the plugin to get people started in entering records offline. Internationalization and Translations This plugin is fully compliant with WordPress Internationalization standards and includes several translations, some of which are incomplete at the moment. All of the front-end text is user-customizable, so even if a translation isn’t available for your language, your users will be able to use the plugin in their language. Translation Credits Belarusian: Natasha Dyatko UStarCash Danish: LarsHdg Dutch: At Voogt www.wederzijdsgenoegen.nl Estonian: Laura Vunk Farsi: Mohsen Azarteymoor CodHa Finnish: Visa Jokela French: Pierre Fischer German: Martin Sauter German Formal: Hanno Bolte Hanno Bolte IT Consulting Greek: Toni Bishop Jrop Hebrew: Gila Baam Indonesian: Jordan Silaen ChameleonJohn.com Italian: Michele Balderi Norwegian: Anders Kleppe Polish: Łukasz Markusik Brazilian Portuguese: Eric Sornoso Mealfan.com Romanian: Cornelia Năescu Russian: Konstantin Bashevoy Полиатлон России Serbian: Cherry, NBG, www.trade.in.rs Slovak: Branco Radenovich WebHostingGeeks.com Spanish: Chema Bescos IBIDEM GROUP Ukranian: Michael Yunat, getvoip.com If you are multi-lingual and feel like contributing a translation, please contact me at: [email protected]. Please note that several of these translations are out of date. If your language is in this list and you’d like to help me provide the latest translation, please contact me. The latest POT file is always available here. Key Image Credit By Tukulti65 (Own work) [CC BY-SA 4.0 (http://creativecommons.org/licenses/by-sa/4.0)], via Wikimedia Commons Plugin Support Plugin manual and documentation is published on the developer’s website, xnau.com Plugin technical support is available on the WordPress Plugin Plugin Support Forum, and on xnau.com in the comments section. A growing list of plugin add-ons and functionality enhancements are also available on xnau.com.