Email Field ID instead of Lookup

super20g · Post by **super20g** » Thu Feb 26, 2015 4:23 am

Hello, Some of the fields that are being sent in emails such as when a record is added or deleted shows the ID rather than the lookup value.

i.e. 'Provider: 12' instead of 'Provider: MyProviderNameHere'.

So using:

$Email->Content .= "\nProvider:\t" . $Args["rsnew"]["provider_info_ID"];

Gives me 12.

I have tried multiple iterations such as:

$Email->Content = str_replace("\nProvider:\t" . $Args["rsnew"]["provider_info_ID"], "\nProvider:\t" . ew_ExecuteScalar("SELECT provider_name FROM provider_info WHERE ID ='" . $rsnew["provider_info_ID"] . "'"), $Email->Content);

But I can't seem to get it just right. This seems like this would be a common occurrence, could anyone show me how to accomplish this task?

mobhar · Post by **mobhar** » Thu Feb 26, 2015 9:13 am

Try this:

$Email->Content = str_replace("\nProvider:\t" . $Args["rsnew"]["provider_info_ID"], "\nProvider:\t" . ew_ExecuteScalar("SELECT provider_name FROM provider_info WHERE ID ='" . $Args["rsnew"]["provider_info_ID"] . "'"), $Email->Content);

super20g · Post by **super20g** » Fri Feb 27, 2015 12:32 am

Thanks, that did the trick!

So my finished solution is:

$Email->Content .= "\nProvider:\t" . $Args["rsnew"]["provider_info_ID"];
$Email->Content = str_replace("\nProvider:\t" . $Args["rsnew"]["provider_info_ID"], "\nProvider:\t" . ew_ExecuteScalar("SELECT provider_name FROM provider_info WHERE ID ='" . $Args["rsnew"]["provider_info_ID"] . "'"), $Email->Content);

In order to swap the ID with a lookup value. Anything but elegant, but it works... If anyone comes across a more proper solution, please feel free to post it.