Introduction
Bean Shell Form Data Store works as Options Data Store too.
Figure 1: BeanShell selected as Load Data From and Save Data To
Bean Shell Form Data Store Properties
Configure Bean Shell Form Data Store
| Name | Description |
|---|---|
| Script | A script in Java. See Bean Shell Programming Guide for example. |
| Use AJAX for cascade options? | When checked, this allows these fields to dynamically load available options based on the other field value (grouping column) when dealing with a tremendous amount of selections. Read more at Ajax Cascading Drop-Down List. Not applicable to Form Data Store. Only available when used as an Options Data Store. |
| Sync Cache Interval | How often to activate cache synchronization (in seconds). For example, when set to 180 seconds, background synchronization in the server will take place every 180 seconds to refresh with the new/latest data. Tip For example, this may be used in conjunction with User Option Data Store to return all the users into a dropdown selection. If the dropdown selections are unlikely to change in a very short interval, it is recommended to set the "Sync Cache Interval" to a larger value too so that the server does not perform a new cache again in a short span of time. |
Handling for Field Workflow Variable? | Click the checkbox if you are using workflow variables mapping in your form elements. The JDBC Data Store will copy the field value to the workflow variable when you submit the form if the form is mapped to a process. Not applicable to grid elements. |
Handling for Uploaded Files? | Click the checkbox if you are using file or image attachments in your form elements. The JDBC Data Store will save your file or image attachment into the ".\wflow" folder when you save the form. Select form to store uploaded files only if you are using a form grid or spreadsheet. |
Example
Sample Load Data Store that will populate a field with id "description" with the value "hello world"
import org.joget.apps.form.model.*;
FormRowSet f = new FormRowSet();
FormRow r1 = new FormRow();
r1.put("description", "hello world");
f.add(r1);
return f;