I have a form with a dropdown menu populated from a recordset. The dynamic menu value is set to the ID column and the label is set to the description column of my database table. I have set it up this way because I have an insert record on this page and need to submit the ID to the database table field.
My universal email behaviour is set up to echo the form fields from my form. Unfortunately this means it is echoing the value from my dropdown menu. The value in this case is the ID. so instead of getting the description e.g.
I am getting the ID e.g.
So my email is looking something like this e.g.
body: thank you for enquiring about 1 today
I need it to say;
body: thank you for enquiring about canada today.
I am not sure how to echo this because I am binding the form element which is passing the value, which is my ID column.