Forums

I have a CF5 submission form that is storing data from visitors. We would like to be able to do 2 things - first we want to filter the rows by date range. We would want an upper and lower bound so we can select submissions by week or month. Second, we want to export the results to a CSV. Can this be done with CC5 or do we need to write a custom extension for this?

Hi BNRBranding,

You can use CCv5 or a DB Loader in CFV5 to do this. Please see this FAQ for examples of building WHERE clauses.

There's a built in CSV EXport action in CFv5 and I'm just in the final stages of porting my custom version which has a few more features from CFv4 to CFv5. All things being equal I should have that done tomorrow.

Bob

We tried the built in export function, but that seems to only export all of the records without any regard to the check boxes selected or any method of filtering. If your version will offer more features I can certainly wait a day to see if your code will work for us.