2. PHPRunner General questions
  3. Send email with new data - How to send name, not record #
This topic is locked

Send email with new data - How to send name, not record #

 		9/14/2015 2:27:52 PM
PHPRunner General questions
R
 ringlis1 author

I have set up Send email with new data, which is does. However, I would like it to email the name of the item instead of the recordID. On the add form, I use a lookup query to display the name of an Item.
I did create in the query designer a SQL statement that will display the name, and I added this field name to the send email code, but, it appears it only sends what is entered on the form.
So how can I get the email to send the data with the linked name?
The name and equipment at the bottom of the form, were just added to test
Sergey Kornilov admin 9/14/2015

In PHPRunner 8.0 we have added an API to access both Link field and Display field values of Lookup wizard in events. Check this: http://xlinesoft.com/phprunner/docs/data_formatting.htm
emendoza 9/14/2015

JetSkiBum, To understand your question, you could fully show the fields in your query, especially tables "EquipmentService" and "Users". Also, show the link fields of two tables in your query.