Please enable JavaScript to view this site.

Navigation: Advanced topics > Events > Sample events > Database

Select multiple values to show as individual database entries

Scroll Prev Next More


To select multiple values from checkboxes or a list field and have them appear as individual database entries, use the following code in the Add page: Before Record Added event.




if (values["fieldname"])
var arr = MVCFunctions.explode(",", values["fieldname"]);
// This is the name of the multi check box or
// list select field, its value becomes arr
for (int i = 0; i < arr.Count(); i++)
var strInsert = String.Format("insert into TableName (field) values ('{0}')", arr[i]);
// add more fields from the add page to be inserted into database
DB.Exec(strInsert, GlobalVars.conn);
// Exit and Redirect to the list page after updating database
MVCFunctions.HeaderRedirect("tablename", "list");

See also:

JavaScript API:getSelectedRecordKeys()

Database API: DB::Exec

Redirect to another page