Is there a way to automate a button click?

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
I have code that I can execute with a button click, but I need it to run in the middle of the night. Can something like this be done?
Photo of Tyler Parker

Tyler Parker

  • 714 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
We now have Automations which can run on a schedule (well run in the middle of the night) , but they are limited in the types of steps they can do.  They can edit records, delete records, add records and Run imports.

But Quick Base has big plans for Automations, so I expect to see continuing development in this area.
Photo of Jason

Jason

  • 1,012 Points 1k badge 2x thumb
Even if you ran on a code page and put a schedule in the code you will still need a trigger to activate the code, like pressing the button during the day.  Dan Diebolt would be the person to have an answer to this.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,462 Points 20k badge 2x thumb
I don't know how complex your script is but if it is simple and only edits, deletes, adds or import records it might be possible to implement the functionality as an Automation. But if the script does more complex processing you need a platform from which that script can run. You can run the script from the browser itself (if you leave the computer on and browser open) using the Crontabs extension

Crontabs Chrome Extension
https://chrome.google.com/webstore/detail/crontabs/abhmbcedbojnghofcfmnageegmkmpkac

or you can employ some type of server solution. 

One attractive solution is to use a FaaS (Function as a Service) service such as Amazon's Lambda, Microsoft's Azure Function, or Google's Function. These FaaS services are considered serverless as all you do is upload the function itself and supply minimal permissions and configuration (you don't have to maintain or configure the server itself). In this case you would select Node as the platform as it can run you existing JavaScript in the FaaS platform.



(Edited)