Data type conversion to e-mail fails
I have a regular table with a column data type:email, and a custom formula where I basically make an email from another column clickable and add a subject line with this formula:
concat( "user_email",'?subject=Custom Subject Text')
This works fine in the table view. When I click the link it opens a new message in outlook with the email and subject filled out.
However when I clean up the table a little by creating a Query table, this column is converted into the data type 'Plain text'. If I go to change data type and try to make it into type: e-mail, I get the following error message:
Data type conversion aborted since the existing data in the column Email is not compatible to the data type E-Mail.
So currently the email links are not clickable in my Query table although they are in my original table. How can I remedy this so it works the same as in my regular table?
Thanks!