• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Map user registration form to 3.7 custom fields?

Map user registration form to 3.7 custom fields? 7 years 11 months ago #36837

  • dustin9
  • dustin9's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 6
We are using the RSForm Joomla User Registration to register users to specific user groups and would like to combine this with the new custom fields in Joomla 3.7. Is there a way to map RSForm fields to the Joomla user custom fields automatically during the registration process? For example, we ask Employee's registering to enter their Employee# and would like this automatically mapped to the Employee# custom field that appears in the user manager.
The administrator has disabled public write access.

Map user registration form to 3.7 custom fields? 7 years 10 months ago #37034

  • rod.m
  • rod.m's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
Would really like to know the answer to this too...
I'm assuming an update to the Joomla Registration plugin is coming... is there a way to do this in the meantime?
The administrator has disabled public write access.

Map user registration form to 3.7 custom fields? 7 years 10 months ago #37044

  • clucking
  • clucking's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 21
  • Thank you received: 2
I asked support the same question some weeks ago. Here is the reply I got:

"Please note that RSForm!Pro Joomla! user registration plugin was designed to use the default Joomla! users table in order to add your users. Since the users table contains a limited number of fields, the additional information that comes from your additional fields is saved within the RSForm!Pro specific tables. In order to map the user additional data in the profile tables you can try using the `SQL mappings` feature:

www.rsjoomla.com/support/documentation/r...database-tables.html

This newly Joomla! user fields feature doesn't use the same User Profiles table, instead the table in question is actually the following:

#__fields_values

You'll basically have to replicate this in your mapping. It would be best if you normally add such information to some of your users using the Joomla! CMS to notice how this gets correlated in the database. From what I can see the above table has 3 columns:

field_id - the ID of your custom field.
item_id - which appears to be the exact User ID.
value - the value associated with the user's information for that field.

A similar example on this matter is provided here:

www.rsjoomla.com/blog/view/314-rsformpro...er-and-mappings.html"
The administrator has disabled public write access.
The following user(s) said Thank You: rod.m, Kevin.brackley
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!