• 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: Using RSForms Pro for user registration with CB

Using RSForms Pro for user registration with CB 10 years 2 weeks ago #31056

  • Burnardo
  • Burnardo's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
  • Thank you received: 1
i, Searching for days on end, nothing found that seriously helps me yet.
I am trying to use a working registration form (i have created a basic functional Joomla registration form already...) by RSForms Pro to also fill data which are used for CB (Community Builder) registration.

Where to add additinal script in the RSfoms?
Which basic script needs to be added to perform this task?
Are example forms available with this working function?

These questions have been asked a multitude of times but there is not one place where a fully usable answer is given. And it is hard to form an answer with all these small chips of unrelated information.

Thank you for guiding me (and a lot of other people) on this path,
Kind regards,
Ben van Wetten
The administrator has disabled public write access.
The following user(s) said Thank You: xristo

Using RSForms Pro for user registration with CB 10 years 1 week ago #31078

  • Burnardo
  • Burnardo's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
  • Thank you received: 1
OK, So I have received a hint on where to start looking....
SQL mapping should do the trick, so they tell me.

In my RSform I have to go to "Properties" and then under "Extra", I have to click on "SQL Mappings". A new mapping should be selected.

Its purpose should be to fill the database table #_comprofiler with data that are now known.
First the ID should be retrieved from the #_users table and the inserted into the #_comprofiler table.

This requires 2 actions. 1 to retrive the just freshly made new ID, and then (action 2) to insert this value in the right space in the table #_comprofiler.

The SQL mapping only takes care of the creation of a new row, NOT the retrieval of the ID...

So, How do I do this?
Please help,
The administrator has disabled public write access.

Using RSForms Pro for user registration with CB 9 years 10 months ago #31661

hi Burnardo,

I am having the same problem, you could retrieve the ID? please, if so show the solution.

thanks!
The administrator has disabled public write access.

Using RSForms Pro for user registration with CB 9 years 9 months ago #31670

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
Perhaps the following blog post will help: https://www.rsjoomla.com/blog/view/314-rsformpro-user-profile-community-builder-and-mappings.html
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.
The following user(s) said Thank You: jayson5555

Using RSForms Pro for user registration with CB 9 years 9 months ago #31676

extremly grateful AlexP,

only missing one thing to work out in my case, give in {global: userid}. I tried other means least that.

I did as the article indicated by you, gave 100% sure.

Thank you very much.
The administrator has disabled public write access.

Using RSForms Pro for user registration with CB 9 years 9 months ago #31681

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
{global:userid} should be automatically replaced with the id of the newly created user. If this doesn't occur, most likely, you are not using the latest RSForm!Pro version and Registration plugin:

https://www.rsjoomla.com/support/documentation/rsform-pro/changelog.html
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.

Using RSForms Pro for user registration with CB 9 years 9 months ago #31689

It worked,

the command is perfect for my site.

thanks
The administrator has disabled public write access.
  • 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!