@ntlovell10
What I want, is for the client to be able to input the information into the database themselves and for this to reflect on the website at a set time.
Modifying the database directly from website editor?
Entering into a user text field on a page? Private page?
Uploading some kind of document?
These are not necessarily questions I’m asking to you, but questions you should ask yourself as how you want it to function.
Like I said, I would suggest setting up basic functionality with the database first, before trying to get the scheduler working. User input to a text box to submit to database. Another text box linked to the database for display.
You need to get the input and display working manually before you start trying to automate it.
As far as the scheduler goes, it could be calling a function that does something such as:
function MySchedulerFunction( )
{
wixData.get( ‘MyDatabase’ , ‘123’ )
.then( result => {
result.info_live = result.info_pending;
result.info_pending = ‘’ ;
wixData.update( result );
})
}
Again, suggesting to test this manually before connecting to scheduler.
Where the ‘info_pending’ is where you input the data at any time, and ‘info_live’ is the column that is linked to the website display. In this example, I used a fixed database ID, as it seems you might only need 1 row in your database and just update it every week.