Forum Discussion

HarrisonSmith's avatar
HarrisonSmith
Qrew Trainee
4 hours 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. Otherwise, populate with the referring attorney email field value. Both are lookups from two different tables. The email field for the referring attorney lookup is the key field for that table.

For some reason QB is expecting a textlist, not text. I've tried all sorts of type conversions, as well as part/split functions (since Split is what comes up under Textlist Functions, though the email field would never have more than a single value in the first place). I know this is going to be ridiculously simple in the end. 

formulas

5 Replies

Sort By
  • HarrisonSmith's avatar
    HarrisonSmith
    Qrew Trainee
    2 hours ago

    yeah I've tried converting both and either field toText while leaving the other as is. It always comes back to that same issue of expecting a textlist, despite the email field not being a combined text or anything like that. Its just a normal email field

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

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 hours 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
      3 hours 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])