For this article, it will teach you how to use Execute SQL feature. Execute SQL feature allows you inserting values of form fields into your custom data tables.
For example, you have three fields “Name”, “Email” and “Comment” in your form. And you also have one FormTable which includes Name, Email, Comment these three fields. You want information submitted by users added into Formtable.
1. First of all, please enter Management Center -> Module Settings page and check option “Execute SQL”.
2. You need to write SQL script in SQL Script. In Sql script, you can include Tokens on the right of Textbox. These tokens represent form fields. In this example, we write following sql script.
insert into FormTable
3. In this way, data of form will be inserted into FormTable after users clicking submit button.