2. PHPRunner General questions
  3. [SOLVED]  Sending Emails using Display Values instead of Field Value
This topic is locked
[SOLVED]

 Sending Emails using Display Values instead of Field Value

 		6/29/2020 02:11:25
PHPRunner General questions
need2sleep authorDevClub member

When creating an "after record added" event and using runner_mail, is it possible to send the display value instead of the field value variable?
For example, if I have "Location" setup through lookup wizard, I will receive the "Link field" value instead of the "Display field" value.
$msg.= "Name: ".$values["Name"]."\r\n";

$msg.= "Location: ".$values["Location"]."\r\n";
Location will show up as 1,2 instead of USA, Canada etc.
Do we have to perform a cross reference for each field or is there a simpler way?
mbintex 6/29/2020

Guess you will have to do a DBLookup for the value you want from the related table.
Sergey Kornilov admin 6/29/2020

See example #2 here:

https://xlinesoft.com/phprunner/docs/data_formatting.htm
need2sleep authorDevClub member 6/29/2020



See example #2 here:

https://xlinesoft.com/phprunner/docs/data_formatting.htm


Perfect thank you! I didn't see this in the manual. May I suggest adding to "See Also" section.