Hi guys,

Im on a binding... please help me out. It turns out that I have a CheckBox Group which Im filling with a query via SQL Driven Options. The query works all right, as I can see the result set loading in the list below. I'm using the same result for the QuestionOption and QuestionOptionValue.

So then the form loads... and it's all good until I hit the submit button and expect a confirmation email... which then I receive but without my CheckBoxGroup response... I also check the tables to see if something was wrong with the parameter specification or such, but in the Response table I can see that field goes blank as well...

Could it be a small bug suitable for a quick fix? I need to get this form in production in a matter of hours... manual entry of the options could be an alternative but the options are "user sensitive" meaning that they are fed from user entry from another app, and they may change without further notice... X_X

Read you around... thanks in advance.

BigAl

Hi. Yes this should be working as you suggest as long as you are pulling in both a question text and question value into the dropdownlist. Also, we are working on the ability to 2.5 to be able to display within the email events things such as $(Field1_Text) instead of pulling in the value etc..

If you can duplicate this on our www.betasprings.com site this will help us get a fix out quicker if one is needed. Also are you running on 2.3.7? Sorry we didn't get back to you sooner, I was at Open Force all last week.

-Chad

Also, what is the query you are using? If you view the source do you actually see the values being set correctly on the check box group field?

-Chad

Hi Chad,

Well, dropdownlists works without any problem with the SQL option, but my issue is related to the CheckboxGroup in that I cannot extract the value using the $(field) and that I get a blank insert in such questions, even when the list was loaded succesfully, as I can see from both the form and the page's source.

You can try the following to see what I mean:
1) Insert a CheckboxGroup field in your form
2) Select the SQL Driven Options...
3) Type in the following query:
"SELECT 'Hi' AS QuestionOption, 'Hi' AS QuestionOptionValue.
4) Go to Form Completion Events... Select Add a New Event.
5) Select Dynamic Email and fill in the subject, from, and recipient fields... (you can use your own email account for a quick test)
6) In the body, type the parameterized field "$(field)" of your CheckBoxGroup, so that the only thing you'll see when you open the mail is "Hi"
7) Save changes...
8) Fill the form and click the Submit button... you should receive the email you configured with a blank body text instead of "Hi". And if you check your DB tables, the answer is inserted as a Blank too.

Really, I have tried that many, many times and I get the same result. Im running with 2.3.7 which is the last update so far.

Please help me out, I know you can For the time being I used the manual entry of the options to get me out fo the fry, but I really need those options to load dynamically (since they are intended to be courses of some sort - subject to change)

Looking forward to your reply (and the new release of course)
BigAl

PS. Cheers!

Hi. I just wanted to follow up on this thread. Another customer brought this to our attention but after reviewing this further it does appear to be working correctly in version 2.5.

-Chad