Come join us on November 27-29, 2018 at the Gartner Application Strategies & Solutions Summit 2018 in Las Vegas, USA.
You may want to store certain fields from your form to other tables with the use of the Beanshell Form Binder. Figure 1 shows an example of a form where the first 3 fields are to be stored in another data source in addition to the original form data table.
Figure1: Form with Field to Store
Then, click on the form "Properties" tab and navigates to "Advanced" page. Choose "Bean Shell Form Binder" as Store Binder.
Figure 2: Choose Bean Shell Form Binder as the Store Binder
Configure Bean Shell Form Binder with your own coding to store the fields as intended, as shown in the figure below.
Code used in this example:
Figure 3: Populate Bean Shell Form Binder with the Necessary Codes
If the coding is properly written and tested, you will get this result:
Figure 4: Fill and Submit Form for Testing
Check the data in the database.
Figure 5: Data Stored Correctly in the Tables