Forum Discussion

HarrisonSmith's avatar
HarrisonSmith
Qrew Trainee
2 months ago

Convert Email Lookup Key to Text

I feel like I'm going insane this should be extremely easy. I'm trying to make a formula email field that simply gets populated with 1 email field (primary contact) if that's in fact filled out. Othe...
formulas
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 months ago

Your Field type should be formula email.

Can you post your formula.  It should be 

iF([primary contact email] <>"", [primary contact email], [Referring attorney email])

 

  • HarrisonSmith's avatar
    HarrisonSmith
    Qrew Trainee
    2 months ago

    Sure. When I entered what you had above, it says I can't use <> on types text or textlist. The formula field is already a formula - email field, though I've tried with both formula email and formula text to no avail. 

    if([Primary Matter Contact - Email] <> "", [Primary Matter Contact - Email], [Referring Troutman Attorney (ref) - Email Text])

     

    • MarkShnier's avatar
      MarkShnier
      Qrew Cadet
      2 months ago

      .

      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        2 months ago

        I'm Away from my computer right at the moment on the subway, you can try this, although I didn't think it would be required this way if this does not work, can you please post your formula

         

        if(ToText([Primary Matter Contact - Email]) <> "", [Primary Matter Contact - Email], [Referring Troutman Attorney (ref) - Email Text])