Add multiple record with checkbox

Hi,
I have a xyzid(datatype = number) field in my database.
I have marked this field in Edit Tag as Checkbox and linked to a Lookup Table with master table.What we would like is that PHPmaker automatically adds multiple records in the table when multiple checkbox is checked.
Not as single record with join text from multiple xyzid.Can we do it ?

You need to handle it by your own code.

  1. Add your code in Row_Inserting Server Event.
  2. Insert the data rows per selection of this field with Execute() function.
  3. return false to stop insert the original record.
  4. clear the failure message and add success message.

Hi,
I tried with code from https://discourse.hkvstore.com/t/iterate-dropdown-checkbox-selected-value-to-insert-records/536/1 the explode code is not working cause my field is integer
$field2array = explode(‘,’, $rsnew[‘field2’]);Ex if I select ID 2 and 4, it’s inserted as 24Any idea ?

Nevermind,
I use custom field to create the string versionThank you

HI
can some one discripte how make the following step by step? please.
“I have a xyzid(datatype = number) field in my database.
I have marked this field in Edit Tag as Checkbox and linked to a Lookup Table with master table.What we would like is that PHPmaker automatically adds multiple records in the table when multiple checkbox is checked.
Not as single record with join text from multiple xyzid.”

use datatype=varchar for your xyxid field.

can you explain the four steps