Forum Discussion
ChayceDuncan
2 years agoQrew Captain
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
2 years agoQrew Cadet
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
------------------------------
- MarkShnier__You2 years ago
Qrew Legend
I think that Chayce's solution would have worked on any field that was not the key field, so thank you Chayce. Did not know that. Meanwhile just create a formula email field
[my email field in text format]
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------