Hi,

I have a FORM (in Zoho Creator) with a MULTISELECT field and a SINGLE LINE field. The form is connected to a table in Zoho Reports.

I would like to add each selected field in the MULTISELECT as a new row in the table. If possible copying the SINGLE LINE field in each row.

Example 

The Form

Barcode No   -   Products 

AB12                apple, melon

The Table

AB12      apple

AB12      melon

This is the script I am currently using:

creatingMap = map();

creatingMap.put("Barcode No", input.Barcode_No);

creatingMap.put("Products", input.Products.toString());

mapResponse = zoho.reports.createRow("the dB", "The Table", creatingMap);