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

Hi - unfortunately, that's not possible. That's what I first thought to do.  On realizing that's not possible, I thought I would create a secondary field that 'equals' this first one, but IS an email-formatted field.

I thought maybe I could switch out the 'key' field and then switch it back, but I don't want to muck about with all of the linked tables too much - my team is really happy with how this build is going, and this is a relatively minor need.
Thanks in advance for any thoughts or recommendations!


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