Make Record Producer Watch List field "email address only"

AdamUMC
Giga Guru

Hi there,

I have made an Record Producer form for our Service Portal.
One of the fields on this form is the "Watch List" field, an "Single Line Text" type field with reference/map to the real "Watch List" field (screenshot 1).

People can write down several email addresses, seperated by a comma. This goes very well and the entered addresses come succesfully into the backend Incident and can be used for outbound (Incident) emails (screenshot 2 & 3).

Now I got the problem that plain text can also be entered within this Record Producer field and when you use comma's, each sentence (from start to comma) comes separately in the backend Incident. As you can imagine, these sentences are no valid email addresses and cannot be used for any outbound emails (screenshot 4, 5 & 6).

How can I make this Record Producer field "email address only", with the possibility to enter several email addresses?

I've tried to change the "Type" of the Record Producer field from "Single Line Text" to "Email" (screenshot 7). This works, but unfortunately for only one email address, while I want to be able to enter a few email addresses.
Separating email addresses by comma or a semicolon (even with or without spaces) does not work (screenshot 8 to 11).

Please see the screenshots below for more information. Thanks in advance for any useful tips!

Screenshot 1:

AdamUMC_0-1702980713199.png

Screenshot 2:

AdamUMC_8-1702981068955.png


Screenshot 3:

AdamUMC_9-1702981124936.png


Screenshot 4:

AdamUMC_10-1702981191714.png


Screenshot 5:

AdamUMC_11-1702981224691.png


Screenshot 6:

AdamUMC_12-1702981264114.png


Screenshot 7:

 

AdamUMC_2-1702980817163.png


Screenshot 8 - 9 - 10 - 11.:

AdamUMC_3-1702980863925.png

 

AdamUMC_4-1702980888482.png

 

AdamUMC_6-1702980937884.png

AdamUMC_7-1702980968439.png

1 ACCEPTED SOLUTION

Peter Bodelier
Giga Sage

Hi @AdamUMC 

 

You could leave the variable as type single line text and use a regex to validate if only correct email addresses have been filled in.

 

 

(([\w\.\-_]+)?\w+@[\w-_]+(\.\w+){1,}[,\s]*)+

 

PeterBodelier_3-1703002059754.png

PeterBodelier_0-1703002231626.png

 

 

PeterBodelier_1-1703002030187.png

PeterBodelier_2-1703002048724.png

 

 


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

View solution in original post

7 REPLIES 7

Peter Bodelier
Giga Sage

Hi @AdamUMC 

 

You could leave the variable as type single line text and use a regex to validate if only correct email addresses have been filled in.

 

 

(([\w\.\-_]+)?\w+@[\w-_]+(\.\w+){1,}[,\s]*)+

 

PeterBodelier_3-1703002059754.png

PeterBodelier_0-1703002231626.png

 

 

PeterBodelier_1-1703002030187.png

PeterBodelier_2-1703002048724.png

 

 


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

Thank you! I will try this tomorrow and report if it's OK and ofcourse thereafter accept the solution!
Thanks again!

Thank you @Peter Bodelier! This works very well!

BTW, what's the difference between this regex and the other one, that's out-of-the-box present?

AdamUMC_0-1703161397028.png

This one is for just only one email address?

Yes, the OOTB one is just for 1 address.


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.