Title: andywt's Replies | WordPress.org --- # andywt [ ](https://wordpress.org/support/users/andywt/) * [Profile](https://wordpress.org/support/users/andywt/) * [Topics Started](https://wordpress.org/support/users/andywt/topics/) * [Replies Created](https://wordpress.org/support/users/andywt/replies/) * [Reviews Written](https://wordpress.org/support/users/andywt/reviews/) * [Topics Replied To](https://wordpress.org/support/users/andywt/replied-to/) * [Engagements](https://wordpress.org/support/users/andywt/engagements/) * [Favorites](https://wordpress.org/support/users/andywt/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 36 total) 1 [2](https://wordpress.org/support/users/andywt/replies/page/2/?output_format=md) [3](https://wordpress.org/support/users/andywt/replies/page/3/?output_format=md) [→](https://wordpress.org/support/users/andywt/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] Adding Custom URL using cfdb-export-link](https://wordpress.org/support/topic/adding-custom-url-using-cfdb-export-link/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [8 years, 9 months ago](https://wordpress.org/support/topic/adding-custom-url-using-cfdb-export-link/#post-9442584) * Any suggestions? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] Fields with Conditional Logic Not Captured](https://wordpress.org/support/topic/fields-with-conditional-logic-not-captured/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [9 years, 4 months ago](https://wordpress.org/support/topic/fields-with-conditional-logic-not-captured/#post-8738775) * Michael, I have found the issue. As I was perusing the CFDBIntegrationGravityForms. php module, I stumbled on a comment “// Assumption: all inputs have diff labels”. Bingo! that was the issue. I was repeating the fields and was using the same field name. I changed the name and everything is working fine! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] Fields with Conditional Logic Not Captured](https://wordpress.org/support/topic/fields-with-conditional-logic-not-captured/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [9 years, 4 months ago](https://wordpress.org/support/topic/fields-with-conditional-logic-not-captured/#post-8738435) * Michael, I have turned on the Debug logs of the form and entries and can send them to you if that would be of help. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] Custom Short Code "show="](https://wordpress.org/support/topic/custom-short-code-show/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [10 years, 1 month ago](https://wordpress.org/support/topic/custom-short-code-show/#post-7308384) * That did the trick. Thanks!! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] Custom Short Code "show="](https://wordpress.org/support/topic/custom-short-code-show/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [10 years, 1 month ago](https://wordpress.org/support/topic/custom-short-code-show/#post-7308363) * Thanks Mike. Is there a trick to the transform returning a hyperlink? I am returning the proper HTLM string for the link but it just displays as a string of text. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] Filter issues with cfdb-export-link](https://wordpress.org/support/topic/filter-issues-with-cfdb-export-link/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [10 years, 3 months ago](https://wordpress.org/support/topic/filter-issues-with-cfdb-export-link/#post-7172067) * Victory!! That was it. Thanks much. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] Filter issues with cfdb-export-link](https://wordpress.org/support/topic/filter-issues-with-cfdb-export-link/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [10 years, 3 months ago](https://wordpress.org/support/topic/filter-issues-with-cfdb-export-link/#post-7172063) * Yes. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] Filter issues with cfdb-export-link](https://wordpress.org/support/topic/filter-issues-with-cfdb-export-link/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [10 years, 3 months ago](https://wordpress.org/support/topic/filter-issues-with-cfdb-export-link/#post-7172051) * Michael, Sorry I posted the wrong second short code. To create the the export shortcode, I copied the datatable in total and changed cfdb-datable to cfdb-export- table. My new code did have edit and it did have the space before Renew_status as that worked fine with the datatable. I removed the edit and the extra space and this is the shortcode: `[cfdb-export-link form="2015 Flag Database" show=" FirstName,LastName,Email,HouseNumber,Street,UniqueID,Renew_status" trans="NaturalSortByMultiField( $_GET(sortBy1),$_GET(sortBy2),$_GET(sortBy3),$_GET(sortBy4),$_GET(sortBy5))" filter="has_valid_email()&&Route>=$_GET(routeS)&&Route<=$_GET(routeE)&&Renew_status! =Renewed&&Renew_status!=Removed" ]` * This does not return any values in the CSV file. If I remove “has_valid_email()” from the filter results are returned. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] Transform function](https://wordpress.org/support/topic/transform-function/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [10 years, 3 months ago](https://wordpress.org/support/topic/transform-function/#post-7152550) * Michael, The parsing issue is fixed but there seems to be another issue. I am using the cfdb-value to produce some stats about the database. I was using: * ``` [cfdb-value form="Flag Database" filter="payment_status=Paid" function="count" show="payment_status"] ``` * To count the number of records that are marked Paid. It produces a number but it doesn’t reconcile to what I compute using an Excel dump of the file. What I found was the filter does not work. I tried search and got the same result. I then change the shortcode to cfdb-datable with all the rest the same and the results show that the filter is not working. Here is a dump of the output: [Filter Debug Dump](https://www.dropbox.com/s/ubxo7k6pkv9wf0e/filterdebug.png?dl=0) * I know the filter works as I use it to produce other reports. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] Transform function](https://wordpress.org/support/topic/transform-function/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [10 years, 3 months ago](https://wordpress.org/support/topic/transform-function/#post-7152454) * Sorry Mike. Tried that and the FagLeasePrice goes to “”. Here is the printout without the transform: * [no transform printout](https://www.dropbox.com/s/8kr5mwu7a39mgur/no%20transform.png?dl=0) * Here is the shortcode with the transform and the printout: `[cfdb-datatable form="Flag Database" trans="FlagLease=str_replace($,,FlagLeasePrice)" show="FlagLease"]` [transform printoiut](https://www.dropbox.com/s/8b4knbtm38gci2y/transform.png?dl=0) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] Transform function](https://wordpress.org/support/topic/transform-function/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [10 years, 3 months ago](https://wordpress.org/support/topic/transform-function/#post-7152444) * I changed the shortcode to `[cfdb-value form=”Flag Database” trans=”FlagLeasePrice =str_replace(“$”,””,FlagLeasePrice)” show=”FlagLeasePrice”]’ and FlagLeasePrice continue to show the $. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] &&NaturalSortByField not working](https://wordpress.org/support/topic/naturalsortbyfield-not-working/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [10 years, 3 months ago](https://wordpress.org/support/topic/naturalsortbyfield-not-working/#post-7143559) * My first example was the 3 field Multi that you suggested and it did work. The issue is I need 5 fields so was trying to get the ByField to work since I thought 3 was the max. * Good news 5 fields do work in the SortByMultiField. Thanks. * Does the code to pass variables work in the trans= field of the shortcode? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] &&NaturalSortByField not working](https://wordpress.org/support/topic/naturalsortbyfield-not-working/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [10 years, 3 months ago](https://wordpress.org/support/topic/naturalsortbyfield-not-working/#post-7143551) * Michael, I had tried that and it still produces strange results. It looks like only the last sort takes effeect. Here is my shortcode: `[cfdb-datatable form ="Flag Database" edit="$_GET(edit)" show="Submitted,FirstName,LastName,Phone, Email,HouseNumber,Street,Neighborhood,Flag Quantity,Route,Sub-route,Were you a customer last year" trans="NaturalSortByField(HouseNumber)&&NaturalSortByField( Street)&&NaturalSortByField(Neighborhood)" filter="Route>=$_GET(routeS)&&Route <=$_GET(routeE)&&payment_status=Paid" ]` * Here is the report snippet: [HouseNumberStreetNeighborhood](https://www.dropbox.com/s/tnl7zcl5nx6e9t4/NumberStreetNeighborhood%20Sort.png?dl=0) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] Report Title based on URL Variable](https://wordpress.org/support/topic/report-title-based-on-url-variable/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [10 years, 4 months ago](https://wordpress.org/support/topic/report-title-based-on-url-variable/#post-7048166) * Michael, Thanks for the suggestion. I have been playing around with this but am missing something. How do to tell the new short code which cfdb function you are extending. For example if i am trying to extend the cfdb-datatable shortcode to include the `echo $_REQUEST['parameter']` , how do I import that functionality in my new shortcode? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form DB] Re-importing CFDB and preserving Submitted field](https://wordpress.org/support/topic/re-importing-cfdb-and-preserving-submitted-field/) * Thread Starter [andywt](https://wordpress.org/support/users/andywt/) * (@andywt) * [10 years, 4 months ago](https://wordpress.org/support/topic/re-importing-cfdb-and-preserving-submitted-field/#post-7015877) * Mike, I found the export “backup” option, but when I opened the file in Excel to do my manipulations, the submitted field is not in the format you mentioned. It is like: 2015-12-21 13:49:02 -06:00. What format does CFDB use? Unix/epoch time formats do not have decimals. Viewing 15 replies - 1 through 15 (of 36 total) 1 [2](https://wordpress.org/support/users/andywt/replies/page/2/?output_format=md) [3](https://wordpress.org/support/users/andywt/replies/page/3/?output_format=md) [→](https://wordpress.org/support/users/andywt/replies/page/2/?output_format=md)