Emails in a textfield

[animax]

Hello, I have the following concern:

We have numerous text fields in an entity. We fill this entity with data by importing it. A text field contains an email address. I would like to be able to send an automatic email to these email addresses via workflow.

The problem is that Espo does not accept text fields with an email address in workflows.

Do you have a workaround for me on how I can convert the email from the text field into a valid email?

Important: The emails must be imported into a text field when importing. I cannot create a contact etc. where emails are saved. It has to remain a text field.

[shalmaxb]

It will not work in a textfield. What you can do, is to insert the email field type (as used in contacts, not available in admin gui) into your custom entity json-file.
The code is:

"emailAddress1": {
"notStorable": true,
"type": "email"
},

Then you rebuild and clear cache, go to your entity in admin and refresh the field list. Then there should appear a field named emailAddress1, give it a label and put it into your layout. It appears there like the multiple email field in contacts and when you click on an inserted email-address, it opens the Email Client of espoCRM.

It is kind of a hack and I do not know, if this could cause problems anywhere and also I do not know, if you will be able to map this field on importing.