Michael Simpson
Forum Replies Created
-
Forum: Plugins
In reply to: [Contact Form DB] filtering between $_POST datesThat last line is Javascript code but [cfdb-table] does not output Javascript. I don’t know how you are generating that output.
Forum: Plugins
In reply to: [Contact Form DB] No longer on WordPressInstall from: https://github.com/mdsimpson/contact-form-7-to-database-extension/releases
Install this to keep it updated: https://github.com/afragen/github-updater
Forum: Plugins
In reply to: [Contact Form DB] Missing from Plugin directoryYou can keep the plugin updated by installing the GitHub updated plugin. https://github.com/afragen/github-updater
Forum: Plugins
In reply to: [Contact Form DB] Use the count shortcode inside a PHP functionIn the array you are passing to $exp->export, add
"tfilter" => "yourfield==null"or whatever filter expression you prefer. “tfilter” expressions are evaluated prior to transform functions, “filter” expressions are evaluated after.
Forum: Plugins
In reply to: [Contact Form DB] Date range filter for data – CFDBSee if this works:
[cfdb-datatable form="Schedule Tracker" filter="submit_time>=$_POST(start)&&submit_time<=$_POST(end)"]Forum: Plugins
In reply to: [Contact Form DB] Missing from Plugin directoryIt is now found here: https://github.com/mdsimpson/contact-form-7-to-database-extension/releases
Forum: Plugins
In reply to: [Contact Form DB] CFDB EditorYes, by setting the “edit” attribute on [cfdb-datatable] to “true” or “cell”, such as:
[cfdb-datatable edit=”true” form=”your-form”]
Forum: Plugins
In reply to: [Contact Form DB] CFDB export credit card no to ExcelThere is nothing you can do in CFDB to do this. But you should be able to format the cells inside excel to be Text instead of Number.
Forum: Plugins
In reply to: [Contact Form DB] [Contact Form DB] Problem sorting larger numbersUnrelated: remove the space before && (may cause a problem).
I looked into this a bit. This get evaluated by the PHP strnatcmp function. Researching this, I see that it does not recognize commas the way we expect, but treats them more like “.”.
If the information in that field is all numbers, then just use SortByField instead of NaturalSortByField
Forum: Plugins
In reply to: [Contact Form DB] Google Spreadsheet Live Data – Not auto updatingI’m not aware of a way to force the Google Sheet to update on a schedule we define. It seems to update when it decides to do so.
Forum: Plugins
In reply to: [Contact Form DB] Counting Food CategoriesTry [cfdb-count]
Putting a shortcode in the CF7 form definition does not work. It will not be processed. You would have to check CF7 forums to see if there is a way to make CF7 process regular shortcodes in its form definition. Otherwise you would have to post the CFDB shortcode in the post before or after the CF7 shortcode.
Forum: Plugins
In reply to: [Contact Form DB] filtering between $_POST datesTake out all the spaces around <= and =>
Forum: Plugins
In reply to: [Contact Form DB] attacment in db?Assuming your attachments are images: https://cfdbplugin.com/?page_id=1420
Forum: Plugins
In reply to: [Contact Form DB] preventing duplicate submissions from cf7Change these three lines in the above code to match your need:
$formName = 'NAME OF YOUR FORM'; // Change to name of the form containing this field $fieldName = 'NAME OF YOUR E-MAIL FIELD'; // Change to your form's unique field name $errorMessage = 'ERROR MESSAGE HERE'; // Change to your error messageForum: Plugins
In reply to: [Contact Form DB] Display table filter by userFiltering by the logged in user: https://cfdbplugin.com/?page_id=116