Forum Discussion

ChrisNewsome's avatar
ChrisNewsome
Qrew Captain
4 years ago

BOTs are killing my contact form on my website...

I use a contact us form on our website which automatically creates a customer in Quick Base. Then an automation fires to create a task for someone to contact them. This has worked great for a couple o...
Formulas and functions
Pipelines
ChrisNewsome's avatar
ChrisNewsome
Qrew Captain
It basically fills in the "new customer" form in our app. Under form rules, I can't use "contain", it's either <,>, or =. Is there another place/method I could do this? Can I restrict the name from having that code?


------------------------------
Thanks,
Chris Newsome
------------------------------
RyanStanford1's avatar
RyanStanford1
Qrew Captain
4 years ago
Yes, if you go to the advanced settings of the table in QB... I'd imagine you have it named "Customers" or something to that effect. There's a section towards the bottom regarding Custom Data Rules.

https://help.quickbase.com/user-assistance/custom_data_rules.html is the QB Documentation regarding it.

I'm not sure if it'll work via API, or if it's strictly from a native QB form, but it's worth a shot.

------------------------------
Ryan Stanford
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 years ago
    Custom Data Rules operate at the database level.  So API's will need to comply or they will error out and fail.  This would be what you want.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • RyanStanford1's avatar
    RyanStanford1
    Qrew Captain
    4 years ago
    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
    ------------------------------
  • ChrisNewsome's avatar
    ChrisNewsome
    Qrew Captain
    4 years ago
    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:
    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
    ------------------------------
  • ChrisNewsome's avatar
    ChrisNewsome
    Qrew Captain
    4 years ago
    <facepalm>
    that worked perfectly... I was totally over-thinking it.

    thanks!​

    ------------------------------
    Thanks,
    Chris Newsome
    ------------------------------
  • ChrisNewsome's avatar
    ChrisNewsome
    Qrew Captain
    4 years ago
    Just 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
    ------------------------------