TOPIC:

Use Breezing form with Content Builder but save data to a separate table while 1 year 8 months ago #232391

  • Topic Author
  • 5uwebsite
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 126
  • Thanks: 2
Hi there,

Thank you for developing Breezing Forms and Content Builder. They are both really nice and powerful extensions for Joomla! so we want to use both of them for a CCK project.

If we use the "default" way to create a view with Breezing Form in Content Builder, then our data is NOT saved to a separate table. This is a problem when we have lots of data that needs to be filtered with.

If we create a data storage in Content Builder, we can save data to a separate table, that is perfect! However, we won't be able to use Breezing Form to collect data in this case.

I understand that I am not that only person asking for the "separate table". For example, I read this support post: crosstec.org/en/forums/3-breezingforms-f...e-for-each-form.html

but I don't think the very last reply help to store the data to a separate table. The way Breezing form storing records might make filtering, sorting and some other customization more difficult.

I had also read through many posts in the support forum, and realized that we can use the Integrator to store Breezing Form data to a separate table, but this is not designed to use with Content Builder, it was designed for Breezing Form only.

It seems that we are very close to the goal, but I still can't find the solution. You are the experts of both extensions and had provided support for many similar situations. Could you suggest a way that can take advantage of the great Breezing form features, while saving data to a separate table, so that we can use Content Builder to create a View for both displaying and editing the records?

For example, if we use integrator to save Breezing form records to a separate table, then can we use Content Builder's "...or choose an existing table" option to work with that table? If this is possible, then how can we make a view to let the owner of a record to edit his own records?

Thank you very much!

Please Log in or Create an account to join the conversation.

Use Breezing form with Content Builder but save data to a separate table while 1 year 8 months ago #232432

  • mihaela
  • Offline
  • Developer
  • Developer
  • Posts: 3128
  • Karma: 105
  • Thanks: 415
Hello,

Here is how you could use both BreezingForms and Contetnuilder.

You can create a BreezingForm form with a hidden input field named let's say "id" that will store user's id.
In order for it to save the user's ID, you have to go to Properties of that hidden input field.
Then in the Value field you have to put a code like this:
<?php $user = JFactory::getUser(); return "$user->id"; ?>

Then using the Integrator you have to create an UPDATE and INSERT to save records to separate database.
In the INSERT rule set Update Criteria - Joomla! to update the record in table in database in case "id" field in database equals "Userid".
NOTE: In table in database you need to have an id field which will be connected to "id" field from the form.

So

If you do everything as explained above you then form submissions will be properly saved and updated in the separate database table as you wanted.

What you could do next is you could create a Menu Item for that BreezingForms form and set Submission editable by user? to Yes. That way, when user enters the form the next time, he will see the data he had entered the previous time and he would be able to edit it.

If you want to use ContentBuilder (as you said) then don't create a Menu Item for a form. You can create a ContentBuilder View based on the form that you have created like this crosstec.org/en/support/online-documenta...rms-integration.html .

Furthermore, you can set permissions so that the user sees only his record and that only he can edit them. Since this view is created based on a form which is connected to database using Integrator, editing record in ContentBuilder will affect the database.

NOTE: In order for both of this solutions to work, user has to be logged in when filling in the form.

Let me know whether this helped and whether everything is clear to you.
If you have more questions, feel free to ask.

Regards,

Mihaela

Please Log in or Create an account to join the conversation.

Use Breezing form with Content Builder but save data to a separate table while 1 year 8 months ago #232455

  • Topic Author
  • 5uwebsite
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 126
  • Thanks: 2
Hi Mihaela,

Thanks a lot for your help! This is great as it should tell content builder who is the owner of a record, and therefore it should work. Thanks!

Now I have another issue: it seems that integrator could only pass some values to the separate table, as shown here:

mrkr.io/s/5c0772d4cc93993fd22c2539/0

I think we have connected the form and the target table, as shown here:

mrkr.io/s/5c077326cc93993fd22c253b/0

And I had provided a value for each of the field in the frontend. Could you use the following information to perform a test and let me know what was wrong?

Thanks in advance!


This message contains confidential information

Please Log in or Create an account to join the conversation.

Use Breezing form with Content Builder but save data to a separate table while 1 year 8 months ago #232474

  • mihaela
  • Offline
  • Developer
  • Developer
  • Posts: 3128
  • Karma: 105
  • Thanks: 415
Hello,

I'm not sure what might have gone wrong.

Could you please try to create a new database table with few fields that you have in your form and then connect it to just few form fields to see whether it will work.

Also, in this r6wmf_vehicle_information table, what is the primary key and do you have set auto increment? Try setting primary key differently.
Regards,

Mihaela

Please Log in or Create an account to join the conversation.

Use Breezing form with Content Builder but save data to a separate table while 1 year 8 months ago #232490

  • Topic Author
  • 5uwebsite
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 126
  • Thanks: 2
Hi Mihaela,

Thank you for your quick reply.

I created a new form with just a few fields and connected it to the integrator, it seems working well:

mrkr.io/s/5c07f7a7b8b1a4405d8e68eb/0

Regarding your question, the primary key for the form is:

mrkr.io/s/5c07f37e733e3840516df20a/0

This is a form we created via the Content Builder's Data Storage "New" function. We created the fields one by one via Content Builder, then got them connected.

Yes the primary key was set to auto_increment (i.e. as it was set by Content Builder). What else should I set differently so that it will work?

Does it also relate to the field types for each field?

Thanks!

Please Log in or Create an account to join the conversation.

Use Breezing form with Content Builder but save data to a separate table while 1 year 8 months ago #232503

  • mihaela
  • Offline
  • Developer
  • Developer
  • Posts: 3128
  • Karma: 105
  • Thanks: 415
Hello,

Ok, this means that the Integrator is working properly, but that something went wrong on connecting the previous form to database.

You wrote "This is a form we created via the Content Builder's Data Storage "New" function. We created the fields one by one via Content Builder, then got them connected.".
Do you want to say that this database that you were connecting the previous form to is the one created by Contentbuilder?

If that is the case I suggest that you DO NOT use that database that was created with ContentBuilder, but that you create manually a database table for the form that you are creating with BreezingForms and that you wish to integrate.

Regarding the field types, yes, you can't set the database column to be for, for example integers if text will be entered there.

Let me know whether I've understood you correctly and whether you've managed to create a database table and connect it properly with the form.

Regards,

Mihaela

Please Log in or Create an account to join the conversation.

Moderators: ForumSupport
Time to create page: 0.054 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

Summer Sale!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!