Shortcode Basics
Shortcode Basics
The following shortcodes are provided:
- [cfdb-datatable]
- [cfdb-table]
- [cfdb-json]
- [cfdb-value]
- [cfdb-count]
- [cfdb-html]
All of these shortcodes provide a set of common options, so they are documented here. We will use [cfdb-table] in our examples, but understand it applies to all shortcodes.
Simplest Shortcode Example
You have a form named “myform” and you want to display all its rows and columns in a page or post:
[cfdb-table form="your-form"]
This shows the whole table with CSS provided by the plugin. See the page on [cfdb-table] to learn more about how to apply your own styles.
Choosing which Columns to Display with “show” and “hide”
[cfdb-table form="myform" show="field1,field2,field3"](optionally show selected fields)[cfdb-table form="myform" hide="field1,field2,field3"](optionally hide selected fields)[cfdb-table form="your-form" show="f1,f2,f3" hide="f1"](hide trumps show, f1 will be hidden)
As of version 1.8, “show” and “hide” now support regular expressions to be able to specify column names. Regular expression match according to preg-match.
Examples:
[cfdb-table form="myform" show="/.*name/"](shows all fields whose name ends with “name” such as “first-name” and “last-name”)
[cfdb-table form="myform" show="/.*name/i"](Same as previous, but is a case-insensitive match. So “Last-Name” as well as “last-name” match)
[cfdb-table form="myform" hide="/Submitted.*/"](Don’t show fields starting with “Submitted”)
[cfdb-table form="myform" hide="message,/Submitted.*/,/Cookie.*/"](Don’t show (1) the “message” field, (2) fields starting with “Submitted”, (3) fields starting with “Cookie”. If you have the option on to capture users’ Cookies with their form submissions, use hide=”/Cookie.*/” to hide them. )
- Remember that is you have both “show” and “hide” specified, any field that match both will be hidden. That is, “hide” trumps “show”.
Adding Security With “role”
(As of version 2.4.1) The “role” attribute can limit the short code to only create output for logged-in users with a minimal user role. Set the “role” attribute to one of:
- Administrator
- Editor
- Author
- Contributor
- Subscriber
- Anyone
Example: if role="Editor" is used, then a user logged in with role Author, Contributor or Subscriber sees no output. A user logged in who has role Editor or Administration will see the output. Editor and Administration users who are not logged in will see no output.
WARNING: This security setting is overridden by the plugin-wide setting that limits what roles can see data from short codes. In the WP Admin area, go to Contact -> Database Options -> Can See Submission when using shortcodes. If that setting is set to “Author” for example, then no user will less than Author role can see output from any short code even if you have role="Anyone" in a short code. You may find it most useful to set the plugin-wide setting to “Anyone” then use “role” on your short codes. The plugin-wide setting is there to allow an administrator to prevent Contributers, Authors and Editors from writing short codes in posts that might reveal data that they are not permitted to see.
Notes:
- The Anyone role implies that users do not have to be logged in to see the short code output
- Case Counts. Be sure to capitalize the first letter of the role names
- If you set
permissionmsg="true"then an error message will show on your page when a user does not have permission. By default, if “role” is being used, no permission error is shown.
Hiding Permission Message with “permissionmsg”
(As of version 2.4.1) In cases where a user does not have adequate permission to view the output of a short code, in place of the short code output, the following message is displayed:
You do not have sufficient permissions to access this data.
If you wish to have no message displayed, set permissionmsg=”false” in your short code.
Limiting How Many Rows to Display with “limit”
Say you just want the first 10 rows, not every form submission. Use “limit”
[cfdb-table form="myform" limit="10"](shows only the first 10 rows)
[cfdb-table form="myform" limit="0,10"](shows only the first 10 rows starting with row #0 which is the first row. This is the same as just using limit=”10″)
[cfdb-table form="myform" limit="10,10"](shows only the first 10 rows starting with row #10. In other words, this shows rows #10-19. The previous example shows rows #0-9. So this is like the next page of 10 rows.
[cfdb-table form="myform" limit="20,10"](shows only the first 10 rows starting with row #20. In other words, this shows rows #20-29. The previous example shows rows #10-19. So this is like the next page of 10 rows.
Choosing Random Rows to Display with “random”
(Available in version 2.4) In cases where you would like to select random rows from those being returned, indicate the number of rows to be returned using “random”.
[cfdb-table form="myform" random="1"](return 1 random row)
[cfdb-table form="myform" random="2" search="Michael"](return two random rows that met the search criteria)
Sorting by One or More Columns with “orderby”
[cfdb-table form="myform" orderby="lastname"](Sort by lastname column)
[cfdb-table form="myform" orderby="lastname,firstname"](Sort by lastname and for those with the same lastname, sort by firstname)
[cfdb-table form="myform" orderby="lastname desc"](Sort by lastname column in descending (reverse) order. That is, the “Z’s” come first)
[cfdb-table form="myform" orderby="lastname desc,firstname desc"](Reverse-sort by lastname and for those with the same lastname, reverse-sort by firstname)
You can use “asc” for ascending sort or “desc” for descending sort. But “asc” is assumed if not specified.
Choosing which Rows to Display with “search”
The search field acts like the dynamic Search field that appears on the DataTable. It selects rows where any cell contains the search text (case in-sensitive).
[cfdb-table form="your-form" search="Washington"](show only rows where any field contains “Washington” in any case, so “washington” also matches)
Choosing which Rows to Display with “filter”
Filter provides a much more specific and complex way to specify rows to show. Unlike “search”, “filter” specifies searches on specific columns.
[cfdb-table form="your-form" filter="field1=value1"](show only rows where field1=value1)[cfdb-table form="your-form" filter="field1=null"](SPECIAL CASE: ‘null’ is interpreted as null-value (field does has no value)[cfdb-table form="your-form" filter="field1!=value1"](show only rows where field1!=value1)[cfdb-table form="your-form" filter="field1=value1&&field2!=value2"](Logical AND the filters using ‘&&’)[cfdb-table form="your-form" filter="field1=value1||field2!=value2"](Logical OR the filters using ‘||’)[cfdb-table form="your-form" filter="field1=value1&&field2!=value2||field3=value3&&field4=value4"](Mixed &&, ||. Standard Boolean operator precedence applies (ANDs are evaluated, then ORs)[cfdb-table form="your-form" filter="field1~~/^a/"](Regular expression; shows rows where field1 starts with ‘a’)
Filtering Rows: Supported Filter Operators
=and==are the same!=,<>are the same>,<,<=,>====and!==~~for regular expressions- [in], [!in] for “in list” such as:
filter"=lastname[in]Simpson,Smith,Jones"
Filtering Rows: Filter by Regular Expressions
- Use the
~~operator, and Perl-style delimiters around the pattern, such as/ [cfdb-table form="your-form" filter="field1~~/^a/"](shows rows where field1 starts with ‘a’)[cfdb-table form="your-form" filter="field1~~/.*@gmail.com/i"](shows rows where field1 is a Gmail address, case-insensitive)- FYI: uses preg_match to evaluate the regex
Filtering Rows: How to make “filter” Work Like “search”
Given “search” example:
[cfdb-table form="your-form" search="Washington"](Searches ALL fields)
When using “filter” use regular expressions with case-insensitive option (“i”), listing all fields.
[cfdb-table form="your-form" filter="field1~~/.*washington.*/i||field2~~/.*washington.*/i"](searches field1 and field2. You have to put a regex search for all the fields you want to search when using “filter”, strung together with logical ORs “||” )
Filtering Rows: Filter Limitations
- Does not support parentheses to control the order of boolean evaluation
Filtering based on Relative Time Using submit_time
For the “submit_time” field only, you can use special time values like:
[cfdb-table form="your-form" filter="submit_time>last week"](shows all submissions since last week)
Filtering Rows: Variable Substitution
Advanced options are discussed in Filter Variable Substitution.
Hi there
I got question there
i want to display all the database to the admin
and only display the database the user submited
I dont know how to achieve in shortcodes or write in the php
thanks
See documentation on this page
Hi Michael,
I have a similar question to the above. Is it possible to use the shortcodes to filter database records to display only certain ones based on the wordpress user viewing the results? For example, User Joe is only allowed to see records in which field1=X, while user Jane is only allowed to see records in which field1=Y, etc.?
Refer to filter variable substitution page
i have an error:
Error: no form is chosen
the plugin does not know my forms
The plugin only becomes aware of a form after the first time someone posts to it and the plugin captures it. The plugin is not aware of form definitions.
Trying to see if I can get a “running total” from a “donations” so I can post a “Donated this far $$$” Where the $ amount is auto-updated each times someone submits a donation/pledge.
Thanks for any help.
Jeremy
@Jeremy
Try something like [cfdb-value function="sum" form="donations" show="amount"]
Michael,
First off, great work! Keep it up!!! I have a question…..the plugin works perfectly, no issues with that, but is there any way that i could eliminate, somehow, the duplicate records?
I will make it clear……I wanted to verify if the user exists in the database before inserting new record (based on the email of course). Is there any easy way to do it……By the way i am no good at PHP :(.
Thanks in advance.
Cheers!
Sam.
No, there isn’t anything like this. I did some thinking about this sort of thing a while back where I wanted to be able to hook into Contact Form 7 validation and provide a way to validate against previously submitted data but I was waiting for them to add in a hook to validate all the fields of the form together (not just individual ones). I’ll put it on my list to look at this again for upcoming releases.
Hello
I want to know if there is a way to embed in the mail an image or a download link with all the captured data
Thanks
curdaneta
This plugin does not do anything with mail. Refer to the Contact Form 7 or Fast Secure Contact Form plugin (which one you are using).
hi,
the “&&” character using with filter doesn’t work. || (or condiction is Ok).
please can you help me?
Wp ver 3.2.1
Plugin Contact Form 7 2.4.6
Contact Form to DB Extension 2.0.1
TX
If you look at your post in the WP editor in HTML mode, do you see “&&” or && or a character code? If the latter, change it to the actual ampersand characters and save while in HTML mode in the editor.
Hi, great work can’t wait to get my hands dirty on this.. but what are the security aspects using this? Doed this mean an open window for code injection into MySQL..?
Best regards.
/S
No open window to MySQL. The shortcode options are put into prepared statements to avoid SQL injection vulnerabilities. The shortcodes are executed in PHP on the server and the data is generated into the page. It’s not like the page loads and does an Ajax call to get data where such a call could be hacked.
Anyone who can edit pages can put in a shortcode, so could potentially display any information. There is a setting for who can see the shortcode-generated data. By default it is “anyone” but if raise is above “author” for example, even an author putting a shortcode on a page cannot get the shortcode to generate data.
I have a contact form with two drop down menus for a date value ([month][year])
Could you tell me how I would go about modifying this code so it verifies that the input date is not in the past?
Is there maybe other type of inputs that I could use?
Thank you,
Any help will be greatly appreciated
Felipe
Input validation is handled by the form plugin (Contact Form 7 or Fast Secure Contact Form) not but this plugin (which saves data to the DB post-validation).
Fist, thank you for the great plug in!
Also, i have a question (sorry, i’m not a php programmer, but i can understand basic stuff)
How can i display data to all visitors? Not only registered users to admin? I’m using the [cfdb-html] shortcode, but i only can see the data when i’m logged.
Excuse me, i haven’t see the options page before. Forget my question. Great Plugin.
Yes, go to the Database Options page, set “Can See Submission when using shortcodes” to “Anyone”
Hi Michael,
Thanks for all your previous help. I just realized that the URL for uploaded files (both if browsing the database in the plugin pages and when using the short codes) requires admin login. I’d like to use the URL for the uploaded files directly within my WP pages/posts so I don’t have to upload them separately in the media section. Is this possible? Here is an example URL:
http://www.debug.arundelknights.org/wp-admin/admin-ajax.php?action=cfdb-file&s=1317540700.9519&form=News+and+Events+Submission+Form&field=UploadSupportingPDF
Thanks,
Dana
@Dana Caulder
This is protected by the Database Options setting “Can See Submission when using shortcodes”.
Set that to “Anyone” and it should work without being logged in.
@Michael Simpson
Thanks, found it!
i would like to use the shortcode to display only the uploaded images in form – using the simple [cfdb-table form="myform" show="field1,field2,field3"] (optionally show selected fields) which the fields show up but no image and no image link… If anyone knows a solution please email me – I will pay and donate yet again for the info!!! Awesome plugin…. I’d alos like to be able to control css on page and have images simply show up on page like a gallery…
Try using cfdb-html with the filelinks option.
I need help. I want to showing sum of all the points that have same troop no.
Please see the link http://babysafecarpet.com/wordpress/please-entry-your-points/
Check out this post
I’ve dropped shortcode in a sidebar widget to show upcoming events. Would like to order them in ascending order (nearest in time first). Shortcode I’ve used:
[cfdb-html form="Submit SEVA Event" orderby="ex_field16 desc" limit="5"]
The default is supposed to be ascending, but that doesn’t work. I tried specifying ‘asc’ and ‘desc’ but nothing changed. How can I fix this? Thanks!!
Hello there!
I thank you for the time and effort you have devoted into making this!
I want to organize the results of the form. Is there a way to show the page number?
My idea is to use the tabel limit and divide them into sections of 20 results (so 0,20, 20,20 etc). But in order to make everything be more clearer I would like to have the row numbers present also, so that once a block is checked I can mark down 0-19 is checked instead of just “first block is checked.”
So question is short – can I make the row number show?
Awaiting for your reply.
Best regards,
Raimo
Unfortunately the short codes no not provide a row number you can display. To do this, you would need to create your own shortcode and set up a counter variable.
feature request: random orderby for the shortcode display, i have to use jquery to randomize the list right now
How can i put a something like a search bar whereby a field in the form will be input and all other fields will just appear
Please i need a shortcode that will put a search bar on my page whereby users will be able to search for a specific name and every thing will just appear.
@Bhadem
Try taking a look at data tables here: http://datatables.net/release-datatables/examples/basic_init/themes.html
It’s a JQuery plugin which will take what has been spit out and make a grid of data / add paging and an ajax search bar. no mess with default filtering.
I’ve said it before, but amazing plugin Michael. This was definitely an essential tool missing in wp until you came along, thank you very much.
I’m having trouble with the shortcodes. Is there a simple way to produce a shortcode which only shows data from the previous day?
Thanks.
example: [cfdb-table form=”Contact form” filter=”submit_time>yesterday”]
Hi, thanks for your plugin.
Is it possible to set the table field titles within the shortcode?
I know that i can set them inside the Contact form settings, but unfortunately i found your plugin today and i have already many forms.
Thanks anyway!!!
Great job
Not right now. I plan to put in something to allow you to set a column’s display name (like should “first_name” as “First Name”) but I haven’t done that yet. Your only recourse right now is to rename the fields in the database. You can do this with my editor extension by just renaming a column. But you have to pay for that. Otherwise you can execute SQL such as
update wp_cf7dbplugin_submits set field_name = 'your-new-field-name' where field_name = 'your-old-field-name' and form_name = 'your-form-name'Hi , i need to check phone number and email duplicacy check in contact form 7 db extension , but i have not found it any where , i want to know that it is possible or not , or have to code in plugin. , any help will be appreciated. Thanks in advanced.
Currently no validations are done by this plugin before entering it into the db. Also, no specific support in export or short codes for querying for duplicates.
Hi There,
I am looking to integrate this form with a directory plugin. I would like to create a job listing page with the “apply now” link for each listing opening the form on click. Is there a way to make the form automatically grab the id of the job so that the receiving end knows which job is being applied for?
I would be grateful for your feedback,
Thanks,
Filip
Not clear: are the jobs in the DB managed by this plugin and you are going to use a short code to pull out job listings and create an apply now form? Or are the job listings coming from somewhere else? And how are you creating that apply form, via a plugin like CF7 or writing your own HTML?
Hi,
Lovely plugin – I have a problem with inplementering of a regular expression. When I use”]”. My expression working fint inside the short code editor but goes wrong when I put the short code into a page.
here is my short code
[cfdb-count form=”Tilmelding” filter=”fdato~~/-1995?[5-9]/||fdato~~/-2000?[0-3]/”]
I attempt to insert the short code in the HTML view without result
Any help will be appreciated for my further work.
Thanks in advanced.
Sounds like WordPress is not properly parsing the tag. I haven’t tried it, but if you put in “]]” instead of “]” it may escape the character. Let me know if that works.
Great plugin- but I have one problem: I’m using this shortcode [cfdb-value form="Endorse" show="/.*name/" orderby="lastname desc"] to show people’s names but there is a coma between the first and last name. how do I eliminate it?
try: [cfdb-value form="Endorse" show="/.*name/" orderby="lastname desc" delimiter=" "]
Hi i want know how i can set username and password field in this plugin and i want if a user registred then first i approve the user after that he registred so plz tell me how i do this
This plugin does not do anything with WordPress user registration.
Is there a way to generate a barcode after a form has been submitted?
The barcode should be included automatically in the database and should be mailed to who filled out the form.
There is no direct support for bar code generation. I don’t know how to generate a bar code. But let me assume there is some code or plugin that you could use to do this. You might then use the filter hook that this short code provides. Instead of injecting a new date field like the example on that page describes, you would somehow generate a bar code and add it to the submission data which would then be saved to the DB.
However that does not address mailing it. You might need to call wp_mail to send mail directly from the filter function that you write.
Hi;
First of all, Thank you very much for this great plugin!
I have created a form with contact form 7, then I am using your plugin to export data /display data, however, I noticed that there is no way to prevent duplicate entries. For example following is the result from my table:
code status
————–
1234 Returned
4546 Returned
1234 Returned
1234 Returned
1234 Returned
I hope the data can be displayed as:
code status
————–
1234 Returned
4546 Returned
How should I do? I will greatly appreciate if you can give me some hints. Thank you!
stcc
There is currently no easy way to do that. You would have to write your own short code to eliminate duplicates.
Hi Michael:
Thank you very much for your reply. I searched on wordpress website, and found the question/answer here:
http://wordpress.org/support/topic/plugin-fast-secure-contact-form-check-email-field-in-the-db-for-error-using-cf-to-db-ext?replies=7#post-3054285
I am wondering where I should put the code Daniele wrote: do I put them in the function.php? how should I call/use it in the post/page? or I should put them in the “short-code php” sections (found in the admin page)?
I will appreciate if you can give me some help. Thank you!
is it possible to edit the entries from the frontend (not from database directly) of the page so that my users can directly update few fields…
No, you can only edit entries from the administration page.
Can I create auto-approved posts with the database filled in contact form 7? Eg. the visitor fill the form without registration/login and the data of the form become the title and description of the post and that post become live and approved- All automatically?
Reply – Thank You
You can do this with a similar plugin I wrote. See Form to Post
Hello, quick question. I love your plugin it has made my life so much easier, however I am wondering how to go about using information from the DB to populate my CF7 form. I have read various posts on this already and all require you to change code in the backend. Is their a way to do it without altering any code?
There is no easy way to do this that I know. I have tried seeing if I can wrap a CF7 form short code inside a cfdb-html short code, putting in ${variable} values as defaults in the CF7 definition but that doesn’t work.
Is there a way to input conditional somewhere within this shortcode to only pull the database records for a particular user. So for instance, when someone goes to their My Systems page, after they’ve submitted a new system, and this is captured on this form, how do I ensure that it is filtered universally at the user id level?
So, in other words, I only want users to see their own form submission data. Regardless of what permission level they are at. What would be the best way to skin this cat?
[cfdb-table form="My Systems" role="Anyone" permissionmsg="false" filter="Submitted User ID="(I WOULD LIKE TO BE ADD PHP CODE HERE TO DYNAMICALLY PLACE THE CURRENT WORDPRESS USER ID"]
See this post: http://cfdbplugin.com/?page_id=116
Hey Michael,
Love the plugin! I have 2 questions:
1. Is it possible to have a submission show up in a different color if a certain option in CF7 is checked? For instance, I want to add a checkbox on my form that says “Are you paying by check?” and have a Yes/No option. If they click “Yes” I would still like them to show up in the submissions but I would like them to be in a different color than the other submissions. Possible?
2. I am using your shortcodes in WP Table Reloaded and I notice that they don’t automatically update with latest/newest submissions. To get new submissions to show up, I have to remove the shortcode and put it in again. What could be the reason for this?
Thanks! 🙂
1. I think you would need to create a custom short code to accomplish that.
2. Unfortunately I don’t really know anything about WP Table Reloaded so I can’t answer intelligently.
Hello
Great plug in thanks so much.
I have few issues i wonder if you could help me with.
1. I want to give the values in a drop menu different hidden revenue values. i.e if someone select gatwick the hidden value is £70 and if they select heathrow the hidden value is £80. Can i achieve this?
(see this example: http://cheap-airport-taxis.com/contact-form-address/ )
2. Is there a way to Auto-generate a new Booking ID every time a form is completed?
3. Is there a time picker extension for this plug in as there is a date picker calendar extension?
1. This is something you would need to accomplish in the form definition and not this plugin. A form input tag can have a display value and actual value. The latter is saved. For example if you have a drop downlist, you have a SELECT tag nested OPTION tags likewhere the user sees Gatwick and 70 gets saved to the DB. You either write this HTML directly or you have to figure out how to do it using whatever form plugin you use.
2. Note that each entry has a unique “submit_time” field. In the admin page this gets displayed as “Submitted” in the admin page and is formatted as a time. But in the DB it is saved as a value like 1342034011.0136 which is unique per form submission. You can add show=”submit_time” to a short code to display that value. Consider using that as your ID. If you actually want to generate your own value, then you would need to following this example to add another field (requires some coding).
3. That is a question for the plugin for generating/displaying the form itself, not this plugin.
Michael, first….great plugin! I keep finding new and wondrous things in it each day, but I have no idea how to implement them… very frustrating but endlessly entertaining!
My site feeds data to the database from several different forms. What I am trying to do is extract some of the data by querying whether a certain field has any data in it and if so extract the whole row.
I see above: [cfdb-table form="your-form" filter="field1!=value1"] (show only rows where field1!=value1) – Is this where I should be concentrating? If so what “value1” equals data in the field and conversely what “value1” equals no data in the field? Can it be black or white like that or does it need a specific word or number as “value1” to search for?
If need be I could add a different default textfield to each form which would have a “value1” for it to search for, would that work?
Thank you very much in advance for your reply.
I replied on the WP forum to your post there.
@James
hello mike im new to this plug in so thanks for getting back.
here’s my comments back
1. This is something you would need to accomplish in the form definition and not this plugin. A form input tag can have a display value and actual value. The latter is saved. For example if you have a drop downlist, you have a SELECT tag nested OPTION tags like
where the user sees Gatwick and 70 gets saved to the DB. You either write this HTML directly or you have to figure out how to do it using whatever form plugin you use.
— I am using the contact form 7 plug in to generate the form so do you know if I can achieve this just using the standard options in this plugin?
2. Note that each entry has a unique “submit_time” field. In the admin page this gets displayed as “Submitted” in the admin page and is formatted as a time. But in the DB it is saved as a value like 1342034011.0136 which is unique per form submission. You can add show=”submit_time” to a short code to display that value. Consider using that as your ID. If you actually want to generate your own value, then you would need to following this example to add another field (requires some coding).
— great this sounds good i’ll try it. do you know why all the examples refer to “my form” (like the below)
[cfdb-value form="myform" show="col1,col2"]
where as my short code that is generated has an id and title? this is confusing me. would my code look like the below based on your suggestion?
[contact-form-7 id="2872" title="database-test" show="submit_time" ]
3. That is a question for the plugin for generating/displaying the form itself, not this plugin.
Yeah can’t believe there there’s no time picker extension for contact form 7
Hi,
I got the shortcodes to display results in posts and even in Contact Form 7 forms themselves by following http://wordpress.stackexchange.com/questions/45266/how-to-use-other-shortcodes-inside-contact-form-7-forms.
But they don’t work in the mails that are being send after submission.
Any solutions to that?
Thnx a lot…
Any follow on that?
Really need to do this for a contest.
No progress on this. You would have to write PHP, to write a filter and it that query for the data.
Any way to get it to automatically send (email) a CSV export file daily with the results from the past 24 hours?
No. On the short code builder page, you could create an export link with a filter like “submit_time>yesterday” or “submit_time>-24hours” (reference) so that it always exports a CSV file with the latest results. But getting that to email you is not supported by the plugin.
sorry for the stupidness, but i don’t understand the directions for changing the table’s header row names. My Fast Secure Contact Form calls the fields something like “ex_field1” and I need a more descriptive field name, like “Job Number”. I tried using the the short code, which displays the table beautifully, except I don’t understand how to effectively follow the instructions for changing the ID names (at least that’s what I think should work). Any help would be appreciated. You ROCK. This plugin is super. Thanks for all your wonderful work.
@Sallie
cfdb-table and cfdb-datatable don’t have options to rename the column names at present.
Hi Michael,
I have very simple question. I don’t want to show the whole data-table to the user except the search field. If any one put any query (e.g. telephone number, name etc.) it will shows only that row of the table.
Hi Michael,
Can I set up an automated export, either daily or hourly for example?
Alternativly, how can I connect to our database remotly (eg, Microsoft SQL Server SSIS package running daily). A valid connection string is what I’m looking for.
What we are trying to do is import the contact information into our existing CRM solution.
In the admin area, the Short Code builder page allows you to create export links. Another application could use the URL you create to access the data (required it to login). Regarding do that in an automated way, you will have to set up something to access the URL on a schedule. On Linux you can use “cron” for example.
Hi Michael,
Is there a way to filter based on whether a value exists in a column? Essentially it would be the opposite of [cfdb-table form="your-form" filter="field1=null"] but unfortunately I can’t just use [cfdb-table form="your-form" filter="field1=value1"] because the value will be different from submission to submission. However I would like to see if I can show all rows where a value exists (any value) within a particular column.
Thanks for your support!
Use “!=”, i.e. filter=”field1!=null”
Perfect! Thank you!@Michael Simpson
Michael -Thank You Very Much For Your Great Plugin..xcllent work
I hav One Question…I don Know Whether is It Possible Or not
i installed ur plugin & data base plugin too
as your plugin hav dababase acces..is it possible to post users sent data through Fs Contact Form On My WordPress Site Like A admin Posts?
if it does ..will it automatically publishes users submited data as post??
In Settings I could See Only Export Option.. I didn see Publish option?
Im a Neebie For WordPress…
This plugin saves form submissions in the database but does not make them into posts. Use the form-to-post plugin to do that. It will publish posts by default, or you can set the “post_status” to change that.
How do you hide columns that are null. Filter does not work on columns. I want to hide any column starting with the word pull that has no value. I’ve tried hide=”/pull.*/=null” but it doesn’t work.
“filter” works on rows, “hide” works on columns. Each is independent. You can’t combine “filter” and “hide” to hide columns that have empty row values.
have to show data with CF-DB, i want to show data after approved by admin on my site.
Please any soon…
I think you are asking how to show only the data that has been approved by an administrator. If you purchase the CFDB Editor Plugin, you can create a new column associated with your form data. You might name the column “Approved”. Then set the value of “Approved” to “yes” on the rows you wish to have displayed. Finally, in a short code filter on “Approved”. For example:
[cfdb-table form="form-name" filter="Approved=yes"]Hey Michael,
Quick question, I have a page to show the database of people that have submitted form. But it doesn’t populate unless I’m logged in as admin. Is there a way to make it populate without having to be logged in as long as they can access the page? I’m not sure if this is a role or security short code I’m doing wrong.
In Contact Form DB -> Options, you probably need to change “Can See Submission data” to something less than “Administrator”
I am using the order by clause on a numeric field by the information is not ordering as I expect, for instance 100 is appearing before 70 – so i get results such as:
109
117
401
51
58
99
It appears to be ordering using alpha convention. Is there anyway to treat the column as numeric
Hey Michael,
I have a similar problem as Mike, Is there a way to orderby ASC Or DESC if the field is numeric. I then change my field to text and still the number do not orderby correctly. Is this a bug. This is a fantastic plugin and very use to desplay data on a page. Please advice
Many thanks
Jacob
Unfortunately, the plugin sorts everything treating it as text. On my to-do list to make it sort numbers and dates.
Hi Michael,
Thank you for your response, I know you are busy man. I change the field to text but it still did not sort as DESC order. Also Is there a way to trim or center the fields on the columns? I tried using trim() for leading spaces but it did not work. Color for the labels is something I wanted to do but no idea how to do it.
Many Thanks
Jacob
should work: orderby=”field-name desc”
PS. If you want to write PHP to sort the data how you like then you can create your own short code: http://cfdbplugin.com/?page_id=444
To center the fields in the columns, apply CSS to the table. You can do this with the “style” attribute on the short code: http://cfdbplugin.com/?page_id=93#style