Forum Discussion
ChrisNewsome
Qrew Captain
This is great but the documentation isn't. I can't seem to find the syntax to say "if the customer name contains "http://" then..."
here's what I tried:
The "First Name" field is in there because it kept giving me an error without it, telling me it was expecting "text/textlist/userlist" but I have no idea what that is in this scenario. My "Customer Full Name" field is a formula field that combines the "last name" and "first name" fields.
------------------------------
Thanks,
Chris Newsome
------------------------------
here's what I tried:
If(
[Customer Full Name] Contains([First Name],"http://")
"Customer Names Cannot Contain web addresses.")
The "First Name" field is in there because it kept giving me an error without it, telling me it was expecting "text/textlist/userlist" but I have no idea what that is in this scenario. My "Customer Full Name" field is a formula field that combines the "last name" and "first name" fields.
------------------------------
Thanks,
Chris Newsome
------------------------------
RyanStanford1
4 years agoQrew Captain
If I recall correctly, you should just need:
If(
Contains([Customer Full Name], "http://"),
"Customer Names Cannot Contain Web Addresses.")
This way, you can look at first name and last name fields together. Might want to simply have http, to capture if it happens to be https:// as well.
------------------------------
Ryan Stanford
------------------------------
If(
Contains([Customer Full Name], "http://"),
"Customer Names Cannot Contain Web Addresses.")
This way, you can look at first name and last name fields together. Might want to simply have http, to capture if it happens to be https:// as well.
------------------------------
Ryan Stanford
------------------------------
- ChrisNewsome4 years agoQrew Captain<facepalm>
that worked perfectly... I was totally over-thinking it.
thanks!
------------------------------
Thanks,
Chris Newsome
------------------------------ - ChrisNewsome4 years agoQrew CaptainJust general FYI, since I posted this initial question, I've had 79 of these customers created, and 630 in the past 2 days. Hopefully this puts a stop to it! I'll let you know if it doesn't. Thanks to both Mark and Ryan for their help.
------------------------------
Thanks,
Chris Newsome
------------------------------