TOPIC:

2 records in two tables with the same ID. 4 weeks 1 day ago #274668

  • Topic Author
  • midimoinsdix
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 95
  • Thanks: 0
Is it possible to records data in several table with the same ID, with integrator ?

For example I create a form User with several field and I record this on jos__users, jos__user_usergroup_map, or jos__usersDataCustom ...
Of course the ID must be the same in all tables !

It would be necessary to register first in jos__user then to recover the record id and to force the id in the recording of the other table !?
Is this planned by BF ?

Thank' s for your expertise

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

2 records in two tables with the same ID. 4 weeks 1 day ago #274679

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 2676
  • Karma: 2
  • Thanks: 145
Hi,

it is hard to say like this, I need to make a couple of tests and see what we can to do, I will need time for testing and then I will back to you with more info.

It is a little complex, I need to investigate this, and I will back to you!


If you have more questions, feel free to ask!


Regards,
Mirko

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

2 records in two tables with the same ID. 4 weeks 1 day ago #274682

  • Topic Author
  • midimoinsdix
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 95
  • Thanks: 0
Ok Mirco,
Take your time ... ;-)

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

2 records in two tables with the same ID. 4 weeks 1 day ago #274687

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 2676
  • Karma: 2
  • Thanks: 145
Hi,

thank you for understanding! :)

I will back to you as soon as possible!

If you have more questions, feel free to ask!

Regards,
Mirko

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

2 records in two tables with the same ID. 3 weeks 4 days ago #274734

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 2676
  • Karma: 2
  • Thanks: 145
Hi,

I check this, we can save the ID number in the custom table using an integrator, you can make one element ID and then hide him, then save him in the custom table using integrator.

After when you load FORM again, we can grab ID number from the table and then automated increase it to one value and then save it.

Let me know!

Regards,
Mirko

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

2 records in two tables with the same ID. 3 weeks 2 days ago #274838

  • Topic Author
  • midimoinsdix
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 95
  • Thanks: 0
Thanks to your answer Mirco,

but I don't think that can meet the demand.
When we save data in a table, there is an autoIncrement ID which is generated and which we must use to save in the second table without having to reload the form !

Like the user registration form (table jos_users, jos_group, jos_groupmap ...).
But I don't think this is possible with BF's integrator.
Besides, the BF user registration model does not use the intergrator to do this!
Maybe in a future version...

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

  • Page:
  • 1
  • 2
Time to create page: 0.049 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

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!