Additional row is also added when tried to store seperate rows for each item in Multi -select list
Hi,
I am creating an application that includes a form called Form 1 with
single line field 1
single line field 2
and one Multiselect Field(Look up).
When i tried adding more than one item in the Multi select list for the Form 1, in the Form 1 View this is stored in one single row with the items seperated by comma's in the Multi select column.
So i have written the below code on, Script(On Add) -->Actions On Success,
that enters the records in different rows for each item selected in multi select,
for each r in input.Multi_Select_Field
{
insert into Form_1
[
single line field 1 = input.single line field 1
single line field 2 = input.single line field 2
Multi_Select_Field = List:String({r})
Added_User = zoho.loginuser
]
}
I could able to get the two different rows for two items selected for Multi select field but
along with the two seperate rows, i also found an extra row that includes the Multi select field column values
seperated by commas.This is an extra row
So when i select two items in Multi select field i am getting total three rows(two seperate records which are necessary and one record with multi select field column with commas which is not necessary) in the Form_1_View.
I have to get only two separate rows for two fields selected in the multi select field.
Please help me in solving this problem