I have set up a form on my website which populates a Wix database, this, in turn, is displayed on my website and is searchable. I haven’t currently got the page displayed and is set to hidden.
When I add in test data this data doesn’t appear in the database unless I manually sync the data.
Is there a way to set this up so the data just constantly syncs across?
Hello again 
.
Did not understand at all your issue.
You have a form where you put in your data.
This form populates a data-collection ok.
A repeater or a table shows the data of this populated database ok (on the same-page) ?
But then …
confused.
When I add in test data this data doesn’t appear in the database unless I manually sync the data.
Where it does not appear? (Live or in Editor?) or where?
When you add your data into your form, it should be saved in your live-database.
Perhaps some pics of your project for better understanding your issue?
sorry I’m struggling to explain this one, basically the data from the form does appear in the live version of the database as it should but on the website the data isn’t being pulled over into the repeater.
I have to sync to the sandbox before the data shows up on the website
Hi Amelia 
Be aware that there are two types of collections/databases, the first type is the one you use when you edit your website in the editor to test it, and called Sandbox , and the other one is the Live database where the data that meant to be displayed to the public is stored.
Instead of adding the entries manually to the Sandbox , you can open the Content Manager from you site’s dashboard, then select the collection that you want to add entries to, open it and add, edit or delete entries there, please NOTE that any changes you make there will affect the live site immediately without saving or publishing the website.
You should only use the Sandbox databases/collections for testing the new features you build, for example creating test entries, the benefits of having two separate collections ( Sandbox & Live ) is to allow you to add or delete entries for testing without worrying about the actual data.
Hope that helps~!
Ahmad
In addition to Ahmad’s detailed info, check also if you did not forget the → “onReady-Command” when using repeater or datasets .
I have tested this again today and it wasn’t working properly as the site wasn’t published. Once i published the site the data was available straight away, It’s now displaying correctly. Thanks
You’re welcome 