robhparker
New Member
I am looking to create a custom registration for the users table.
explained here in option #2
http://fabrikar.com/forums/index.ph...-joomlas-registration-form-with-fabrik.28436/
The object is to map the core _users table to a list and then create an "extra fields" list/table and join the two.
I followed the tutorial (french I translated in Chrome) by jfquestiaux.
http://betterliving.be/Fabrik/rempl...egistrement-de-joomla-partie-1/All-Pages.html
This got me as far as the _users table list creation without messing up the core table. I was unable to find the part 2 of the tutorial so I created another table and joined them. Used my extra field list and added a left join from id->id (delete joined data=no).
I have a few questions.
#1 Is this even the best way to accomplish this?
#2 the fields LastResetTime and reset count have noted in the tutorial to set Cache to "yes" and date default update to "no" I dont see the parameters in the field, and I cannot keep them from displaying in the form, even when I choose to hide them.
#3 the users table obviously has a "name" field. I would like to have a first name, last name fields in the extra fields overwrite the Name field in the users table when edited/saved with the values from firstname and lastname with a space. I have this happening using the calc element in the _extra fields table with a fullname field, but it is duplicate data as the users table field. Any solution that would sync these two fields together or have the calc write to the name field in the users table?
I have uploaded a screenshot of my form for what it is worth. The "extra fields" table is named staff in my case. This is basically a staff user profile.
explained here in option #2
http://fabrikar.com/forums/index.ph...-joomlas-registration-form-with-fabrik.28436/
The object is to map the core _users table to a list and then create an "extra fields" list/table and join the two.
I followed the tutorial (french I translated in Chrome) by jfquestiaux.
http://betterliving.be/Fabrik/rempl...egistrement-de-joomla-partie-1/All-Pages.html
This got me as far as the _users table list creation without messing up the core table. I was unable to find the part 2 of the tutorial so I created another table and joined them. Used my extra field list and added a left join from id->id (delete joined data=no).
I have a few questions.
#1 Is this even the best way to accomplish this?
#2 the fields LastResetTime and reset count have noted in the tutorial to set Cache to "yes" and date default update to "no" I dont see the parameters in the field, and I cannot keep them from displaying in the form, even when I choose to hide them.
#3 the users table obviously has a "name" field. I would like to have a first name, last name fields in the extra fields overwrite the Name field in the users table when edited/saved with the values from firstname and lastname with a space. I have this happening using the calc element in the _extra fields table with a fullname field, but it is duplicate data as the users table field. Any solution that would sync these two fields together or have the calc write to the name field in the users table?
I have uploaded a screenshot of my form for what it is worth. The "extra fields" table is named staff in my case. This is basically a staff user profile.