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 of years now.

Today, I've been hit with bots. Over 500 junk customer names (all of which include a web address, so I could use that to filter and delete) and activities have been created. I tried to figure out how to prevent this - I'd love to just stop it at the point of entry - but the only thing I could think of was an automation to automatically delete both the task and the customer when this happens. 

I wrote an automation thinking that I could simply say "when the customer name contains "http://*" then delete this activity and this record. Unfortunately that doesn't work as the automation will not fire. I assume it's because it won't look at my filtering word. I tried with and without the asterisk. Does anyone have any great ideas on this?


------------------------------
Thanks,
Chris Newsome
------------------------------

13 Replies

  • You cannot just invent you own wild card language with the *

    Just do this


    when the customer name contains "http://"




    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • ChrisNewsome's avatar
      ChrisNewsome
      Qrew Captain
      well * are usually wildcards, I had hoped that would work. :) 

      Prior to that, I had tried just "http" with no success.

      ------------------------------
      Thanks,
      Chris Newsome
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        The http should work.  Can I see you full code or a screen shot of the Automation Filter.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------