Wix Database Dropdown List - It simply won't work!

Ask the community
,
1

Hi Wix community,

I need help setting up the dropdown list and getting the submit button to work. It should be simple but I cannot figure it out. I have used the database and collections before, so I have a decent understanding of how it works. But I cannot figure out how to set up a simple 3 option dropdown list and the submit button is giving me an error message (“save operation failed: DatasetError: Some of the elements validation failed in the Developer Console”).

In the wix editor & preview mode, I can see the dropdown menu options but in the published site, it is not there.

Please see the comments below for screenshots.

This is a link to the published site form: https://www.jessrightdesign.com/testimonials

Any help with setting this up would be very appreciated!

Thanks,
Jess

2

still waiting for assistance here!

3

hi jess,

i dont really understand your problem here. when i went om your website the dropdown list was displaying the 4 options in the image. is this what you were looking for ?

4

Sometimes the list shows the options & sometimes it just shows a checkmark, but the main issue is that the form doesnt seem to be working at all. I get this error message every time I press “Send”:

“save operation failed: DatasetError: Some of the elements validation failed in the Developer Console”

Any idea why this could be happening and what must change?

5

I cannot say anything like this. If you screenshot the page code then I could help

6

I’m not using any code, just the wix developer tool - database/collections. But to further explain the issue, I have supplied some screenshots of what I am seeing on my end in steps below:

1) Database Set-up (all field types are: Text)

1920×521 112 KB

2) On-site Database Collection: Each item is connected to the database. This is the backend set up for the “Names”.

1920×1173 369 KB

Backend set-up for Website URL they will simply just type in:

1920×1074 352 KB

Backend set-up for Process summary:

1920×1147 364 KB

Backend set-up for Dropdown Menu (please let me know if anything looks out of place here. This seems to be the most complicated one):

1920×1241 409 KB

And lastly, the backend setup for the submit button:

1920×1435 414 KB

With this set-up, when I go to preview mode and fill in all the fields and press the submit button, this is what happens:

1920×976 261 KB

Anyone have any idea why? I have been trying to fix this for a few days now.

7

Also, when I go to the published site (www.jessrightdesign.com/testimonials), this is what I see. No dropdown options. And the button will not submit.

1920×1513 313 KB

8

Hi,

A couple of things.

First:

  • Please delete all the text from your dropdown list column in your Database.

  • Uncheck the ‘Connect Dropdown list items’

  • Click on your dropdown list

  • Click on ‘Manage Items’

  • Enter your List One by One. For example: For the dropdown ‘I am happy with the design’ Enter the item’s label as ‘I am happy with the design’ & value as ‘I am happy with the design’
    Second:
    Check that your Dataset Permission is set to Write Only & Database Permission is set to Form Submission.

9

Hi Shaun,

Thank you for your help. I no longer have an error message so we are definitely making progress, however, my tests still do not submit properly to the database.

In the published site form, when I fill out all the information, I click submit and nothing happens. This is a screenshot of what the button setup looks like, I want the user to be taken to a “Thank you for your submission” page.

1920×1258 370 KB

Also, when I force click the button open in a new tab, the page opens but it doesnt seem to have submitted the information.

Any clue as to why this is happening?

I appreciate your help very much, thank you!!

10

Is this correct set up for the permissions?

1442×1450 152 KB

11

What is your ’ Dataset ’ permission set to ?

(Dataset box found on the page)

12

Sorry for the massive delay in my response. Did not receive an email notification that you replied.
Here’s what my on-page dataset is set to:

1100×1370 215 KB

Any issues here?

13

Still need assistance please :slight_smile:

14

Hi Jess,
I see that your form is working.
I don’t get save operation failed error.
Roi.

15

YES! The form is now working correctly! Thanks for all the help!