Skip to main content
Solved

Generate unique email account base on fields

  • August 31, 2020
  • 0 replies
  • 73 views
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)
------------------------------

Best answer by BlakeHarrison

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
------------------------------
This topic has been closed for replies.

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

Is this what you're looking for?

------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------
Terms & ConditionsAccessibility statement