Formula in Case

[peterberlin]

Hello
At "E-mail to case" I try to evaluate the e-mail address of the sender with formula. Unfortunately my code does not work:

ifThen(string\contains(inboundEmail.emailAddress, '.de'), country = ' Germany');

Does anyone have a tip that might help me
Thanks.
Peter

[Maximus]

Hi Peter,
I've tested it and it works for me. What type of field for the 'address' field do you use? I am using the 'address' type and called my field 'address'. So in Formula I use 'addressCountry'. Check in the attribute list how your address field is properly defined.

[peterberlin]

Thank you, Maximus,
the field "country" is a custum one selection field. One option of this field is "Germany".
Probably you cannot describe a selection field like this.

[yuri]

Hi Peter,

Is 'country' is a field in Case entity type?

[peterberlin]

Hi Yuri,

Yes. But that's not it. I've also tested other fields.
This code is not working:
string\contains(inboundEmail.emailAddress, '.de')

I want to check the incoming e-mail (e-ail to case) which TLD it is.

[yuri]

Try to use record\findOne

// find first email related to case
$id = record\findOne('Email', 'createdAt', false,
    'parentType=', 'Case',
    'parentId=', entity\attribute('id')
);

// if found
ifThen($id,
   // get email address
   $emailAddress = record\attribute('Email', $id, 'fromEmailAddressName');
   $emailAddress = string\lowerCase($emailAddress);

   // check TLD
   $isDe = string\substring($emailAddress, -3) == '.de';
   ifThen($isDe,
       entity\setAttribute('country', 'Germany');
   );
);

[peterberlin]

Hi, Yuri,
Thank you very much. But the code didn't work.
I put it into a workflow (record new).

[peterberlin]

Hi, Yuri,
I put your code in the Entity and it works there.
Thank you very much.
You can also use string\contains.
I have to check the sender name as well as the e-mail address. What is the name of the variable? fromEmail???????????????

[yuri]

It's the sender name in the code.

 
 $emailAddress = record\attribute('Email', $id, 'fromEmailAddressName');

If you need "To" name it's more tricky to fetch it.

[peterberlin]

Thanks. I'll use it as far as it goes. It's already a big help.