Multiple forms submit to one database

Dear Mr. Simpson

Thank you for your answer.

I am afriad that I don’t understand what you said exactly at below sentence.
I used ‘Contact Form 7 Multi-Step Forms’ plugin, so you mean that
CFDB doesn’t consider ‘Contact Form 7 Multi-Step Forms’?

CFDB was not coded without taking into account
‘Contact Form 7 Multi-Step Forms’ plugin.

Sorry about the sloppy english. I meant to write that CFDB was not coded with ‘Contact Form 7 Multi-Step Forms’ plugin in mind. So there is no special code to deal with this kind of situation.

Moving this post forward in case you missed it. Thank you.

Michael,

I lied. I have one more question.

Let’s say I have three databases and one combined database consisting of data from the three.

I am looking at the combined database and I see and entry and I need to know which of the three forms that entry comes from. How do I create a column that shows which contact form the entry came from, ie. which of the three databases the entry on the combined database comes from.

Thank you,
Will

@willbell

In your change_title function, before you change the value of $formData->title, add a line like

$formData->posted_data['From Form'] = $formData->title;

Michael,
Bingo again. And now that my and Lim’s seems resolved, I will mark this as resolved. Thank you very much.
Will

Thank you very much, Michael Simpson
I really appreciate your kind response.
Your advise really helped me.
Is there a method to support your activity?
I want to donate some ,even though not much, to you or your company.

myemail [email protected]

Sorry I couldn’t help you more. If you wish to donate, got to https://cfdbplugin.com/ and click the Donate button on the right.

Thank you.

I know, I just thank you for your acheivement.
I will use this plugin very useful.
I donate some for your company.
I wish it help for your company.
and if you are possible, please you consider to add combinding funciton for Contact Form 7 Multi-Step Forms’ plugin
It will be really helpful for multi-step form data management.

Have good day!!

Hi Michael,

I am using your code and it is working great to consolidate all of my contact forms. Thanks for that!

Right now, the code makes it so that form entries are only stored in the consolidated database. I was wondering if there is a line of code that I can add to the current code to make it keep the entry in the original form database in addition to creating a duplicate entry in the consolidated database. Is this possible?

Thank you.

Have a look at Changing Data Before it is Saved. You could use that hook to place code to save the information elsewhere instead of modifying it.

Thank you for the response Michael. I’m a php novice and am not sure which part of my code is removing it from the original database.

if ($formData && in_array($formData->title, $myForms)) {
       $formData->posted_data['From Form'] = $formData->title; $formData->center['Center'] = $formData->title; $formData->title = $myUnifiedForm;
    }
    return $formData;

Above is currently what I have and I can see it is changing the title, but I’m not sure what the alternative would be to keep the original title and move a copy of the data to the consolidated database.

When you say database what do you mean:
1. The MySQL database
2. The table in the database that holds all of the form submission data
3. The data associated with a specific form name
4. other?

#3, the contact form database with all of the form submission data for a specific form. So what I would like is to have the contact form submission placed into its correct form name database($myForms) while at the same time duplicating that data into my consolidated database($myUnifiedForm) with all of my other forms’ data. Currently the code takes the form submission data and places it in the consolidated form, bypassing the original form database completely.

There is no simple way to make a form submission into two. Would it make sense to keep your forms with their individual titles, but sometimes display a consolidated view of several forms together? This can be done by indication multiple forms in a short code. For example [cfdb-table form="form1,form2,form3"]