Mooj Proforms’ User Manual
Informatiker (FH) Fahrettin Kutyol
3.6. Storing submissions
Proforms gives you the opportunity to store submission data in several ways.
The built-in, most easy and common way is to use Proforms’ native data recording.
Besides this, there is also the possibility to store submission values in your very own
database table with the SQL or SQL+ apps. For this you must be familiar with SQL up to be
an intermediate SQL coder.
Please note that submission storage as well as the usage of SQL and SQL+ apps are not available for Proforms
Basic! The SQL app is only available for customers with a 180 or 365 days service package!
The SQL+ app is only available for customers with a 365 days service package!
3.6.1.
Proforms’ native ‘one-click-submission-storage’
When creating or editing a form as described in 3.4 you have the opportunity to activate
database storage by ‘one-click’ which is actually a ‘by one-selection’.
The drop-down “Process” can be found at the first tab “Main
Configuration”. By selecting “Database” or “Email+Database”
submission will automatically stored in Proforms’ very own database
tables.
Please note that Proforms’ database tables are structured as “key-value-pairs”.
The table ‘#__m4j_storage’* does contain all main data of the storage such as date,
Joomla® user id, IP address, opt-in confirmation flag and the encrypted folder name where
uploads are stored. The table ‘#__m4j_storage_items’* contains the ‘key-value-pairs’.
* ‘#__’ represents the Joomla® database prefix.
Stored information by this method can only be viewed at the backend via the records
manager. There is no opportunity of displaying submission records at the frontend.
An additional component which displays submissions at the frontend will be
published soon.
This function is not available for Proforms Basic!
Comments to this Manuals