Come join us on November 27-29, 2018 at the Gartner Application Strategies & Solutions Summit 2018 in Las Vegas, USA.

Skip to end of metadata
Go to start of metadata

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

The quick and easy approach in addressing this requirement is to make use of Beanshell Form Binder in the section's Store Binder. Edit the section.


Figure 2: Configure Section Properties to Determine How Data Will Be Handled


Figure 3: Choose Beanshell Form Binder as the Store Binder

In Store Binder, 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 4: Populate Beanshell Form Binder with the Necessary Codes

If the coding is properly written and tested, you will get this result:

 
Figure 5: Fill and Submit Form

Check the data in the database.

 
.Figure 6: Data Stored Correctly in the Tables

  • No labels