On my site, I have a form for customers to fill out to provide me with their Name, address and email. The form functions fine, and when information is entered, it says submitted and shows up into the sandbox when I press sync from live. But no information is showing in the live database. All of the fields are there, but there is no data either in editor or on the dashboard. I was under the impression when the form is filled out, it will automatically show in the live database. Am I incorrect? Do I have to sync the info everytime I need to access it?
Are you sure you have set the right Permissions on the dataset (like Read/Write)? And you do not have to sync every time. When you Publish, all collection schema are updated to the live db, when you sync, you just copy the content from A to B or other way around.
So if my customer fills out tthe form, it should be immediately available for me to read on the live database on the dashboard correct?
@howorland , Have you figured this out? If you’re still having problems please post the URL of your site. Only authorized Wix personnel can get access to your site in the editor.
Good morning. Unfortunately we have not resolved the issue. The site URL is www.Oogiesgaminglab.com
The form is in the membership page section. Whenever the form is filled out, the only way I can view the info is by going into sandbox and selecting the option to overwrite collection from live. It will show up in the sandbox as updated then, but still there is no info in the “live” database.
I don’t understand. If you see it when syncing from Live, then it’s in Live.
How are you running the site? In Preview or Live?
What is needed in order to fill out and submit the form?
The site is running live, not in preview.
My customers have to enter their Name, Address and Email. They then press submit. If I go onto the dashboard to view the live database, there is nothing there. If I go into editor and view the live database, there is nothing new there. The only time any New information shows up, is if I am in sandbox and I Sync from the live collection.
I was under the impression that when the form is filled out, the data would immediately show up in the LIVE database on the dashboard. It is very annoying to have to go into the editor and sync every time I need the updated info.
When I sync from live, there are 27 entries so far. But in the live database tab, there are 2
Where is the form? What page? How is it filled in?
@yisrael-wix The form is on the Retromembership update page. So a customer must sign up for the page and on their profile page, provide us with their info. We then use that info to ship their packages.
@howorland The form is an update form, and the dataset is read-write:
The form (together with the dataset) updates the collection. That means that the current record of the dataset is modified and then updated in the collection. It does not create a new record. This is why you are not getting new records. The form is simply updating the current record of the dataset. To create new records, you need write-only permissions on the dataset, or you need to create a new blank item .
Ok! What would the best and easiest route be to take to resolve this issue? If you can assist, if not I will begin my adventure.
You’ll need to build separate submit and update pages. Use the tutorial How to Build Your Own Members Area Using Code as a guide. You’ll find a profile page (that would be your submit page) and an update page (your update page). You should be able to get what you need from this resource.
Good luck,
Yisrael
@yisrael-wix Thank you for the help. One last question, when in the editor, it says that my live database is read only, the permissions tab is grayed out so I can not change it. How would I change that permission?
@howorland Permissions are only changed in the Sandbox. The changes are then applied to the Live database when you publish.