Extract From Name and From Email from the Email On case creation

[abhilash.kumar.niit]

Hi i want to get from name and from email from the email when i create case from the email . How can i do that at the time of case creation.

Note: I am using email to case.
i have two custom columns on case entity
cWebName ==> here i want the name of email sender
cWebEmail ==> here i want the email id of the sender

Any help is highly appriciated.

[emillod]

There is a field called originalEmail in Cases. You can take id of the originalEmail and fetch params
Probably you can do it through formula.

Alternative approach would be to search through formula findOne record - EspoCRM Documentation in Emails entity record which contain this case as a parent field.

[abhilash.kumar.niit]

The field "originalEmail " does not have any value in this it has blank value

[emillod]

abhilash.kumar.niit it's probably notStorable field. Have you tried second way?

[fernando.giacomino]

Look at this post: https://forum.espocrm.com/forum/gene...ontact-to-case
I´ve found that email-to-Case functionality check contact info in crm database, then attach this contact to new case. Maybe you don't need to create extra fields in Case, just rename contact data on it, or first create contact on case creation, then fill your custom fields with contact data.