Forum Discussion

JenniferJuhasz's avatar
JenniferJuhasz
Qrew Cadet
2 years ago

Convert a 'text' email address field to 'Email' format

Hi -  Is there a 'ToEmail' function of some form?  I have a list of email addresses, but it's the Key field from a sync'd table (not editable) and it's 'text' format.  I want to create a formula em...
ChayceDuncan's avatar
ChayceDuncan
Qrew Captain
2 years ago

You can simply change the field type in your sync table to Email without affecting the sync. The setting to make it text is just defaulted but you're able to change it without affecting the sync. 



------------------------------
Chayce Duncan
------------------------------
JenniferJuhasz's avatar
JenniferJuhasz
Qrew Cadet
2 years ago

Update - this was far easier to resolve than I thought.  Feeling rather a bit embarrassed - the solution was so simple it escaped me! LOL - I just created a new formula Email field and entered the field name as the formula.  That's it.  Sorry to waste a bit of bandwidth here!



------------------------------
Jennifer Juhasz
FamilySmart
BC, Canada
------------------------------