How to update a dataset at a set time.

Ask the community
,
1

I’m looking to add some code to a website I’m creating that will update a dataset at a set time.

The idea is, that I will be able to upload information to a database, and it won’t appear on my site until a set time. (weekly)

I believe that the best way to do this is through code. Just not entirely sure on how to implement this.

Thanks in advance.

2

Hi Noah,

You can use the job scheduler to setup a function to run at a set time.
Create a backend function that will take the info out of the database and into the frontend page. Then call that function from your job scheduler.

Job Scheduler info:

If the info displayed is linked to the database, you could use 2 databases. For example, ‘DB_Pending’ and ‘DB_Live’. Write your information into the ‘Pending’ DB, and then using the job scheduler copy over anything in Pending into Live. Depends on your application of course.

3

Cheers for that! Really helpful. I’m setting up a website for a newsletter to appear every Sunday at a set time. Was just wondering if I could set it so I could upload the information and documents before the Sunday, and it would update automatically on the Sunday for me.

I’ll take a look at the job scheduler stuff and hope that will work.

Cheers!

4

Sorry to bother. I have set up the Job Scheduler command. Just wondering if there is a specific function that I need to use for the database. I take it I would need to write some code in a .jws file. If so, what function would I need to write.