What is the syntax to use for an insert completion event to add multiple values from a combo box?

To be clearer, I'd like to insert data into a SQL table using the checkbox group. How do I pass the selected values from the checkbox group to a SQL table using the completion event?

Hello Collin,

The Checkbox Group in Dynamic Forms will concatenate all of the values into a comma separated list.

Let's say that you have a Checkbox Group with the shortfield name of "RSVP" with the Following checkboxes:
* Yes
* Maybe
* No

If a User checked all of these checkboxes, then the value would look like this when trying to use the token in a SQL Completion Event:

'$(RSVP)' would render to: Yes,Maybe,No

Please let me know if you have any questions.

Thanks,

Ryan

Ah, so I need to take a comma separated sting value and write a SQL statement that will delimit it so that each value can be passed to a table.

Hello Collin,

If you use this SP call:

usp_InsertStoredProcedure '$(RSVP)'

And all three checkboxes were checked, then the call renders to this:

usp_InsertStoredProcedure 'Yes,Maybe,No'

If you need to separate these values, I would recommend looking for a SQL Split Function:
http://stackoverflow.com/questions/...lit-string

The Function in the post from the link I gave you will return three separate values:

* 'Yes'
* 'Maybe'
* 'No'

The issue is that all of these values at the moment are 1 value. You need to split based off of a comma being the delimiter. Based on the values returned, you can run a series of different events.

Please let me know if you have any questions.

Thanks,

Ryan

That worked. Thanks for the lead.

Glad that I could be of assistance.

Have a great day!

-Ryan