Starting with revision 1.4.0, RSForm!Pro has built-in mappings feature. This tool allows you to integrate RSForm!Pro with 3rd party extensions.
As an example, we will show you how to map the user submitted data to Joomla! articles.
We have created a form that allows users to submit their articles.
After filling in the form, the user's submitted data are converted into a Joomla! article.
We have created a form that will create a new article upon its submission. Once the user completes the form, the submitted data is converted into a Joomla! article.
Map the Joomla! form fields
- In the "Manage forms" tab, access the form properties for which you want to map the fields.
- Click on Extras >> "Mappings" tool >> New. the tool allows you to map the form data to a remote or local database table.
- Select the 3rd party database table that you wish to integrate with RSForm!Pro. We've chosen the "jos_content" table to map the RSForm!Pro fields to Joomla! content.
- Map the 3rd party component fields with the corresponding RSForm!Pro placeholders. RSForm!Pro generates the placeholders based on the form fields.
e.g. {last_insert_id} with id (int unsigned), the form title with title (varchar), the form content with fulltext (mediumtext), metakey (text) with the user's submitted meta keywords, metadesc (text) with the user's submitted meta description. - When the category and the section fields are left blank, the articles are saved as "Uncategorized".
- Articles can be automatically published or unpublished upon the form submission by using in the corresponding fields "1", respectiv "0".
- You can map all the parameters of a Joomla! article: author, publishing date, meta data, hits, etc.
- Using the RSform!Pro Mapping feature you can set multiple mapping actions with various operations to various tables
Upon the form submission, the article is saved in the configured section and category.
Related Videos
Episode 3 : Joomla! Form inside article - RSForm!Pro
Ep. 7 - How to send e-mails to recipients listed in a drop-down field
Episode 8 : Creating forms for Joomla! with RSForm! Pro
Ep.9 - Create a multilanguage form in Joomla! with RSForm! Pro and Joom!Fish
Ep. 25 - How to add Paypal functionality to your Joomla! forms using the RSForm!Pro Paypal Plugin
Ep. 32 - Using RSForm!Pro and Salesforce to create new leads
Ep. 33 - Using RSForm!Pro with Mailchimp
Ep. 39: Create newsletter subscription forms with RSForm!Pro and RSMail!
Ep. 40: Create custom Joomla! registration forms for your events with RSEvents! and RSForm!Pro
Ep. 51: How to configure the user and the admin email in RSForm!Pro
Ep. 52: How to translate a Joomla! form using the RSForm!Pro multi-language option
Ep. 57: RSForm!Pro Constant Contact Integration
Ep. 58: RSForm!Pro integration with Akismet
Ep. 59: How to create custom Joomla! registration forms with RSForm!Pro
RSS
about the ordering field
how would I make the ordering field increment automatically from the highest one? it all works, but the ordering field stays empty...Quote
how would I make the ordering field increment automatically from the highest one? it all works, but the ordering field stays empty...Quote
mapping
I searched for hours in joomla api how to add an article with custom form, before I realized that you had ever thought. Great job, thanks!Quote
I searched for hours in joomla api how to add an article with custom form, before I realized that you had ever thought. Great job, thanks!Quote
@john
If you download the installation file again and run it over your current one, you will notice that you can use HTML inside the mappings area. Having this into consideration you will be able to use an image tag.Quote
If you download the installation file again and run it over your current one, you will notice that you can use HTML inside the mappings area. Having this into consideration you will be able to use an image tag.Quote
DB question
Great tutorial, this made me realized how powerfull RSforms cam be.
I am working now on website where users can submit events. Originally I wanted to use RSevents but unfortunatelly the submitting form is not flexible enough.
I had a look at this option - to submit the form into Joomla article and i think it is workable, but i have one question - is there a way the form can be submitted into joomla article but ALSO show into RSforms submittions? Can I create double mappings? I tried but I am not sure what fields to include... I can see in DB that the IP address and time is still recorded but I can't see the submittions in the backend of Joomla.
Could you please point me in a right direction?
Appreciated, CamillaQuote
Great tutorial, this made me realized how powerfull RSforms cam be.I am working now on website where users can submit events. Originally I wanted to use RSevents but unfortunatelly the submitting form is not flexible enough.
I had a look at this option - to submit the form into Joomla article and i think it is workable, but i have one question - is there a way the form can be submitted into joomla article but ALSO show into RSforms submittions? Can I create double mappings? I tried but I am not sure what fields to include... I can see in DB that the IP address and time is still recorded but I can't see the submittions in the backend of Joomla.
Could you please point me in a right direction?
Appreciated, CamillaQuote
@Raj
Using the mappings tools does not cause RSForm!Pro not to save the data as it would normally do. After all the normal processes, the mapping functionality is triggered. You can set up as many queries as you need.Quote
Using the mappings tools does not cause RSForm!Pro not to save the data as it would normally do. After all the normal processes, the mapping functionality is triggered. You can set up as many queries as you need.Quote
