Forum Discussion

EdGrandinetti's avatar
EdGrandinetti
Qrew Member
5 years ago

Parse an email from multi select list for notification

Need help parsing email address for a multi-select list. I would like the list to display name along with the email.  Current list display: jsmith@quickbase.com j.doe@anotheremail.com Desired li...
Formulas and functions
NotificationsEmail
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
Just to clarify, you have a Multi-Select Text field that you currently have showing email addresses and you would like it to show the Name and Email address instead. In addition, you would then like to modify your current formula to pull out the first email address from your newly formatted list. Is this correct?

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
  • EdGrandinetti's avatar
    EdGrandinetti
    Qrew Member
    5 years ago
    I am able to modify the multi-select field to add the names next to the emails, ie; (john smith - jsmith@qb.com). I just need to modify the email formula to parse the emails from the "-" (dash) so the notification will continue to identify the email only and correctly send. 

    Thanks!


    ------------------------------
    Ed Grandinetti
    ------------------------------
    • BlakeHarrison's avatar
      BlakeHarrison
      Qrew Captain
      5 years ago
      Ok, so I think I would do it something like this:
      Trim(Part(SearchAndReplace($EmailList,"-",";"), 2,";"))​

      ------------------------------
      Blake Harrison
      bharrison@datablender.io
      DataBlender - Quick Base Solution Provider
      Atlanta GA
      404.800.1702 / http://datablender.io/
      ------------------------------
      • EdGrandinetti's avatar
        EdGrandinetti
        Qrew Member
        5 years ago
        That didn't work. Might help if I explain that the email formula is unique to each email.
        ie., 
        Trim(Part($EmailList, 1,";"))
        Trim(Part($EmailList, 2,";")), etc.
        corresponds to the 
        [Email 1]
        [Email 2]
        in the notification.
        I have over 20 emails that a user can select from.

        Thanks!

        ------------------------------
        Ed
        ------------------------------