How to exclude/ignore certain fields in the export (CSV)

answered on other thread

thanks Michael.

Just wondered if possible to ignore certain fields from ‘Export’ option on this page:
/wp-admin/admin.php?page=CF7DBPluginSubmissions

No, do custom exports from the short code builder page.

Hello, we currently have several different contact forms that are hooked into Contact Form DB. These forms have different data to be displayed when exported to an excel file. I’m having difficulty differentiating the short code options between the different contact forms. How do you save the individual short code options for the individual contact forms? I don’t really see a button to save the options. I think I accidentally hit the reset button thinking I was resetting the options to an individual contact form reset the options for ALL forms instead.

How do you differentiate and save short code options for the different contact forms so I can display certain columns from different contact forms when exported?

I hope this question is clear. Thanks!

The short code builder does not save anything. It helps you write a short code then you put that on a post. It’s “saved” in the post.

To differentiate different forms, when you select a form in the short code builder page, it will change options and drop downs to include the field names of that form’s submitted data (there needs to be at least one form submission in the DB)

Thanks Michael. I’m starting to understand now. So I paste the new shortcode into the page where the contact form code is stored:
[contact-form-7 id=”6″ title=”Contact Us”]?

How do I combine the two bits of code?
this is the DB shortcode: [cfdb-table form=”Service Contact Form”]

This is the contact form short code: [contact-form-7 id=”15190″ title=”Service Contact Form”]

Is there a way to combine those together or am I way off base here?

Also, what is html, table, database, etc, short code? Is there a tutorial that explains what each of these does?

Thanks for your help Michael!

I figured out how to customize the columns when exporting the contact form to an excel file.

Is there a way to add a text box to a drop down field?

For instance, I am using the following code for a dropdown menu: <p>enter text here
[select xxxxxx_xxxx include_blank “xxxxxxx” “xxxxxx” “xxxx”]

And the following code for a text box:
<p>xxxxxxxxx: *
[text* xxxx]</p>

Is there a way to combine these the user can type in their own text if their desired choice isn’t in the drop down?

I’m sorry if there is already a theme regarding this post. Thanks

You won’t combine CF7 and CFDB short codes. Put a CF7 short code on a page to show your form. All submissions will be automatically collected by CFDB. You can look at those submissions in the CFDB admin panel. If you wish to display submission data on a post/page, then use a CFDB short code.

For questions on CF7 form definition, please refer to the CF7 support forum.