I’ve looked at similar questions/posts, and followed directions to try to sync sandbox to live and then publish, but the live website refuses to display data from the database, even though it all works in preview mode.
My website is on https://somilvinod.wixsite.com/rise50 , and I’m trying to draw info from a database after going thru interact → sign up as a mentee → thank you page (display data).
I’d greatly appreciate any help!!
Also: I think I have troubleshooted to the point that it might be because I am using a form to feed to the database. When I link a text box or something, it works fine.
If anyone knows how to make it cooperate with a wix form, let me know please!!
When you say Wix Form are you using the Wix Forms app as that does not use a database.
That will use a submissions table which you see through your Wix Dashboard.
You can read more about this here.
https://support.wix.com/en/ascend-by-wix/wix-forms
https://support.wix.com/en/article/viewing-your-wix-forms-submissions-table
If you want to make use of the databases within Wix Corvid, then you will need to make up your own user input form.
https://support.wix.com/en/article/creating-a-form-with-user-input-elements
https://support.wix.com/en/wix-data/database-collections
I made my own user input form (entirely replaced the wix form), and I’m still having the exact same issue. Any help would be appreciated!
So you have made this form here using user inputs.
https://somilvinod.wixsite.com/rise50/mentee-registration
Can we take it that on your live published site that your form submits the user inputs into your specific database fine and you are just trying to display it elsewhere?
So the database when created would have been set as form submission and the dataset connection on your page would be set to write only.
You can simply use the getCurrentItem function from Wix Dataset API to do this.
https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#getCurrentItem
getCurrentItem() by itself will get all of that data as shown in the API examples, however if you are wanting just the one field, you can simply use your code as this - $w(“#dataset1”).getCurrentItem().fieldKey;
If you are wanting to show this info on a members page after they have logged in, then you can simply add the dataset element to your page and connect it to the same database, however the dataset would need to be set as read only.
Then you can simply link a text box to the appropriate field through the dataset connection or you use the getCurrentItem() code to do it.
If you simply use a text box linked to the dataset directly, then as the member is logged in it will only show their specific data and so it will only show their own name for example.
If you are taking the users data and wanting to use it in another form and then save it into another database for example, then you would need to again use getCurrentItem() to get the specific data and then you would have to use setFieldValue or setFieldValues to save that data into the database, either using the save() function or a submit button on your page.
https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#setFieldValue
https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#setFieldValues
https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#save
You can see an example of this in this Vorbly example here.
https://www.vorbly.com/Vorbly-Code/WIX-CODE-AUTO-FILL-FORM-WITH-USER-INPUTS
Finally, have you used any code as you are posting this in the Wix Corvid Forum which deals with all code related issues.
If you have used code already, please add it in a code block.
It might be worth having a read of this Wix Support page here about Wix Dataset modes and permissions, so that you can get a complete understanding of the different options that you can have through the setup.
https://support.wix.com/en/article/working-with-dataset-modes-and-collection-permissions