marcq
Member
Hi,
I have created a form which enables people to submit an Inquiry.
After submit, data?s are stored in the ?pbdf_fabrik_user_demande_conseils? database table :
?pbdf_fabrik_user_demande_conseils? table fields :
id
date_record
statut
degreurgence
userid (userid of the registered user which is submitting the form)
no_assure
username
name
firstname
usergroup
titre
demande
typedemande
piecesjointes
titre_demcons_client
The ?no_assure?, ?name? and ?firstname? fields are empty and should be retrieved from the ?pbdf_fabrik_user_clients? database table and populate this 3 empty fields with the data that belong to the registred user which is submitting the form :
?pbdf_fabrik_user_clients? table fields :
id
date_record
date_update
last_visite
user_group
userid
username
name
firstname
email
password
no_assure
Question :
Can I use the Form PHP plugin, End of form submission (onAfterProcess), to update the 3 fields of the record which just have been created in the ?pbdf_fabrik_user_demande_conseils? table with the values of the ?pbdf_fabrik_user_clients? table ? Is it the right way to do ?
If yes, could someone kindly explain me how the build my query in order to retrieve those data?s and update the 3 mentioned fields with the values that belong to the registered user which is submitting the form ? I?m a very newby which have less experience in building sql queries so I would appreciate if someone could explain me how to solve this issue.
Thanks in advance!
Cheers,
Marc
Fabrik version 3.2
Joomla 3.3.6
I have created a form which enables people to submit an Inquiry.
After submit, data?s are stored in the ?pbdf_fabrik_user_demande_conseils? database table :
?pbdf_fabrik_user_demande_conseils? table fields :
id
date_record
statut
degreurgence
userid (userid of the registered user which is submitting the form)
no_assure
username
name
firstname
usergroup
titre
demande
typedemande
piecesjointes
titre_demcons_client
The ?no_assure?, ?name? and ?firstname? fields are empty and should be retrieved from the ?pbdf_fabrik_user_clients? database table and populate this 3 empty fields with the data that belong to the registred user which is submitting the form :
?pbdf_fabrik_user_clients? table fields :
id
date_record
date_update
last_visite
user_group
userid
username
name
firstname
password
no_assure
Question :
Can I use the Form PHP plugin, End of form submission (onAfterProcess), to update the 3 fields of the record which just have been created in the ?pbdf_fabrik_user_demande_conseils? table with the values of the ?pbdf_fabrik_user_clients? table ? Is it the right way to do ?
If yes, could someone kindly explain me how the build my query in order to retrieve those data?s and update the 3 mentioned fields with the values that belong to the registered user which is submitting the form ? I?m a very newby which have less experience in building sql queries so I would appreciate if someone could explain me how to solve this issue.
Thanks in advance!
Cheers,
Marc
Fabrik version 3.2
Joomla 3.3.6