Forums

Hi all,
​
I am using CFv6 and doing this in builder mode.
​
I have a dropdown that is pulling fields from a DB using the following in the options {var:read_data4}, and from a Load Data. This works great, records to a new DB and all. No dramas.
​
If I want to copy a second field to a text field based on the selection from the drop down what would be my best options. If it can be explained so I can build it in the dropdown or similar widget this would be great. I want to pull the email from the matching name as selected from the drop down so that once submitted the user can get a copy of the forms sent to them for records, so I can add it to the dynamic CC field.
​
Both fields are in the same DB, 'email' is the second field for the dropdown or text box. 'name' is the first field that I use in the 'Fields to Retrieve' for the Read DB function for the dropdown.
​
Thanks in advance for the help.

Hi har7801 ,
​
Usually the simplest way to do this is to use a second Read Data action in the form On Submit event using the submitted drop-down selection to identify the record to read.
​
Bob

Ok cool, I can do that. Any chance you can help me out with what to write into that action, or where in that action. I’m good at making the forms, still learning to make them work well.
​
Thanks for the reply, have a great Easter Chrono Team......

Hi har7801,
​
Please check page 20 in the CFv6 manual.
​
Bob

Will do. Thanks.

Hey All,
​
I have tried to make sense of this but Ive gone braindead.
​
Ive loaded the Read Data into the onSubmit, but now Im lost as to how to get that to read the dropdown result that draws from a DB, field is 'select1', then to get it to look back at that same DB to get the corresponding email address. Ive been over CFv6 manual as suggested but can't draw them together. If I can get this working I would love to do a How To for you so this can form a tutorial for novices like me.