Discussions

Expand all | Collapse all

Generate unique email account base on fields

Jump to Best Answer
  • 1.  Generate unique email account base on fields

    Posted 28 days ago
    Hello all

    I am trying to create a Formula- email edress USSEN THE VARIABLES BELOW

    VARIABLE. 3 variable
    • first name
    • second name
    • Table ID record

    Default domain=  gmail.com

    MUCH APPRECIATE THE HELP

    Edson Gonzalez-Chavez


    ------------------------------
    Data (Administrator)
    ------------------------------


  • 2.  RE: Generate unique email account base on fields

    Posted 28 days ago
    [First Name] & [Second Name] & [Record ID#] & "@gmail.com"

    Is this what you're looking for?

    ------------------------------
    Blake Harrison - DataBlender.io
    Quick Base Solution Provider
    ------------------------------



  • 3.  RE: Generate unique email account base on fields

    Posted 28 days ago

    Thank you, that is why I have so far. however, for some reason, there is a space between the second name and record id#

    example:
    First NameSecond Name   [Record ID@gmail.com
    edsonponce  4567@gmail.com






    ------------------------------
    Data (Administrator)
    ------------------------------



  • 4.  RE: Generate unique email account base on fields
    Best Answer

    Posted 28 days ago
    Most likely, the problem lies in the data and there is a space at the end of the value in [Second Name]. To remove stray spaces, you can use the TRIM function like this:

    Trim([First Name]) & Trim([Second Name]) & [Record ID#] & "@gmail.com"

    This function will remove all leading and trailing spaces from any data in the field.

    ------------------------------
    Blake Harrison - DataBlender.io
    Quick Base Solution Provider
    ------------------------------



  • 5.  RE: Generate unique email account base on fields

    Posted 28 days ago
    it worked

    thank you so much
    Edson

    ------------------------------
    Data (Administrator)
    ------------------------------