Solved
Generate unique email account base on fields
Hello all
I am trying to create a Formula- email edress USSEN THE VARIABLES BELOW
VARIABLE. 3 variable
Default domain= gmail.com
MUCH APPRECIATE THE HELP
Edson Gonzalez-Chavez
------------------------------
Data (Administrator)
------------------------------
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)
------------------------------
- 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
------------------------------
