Sending mail from a separate list dont work

[mattsh]

Hi!

Have a separate list (phone book) for our staff.

I make a new list and add db-join field for the staff to select name and a cdd to collect their mail (from phone book).
The form looks fine with correct data, but I don't manage to send at mail via the forms emil plugin. Sending mail work if I add a hard coded email in the to field. I guess that as the mail field is joined (ccd) only the id is used and not the real mail.

How to solve this?

Regards
Matt
Joomla 3.8.5
Fabrik 3.8

 

[cheesegrits]

You'll need to use the "Email to (eval)" setting to retrieve the email from your table, using the foreign key in your join or CDD element in a query.

There's an example in the wiki:

http://fabrikar.com/forums/index.php?wiki/email-form-plugin/#email-to-eval-example

-- hugh

 

[mattsh]

Thanks!

Will look at this.

Matt

 

[mattsh]

After some testing, sadly I can't make it work, no email is sent from the form.

Tabels
Staff:
jos3_fb_staff___id
jos3_fb_staff___name
jos3_fb_staff___email

Registraton:
jos3_fb_registration___name_id (join elemnt)
jos3_fb_registration___email_id (CDD elemnt)

And on the form a emil-plugin with this code:

$myEmail = '';
$staffId ='{jos3_fb_staff___id_raw}';
if (!empty($staffId)) {
   $db = JFactory::getDbo();
   $query = $db->getQuery(true);
   $query->select('email')->from('jos3_fb_staff')->where('id = ' . (int)$staffId);
   $db->setQuery($query);
   $myEmail = $db->loadResult();
}
return $myEmail;

Regards
Matt

 

[troester]

I$staffId ='{jos3_fb_staff___id_raw}';

f you are on your registration form you'll need {jos3_fb_registration___email_id_raw}

 

[mattsh]

Thanks Hugh!
It works perfect now!

Regards
Matt