RSForm!Pro - User Profile, Community Builder and Mappings

An example that uses RSForm!Pro - Joomla! User Registration plugin and the built-in mappings functionality to associate data within the Joomla! User Profile table while also creating the Community Builder user entry.

Introduction

---

For a while now, RSForm!Pro provides a Joomla! User Registration plugin, which as suggested, can be used to create your very own Joomla! user registration form.

Using the built-in mappings feature we can extend the form's functionality even further by assigning additional data within the standard Joomla! User Profile related table as well as within third party extensions such as Community Builder.

Before starting off, you'll have to firstly create a registration form. Once this is completed and functional, mappings are specified as instructed below.

Joomla! User Profile Mapping

---

Navigate to backend > Components > RSForm!Pro > Manage Forms > your form > Properties > Mappings and follow these steps:

The example assumes you have an extra field in your form named phone and that you want it to be associated with the according user profile data.

1. Click on the 'New Query' button.
2. Set 'Connection type' to "Local".
3. Set 'Method' to "Insert".
4. Click on the 'Connect to database' button.
5. From the 'Database table' dropdown select "#__user_profiles". (`#` would be your Database Tables Prefix)
6. Set 'user_id (int)' to {global:userid}. (this is a global placeholder and it will be replaced with the newly created user ID)
7. Set 'profile_key (varchar)' to profile.phone. (this would be the profile_key to which we associate the submitted value. A full list of these keys can be found below.)
8. Set 'profile_value (text)' to "{phone:value}". (this is the placeholder of our phone field that will return the submitted value.)

Repeat the same procedure for any other User Profile information you would like to map.

'profile_key'	Usage
profile.website	Website
profile.region	Region
profile.postal_code	Postal/ZIP Code
profile.phone	Phone
profile.favoritebook	Favourite Book
profile.dob	Date of Birth
profile.country	Country
profile.city	City
profile.address1	Address 1
profile.address2	Address 2
profile.aboutme	About Me

Community Builder Mapping

---

Navigate to backend > Components > RSForm!Pro > Manage Forms > your form > Properties > Mappings and follow these steps:

The example assumes you want to create the user entry within Community Builder and that you have an extra field in your form named phone which you wish to also be associated with a Community Builder custom field.

1. Click on the 'New Query' button.
2. Set 'Connection type' to "Local".
3. Set 'Method' to "Insert".
4. Click on the 'Connect to database' button.
5. From the 'Database table' dropdown select "#__comprofiler". (`#` would be your Database Tables Prefix)
6. Set 'id (int)' to {global:userid}. (this is a global placeholder and it will be replaced with the newly created user ID)
7. Set 'user_id (int)' to {global:userid}.
8. Set 'cb_customfieldname (varchar)' to {phone:value}. (this is the placeholder of our phone field that will return the submitted value.)

After the form is submitted, the user account that has just been created will also be associated with Community Builder along with the custom field information.

Your Involvement Matters

---

If there's anything you think that should be implemented in future releases, be it a brand-new feature or an improvement for an existing one, don't hesitate to tell us about it!