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
      ------------------------------
      • BlakeHarrison's avatar
        BlakeHarrison
        Qrew Captain
        5 years ago
        The formula should still work, but you would need to increment by 2 instead of by 1 for each email address that you need to pull out. So:

        Trim(Part(SearchAndReplace($EmailList,"-",";"), 2,";"))​ = [Email1]
        Trim(Part(SearchAndReplace($EmailList,"-",";"), 4,";"))​ = [Email2]
        etc

        Without knowing how you're using these or how your application is structured, have you thought about having these Emails as a separate table? It would require another table to act as a Many to Many between the Emails and the existing table, but you would have more flexibility in the future. You could also still pull the email addresses up through a Summary field.



        ------------------------------
        Blake Harrison
        bharrison@datablender.io
        DataBlender - Quick Base Solution Provider
        Atlanta GA
        404.800.1702 / http://datablender.io/
        ------------------------------