Use Breezing form with Content Builder but save data to a separate table while

  • 5uwebsite
  • Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 86
  • Thank you received: 1

5uwebsite replied the topic: Use Breezing form with Content Builder but save data to a separate table while

Thanks for the answer :)

I am then using the Content Builder View to let frontend users to edit all their own records now.

However, I found that if I updated a record at the frontend, the data stored in the separate table won't be updated accordingly.

As shown here: mrkr.io/s/5c1bd1705dabfa71404a5809/0

Currently I only have a record for the "insert" type. This is working well for new record creation.

Should I add another rule with the "Update" type, then keep both rules and it should work? Is there an easy way to copy the existing rule and change its type so that I don't need to relink all fields?

Thanks,
#232948
  • Posts: 1573
  • Karma: 48
  • Thank you received: 201

mihaela replied the topic: Use Breezing form with Content Builder but save data to a separate table while

Hello and Happy New Year,

Sorry for the late response, Crosstec Support staff was on collective holiday vacation, as noted in the forum.

Yes, if you have "Insert" rule it will only add new records, but if you add "Update" rule as well it will update the existing records.

You asked: "Is there an easy way to copy the existing rule and change its type so that I don't need to relink all fields?". Unfortunately, the answer to your question is no, you have to reconnect the fields to a database table columns.
What is important in order for the integrator "Update" rule to work properly, you must set the right update criteria by which you want the fields to update.

Regards,

Mihaela
#233045
  • 5uwebsite
  • Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 86
  • Thank you received: 1

5uwebsite replied the topic: Use Breezing form with Content Builder but save data to a separate table while

Hi Mihaela,

Thank you for your reply. Happy New Year! I wish you all the best in 2019! I hope you enjoy the vacation!

Yes the method you mentioned is working now. We can edit a record at the frontend, via Breezing Form, then update the record stored in the destination table with the "Update" rule Integrator :)

Now, we want to let the website administrator(s) to edit a selected record at the backend.

Please correct me if I am wrong. Currently, a record is created/updated with the following order:

1. Frontend Breezing Form Record Create/Update;
2. Record gets stored to Breezing Form's Table when we hit the "Submit" button of Breezing Form;
3. Integrator will Create/Update the corresponding record at the final destination: a separate database table that we used for frontend filtering, display etc.

And I created a Content Builder View, with the type "com_breezingforms", so that I can have more controls on permissions (e.g. only the record owner could update its own record), and the owner can see a list of all his/her records in the frontend.

Now, we will need to setup a way to let administrator to edit any records in the backend.

1. Do you think I need to setup a separate "backend" view for the administrator, so that this view is only for backend? As shown here:

mrkr.io/s/5c3ba6933c75fc372eb09343/0

2. I try to let the administrator to edit a record with the same Breezing Form as the frontend, by checking the "edit by type" option for the backend view. It works, but it seems that I always got the "Template not found" error: mrkr.io/s/5c3baaa26ecfec3744891860/0 If I click the "Edit" button, it will let me edit that record with the same Breezing Form though. How could I get rid of this error?

3. After clicking "Edit" button of step 2, I will have the same Breezing form of frontend, but losing all its styles and layouts. Is it possible to have the same layout/styles as the frontend Breezing Form?

4. In the backend list view, can we have checkboxes in front of each record, and use it to select multiple records for mass operation? For example, deleting multiple records all at once: mrkr.io/s/5c3bab91be85dd36c97af9e4/0

Thanks a lot for your help!
#233265
  • 5uwebsite
  • Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 86
  • Thank you received: 1

5uwebsite replied the topic: Use Breezing form with Content Builder but save data to a separate table while

And I have 2 more questions, in addition to my latest response:

5. If we edit the Brezzing form records in backend, will integrator update the corresponding table's record?

6. If we edit the content builder records in backend, will integrator update the corresponding Breezing form record?

Thanks!
#233269
Moderators: ForumSupporttomeperica
Time to create page: 0.070 seconds

Community Reward

Help us to create new extensions and plugins! With only $5 you help us a lot and get unlimited download access to all of our products, professional support and even more. Get your reward now!

Read More Here

News and Updates

Get informed about new downloads, updates and more in our News and Updates newsletter.

All Extensions Subscription

Get 1 year access to all of our current and future products and 1 year of professional support -- 99€

No support per domain or website installation limits! Includes all of our current and future Joomla!® extensions, Joomla!® templates for the duration of your membership. This means, by purchasing an All Extensions Subscription you'll have it all covered!

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!

Community Reward

Help us to create new extensions and plugins! With only $5 you help us a lot and get unlimited download access to all of our products, professional support and even more. Get your reward now!

Read More Here