Skip to main content
Participant
May 16, 2007
Question

Developer Toolbox SendMail issue

  • May 16, 2007
  • 2 replies
  • 394 views
Hi all
I need to show the name of a chosen option that is from a dynamically generated dropdown in an input form.
These input details are emailed.
All this works but I get the integer value of the foreign key not the name
I understand the I need to set a new recordset filtered by the posted value from the form but for the life of me I cannot get the name from the foreign keyed table to show in the received email???
Can someone explain how to do this please as its driving me potty!
This topic has been closed for replies.

2 replies

Günter_Schenk
Inspiring
May 16, 2007
Hi Ian,

>>
I understand the I need to set a new recordset filtered by the posted value from the form
>>

it seems that the email body contains a reference to the form value, like (ADDT "dynamic data" format now) {POST.fieldname} and not the value derived from the new SELECT name FROM table WHERE user_id = dropdown_fieldname - recordset ?
May 16, 2007
Is the form posting back to the server or is the submit button set to send the e-mail? If your posting back to the server, you can making a simple page where the body content is what you want in the e-mail.

That should make it easier to debug. Once you have the page generating the text you want, if should be easy to get the e-mail to use the same text.

Hope the helps,
Chris
Günter_Schenk
Inspiring
May 16, 2007
Hi Chris,

I think that he´s using ADDT´s "send email" feature -- are you, Ian ?