Forum Discussion

ChrisNewsome's avatar
ChrisNewsome
Qrew Captain
5 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
5 years ago
The http:// did work. It's already killed 27 in the last hour. thanks as always!

Any ideas how I could prevent it at all? I think my automation might end up running hundreds of times this week. I would love to make a form rule or something but that didn't work either.

------------------------------
Thanks,
Chris Newsome
------------------------------
RyanStanford1's avatar
RyanStanford1
Qrew Captain
5 years ago
You should be able to add some data validation either to the form or to the table itself. Make sure the fields have valid data, ei: Name doesn't contain "http://" and whatever other criteria you're looking for. Is the form/webpage your own, or is it a code page within QB?

------------------------------
Ryan Stanford
------------------------------
  • ChrisNewsome's avatar
    ChrisNewsome
    Qrew Captain
    5 years ago
    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
      5 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
        Icon for Qrew Legend rankQrew Legend
        5 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
        ------------------------------