Download User Guide - De Sprenge Emst

Dynamic Forms 3.3
•
User Guide
Event Actions – this part of the screen is used for defining the event action and contains
the following parameters:
o
SQL Statement – the text area for entering the SQL statement that will be
executed based on the users response or after the form results have been saved
o
SQL Parameters – this is a list of SQL parameters which you can use in your SQL
query (some parameters are based on short field names for your questions); to
include the desired parameter e.g. First name, you can either double click it in the
menu or drag and drop it inside the SQL Statement text area
o
Assistance links - The auto generate SQL assistance links help to provide the
functionality and quick assistance with building work-flow applications using
Dynamic Forms. Dynamic Forms currently already saves data into relational
database tables, and from those tables you can query the results/export the results
to excel/view the results within the 'View Results' area of the module. The
assistance has been added to provide further implementation assistance for users
wanting to create Insert/Update/Delete implementations for a 'flat' table within your
web site. The following assistance links are available:
o
ƒ
Generate Create Table SQL (One time only execution) - this should be
created after your form fields have been setup. A SQL script will be
created which will generate a table based on the forms instance, and
create a column within the table based on each form fields 'short field
name'. This query should only be executed one time and should be
executed under Host, SQL.
ƒ
Generate Insert SQL Query - this should be created and utilized as a
SQL Completion Event. You might consider creating a hidden field to
represent 'Submit', 'Edit', 'Delete' functionality as described within the
demonstration #14, and then only firing the insert statement for initial form
submission.
ƒ
Generate Update SQL Query - this should be created and utilized as a
SQL Completion Event. You might consider creating a hidden field to
represent 'Submit', 'Edit', 'Delete' functionality as described within the
demonstration #14, and then only firing the update statement for editing or
updating a form submission
ƒ
Generate Delete SQL Query - this should be created and utilized as a
SQL Completion Event. You might consider creating a hidden field to
represent 'Submit', 'Edit', 'Delete' functionality as described within the
demonstration #14, and then only firing the delete statement for deleting a
form submission.
External DB Connection – use this field in case you want to connect to a
database outside of the standard DNN database connection
Note: As with all SQL Queries, you should always use caution and test against any possible SQL
Injection attacks. Although Dynamic Forms does guard against SQL injection routines, you should
always use stored procedures to guard against SQL Injection.
7.52.3 Example of the Dynamic Email Event
URL Page Redirection event is used for sending an email to the user or to you as an administrator
based on the response given within the form.
For the purpose of this example a website offering the services for job seekers and employers is
taken.
If this is the case you may want to create Dynamic Email event which would send an email to the
user based on the response given in the form.
In order to start creating a Dynamic Email event, choose option “New Event” from the “Select
Event” menu and then select option “Dynamic Email” (note: the screen is presented with two
screenshots).
Page: 143 / 181