TEMA:

2 records in two tables with the same ID. 1 año 19 horas antes #274668

  • Autor del tema
  • midimoinsdix
  • Fuera de línea
  • Navegador Senior
  • Navegador Senior
  • Registered
  • Mensajes: 100
  • Gracias recibidas: 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

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

2 records in two tables with the same ID. 1 año 6 horas antes #274679

  • Avatar de Mirec
  • Mirec
  • Fuera de línea
  • Navegador Platino
  • Navegador Platino
  • Registered
  • Mensajes: 3262
  • Gracias recibidas: 163
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

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

2 records in two tables with the same ID. 1 año 4 horas antes #274682

  • Autor del tema
  • midimoinsdix
  • Fuera de línea
  • Navegador Senior
  • Navegador Senior
  • Registered
  • Mensajes: 100
  • Gracias recibidas: 0
Ok Mirco,
Take your time ... ;-)

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

2 records in two tables with the same ID. 1 año 3 horas antes #274687

  • Avatar de Mirec
  • Mirec
  • Fuera de línea
  • Navegador Platino
  • Navegador Platino
  • Registered
  • Mensajes: 3262
  • Gracias recibidas: 163
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

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

2 records in two tables with the same ID. 11 meses 3 semanas antes #274734

  • Avatar de Mirec
  • Mirec
  • Fuera de línea
  • Navegador Platino
  • Navegador Platino
  • Registered
  • Mensajes: 3262
  • Gracias recibidas: 163
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

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

2 records in two tables with the same ID. 11 meses 3 semanas antes #274838

  • Autor del tema
  • midimoinsdix
  • Fuera de línea
  • Navegador Senior
  • Navegador Senior
  • Registered
  • Mensajes: 100
  • Gracias recibidas: 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...

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

  • Página:
  • 1
  • 2
Tiempo de carga de la página: 0.065 segundos

Live Support Chat Opened!

Join our Discord chat here and enter the Crosstec channels to receive live support and talk directly to the team!