Forums

I have on my form a drop down box with 8 options, multiple choice. There is no null value. In the Table Data Viewer results of all input fields are reported except those from the drop down box. Am I missing something?
Marg

Hi Marg,

Please drag a Handle Arrays action into the OnSubmit event and move it up before the DB Save action.

Bob

I had problems saving the results when using a Model ID.
The following code works (Custom Code in the On Submit, before the DBB Save Action)

<?php
  $form->data['Model ID of the dataset to be saved']['fieldname in that dataset'] = implode(',', $form->data['Field Name in the dropdown box']);
?>

Don't use a Model id the drop Down box.

Rob

Thank you Bob, adding the Handle Arrays action worked great with the form with an 8-item dropdown.

I did the same with another form on the same website, that has only two items in the dropdown. But it returns a result of {Preferred_Tour} which is the Field Name (and Title). Why is this please?

Hi margknox,

There isn't enough information here to be able to tell :-(

Please drag a Debugger action into the On Submit event, then submit the form and post the debug - including the 'dummy emails' results here.

Note: if you are using the Easy Wizard you can turn on Debug on the Others tab.

Bob

Found it! using the debugger. I had changed the label text, field name and field title from Time to Tour, changed the label field in the email but missed the result field.
Thank you!

I have another form with a drop down box which is not reporting results. I have a Handle Arrays element in the On Submit event before the DB Save. The attached screenprints show the Debugger result. Thank you.

Hi Marg,

Which input isn't working correctly?

I can see that your note refers to Target but that seems to be saving the submitted results. If Target is a multi-choice drop-down then you need to give it an array name Target[]

Bob

Sorry! Just realised that I neglected to refresh the email template after adding the dropdown box 🙄 All good now.