Data_SystemAnal
4 years agoQrew Cadet
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
first name
second name
Table ID record
Default domain= gmail.com MUCH APP...
- 4 years agoMost 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
------------------------------