Introduction

Do You Know?

Bean Shell Form Data Store works as  Options Data Store too.

Bean Shell Form Data Store allows you to dictate how Form Data should be loaded and stored.

Figure 1: BeanShell selected as Load Data From and Save Data To

Bean Shell Form Data Store Properties

Configure Bean Shell Form Data Store

NameDescription
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;
  • No labels