andywt
Forum Replies Created
-
Forum: Plugins
In reply to: [Contact Form DB] Adding Custom URL using cfdb-export-linkAny suggestions?
Forum: Plugins
In reply to: [Contact Form DB] Fields with Conditional Logic Not CapturedMichael, 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
In reply to: [Contact Form DB] Fields with Conditional Logic Not CapturedMichael,
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
In reply to: [Contact Form DB] Custom Short Code "show="That did the trick. Thanks!!
Forum: Plugins
In reply to: [Contact Form DB] Custom Short Code "show="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
In reply to: [Contact Form DB] Filter issues with cfdb-export-linkVictory!! That was it. Thanks much.
Forum: Plugins
In reply to: [Contact Form DB] Filter issues with cfdb-export-linkYes.
Forum: Plugins
In reply to: [Contact Form DB] Filter issues with cfdb-export-linkMichael,
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
In reply to: [Contact Form DB] Transform functionMichael,
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 DumpI know the filter works as I use it to produce other reports.
Forum: Plugins
In reply to: [Contact Form DB] Transform functionSorry Mike. Tried that and the FagLeasePrice goes to “”.
Here is the printout without the transform:Here is the shortcode with the transform and the printout:
[cfdb-datatable form="Flag Database" trans="FlagLease=str_replace($,,FlagLeasePrice)" show="FlagLease"]
transform printoiutForum: Plugins
In reply to: [Contact Form DB] Transform functionI changed the shortcode to `[cfdb-value form=”Flag Database” trans=”FlagLeasePrice=str_replace(“$”,””,FlagLeasePrice)” show=”FlagLeasePrice”]’
and FlagLeasePrice continue to show the $.Forum: Plugins
In reply to: [Contact Form DB] &&NaturalSortByField not workingMy 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
In reply to: [Contact Form DB] &&NaturalSortByField not workingMichael,
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
Forum: Plugins
In reply to: [Contact Form DB] Report Title based on URL VariableMichael,
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 theecho $_REQUEST['parameter'], how do I import that functionality in my new shortcode?Forum: Plugins
In reply to: [Contact Form DB] Re-importing CFDB and preserving Submitted fieldMike, 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.
