submit to connection overwrites instead of writes

I see that for my dataset on a page I am using that has form fields that I placed and configured, meaning I did not create the page as a form from the get-go, the dialog box selection for the dataset of WRITE does not exist, only READ, and READ-WRITE. Therefore when submitting, which DOES work btw as I can see the table change immediately which I placed also on to the form page, it is overwriting my existing content in my collection. I want it submit to ADD a row to the collection table and have that show up on my table on the form page. Also, the confirmation successful upload is not showing up on the form page, even though it does in preview. Comments?

I’m guessing you don’t have a write option on your dataset because it is a dynamic page dataset. You’ll need to use a regular dataset to get the write option.