Saving a multiselect control to a database

  • 24 October 2016
  • 2 replies
  • 0 views

Badge +1

I have successfully disaplayed data in a multiselect control and it is working fine. However, it saves the selected values as one record, with the selected values delimited. I want to be able to create a record for each item selected. Is this possible with this control?


2 replies

Badge +7

I cannot think of a way to do this in the form but you can do it in a workflow. There is a "for each" function in the work flow that can take a delimited list and do something like create a record for each item. Just pass the data into a workflow field.

 

The form has a "for each" funtion but I think it only works when mutiple records already exist.

 

I hope this helps

Badge +1

Thanks for your help. I ended up passing the string from the multiselect into a stored procedure and then using a split function to separate it out.Thanks

Reply