Hi,
In this article you can learn the differences between Sandbox Data and Live Data in your database collections.
Some code is required in order to make it done.
You need to add an onRowSelect event. This reference has examples of how it should look.
According to what I understand it’s better to create the form using code and not by the editor.
Here is a sample of how it should look:
- disconnect all the field connected to the dataset
- create an onClick event to the button (sample)
function submit_Click() {
const field1 = $w('#field1').value;
const field2 = $w('#field2').value;
const toInsert = {
field1: field1,
field2: field2
}
wixData.insert("yourDatabaseCollection", toInsert)
.then(() => {
$w('#yourDataset').refresh()
$w('#yourTable').refresh()
})
}
Feel free to paste your code here to consult.
Good luck!
Roi