HELP: Adding more than 12 form fields with Corvid

Ask the community
,
1

Hello! I’m trying to set up a form connected to a database in Wix using Corvid. According to DataSet settings, I can only have up to 12 form fields. My form is much longer than 12 fields Is there a way that I can change the limit on inputs?

I appreciate any input (no pun intended!) that you give me.

Thanks, Tobi

2

Hi there :raised_hand_with_fingers_splayed:

You’re talking about Wix Forms, which allow you to add a specific number of fields unless you have a premium Ascend subscription, I suggest that you add regular fields and connect them to your dataset.

If you need further help feel free to reply back.

Ahmad

3

Thank you for answering! Would you mind taking a look at my form and telling me if I need to upgrade? Or please let me know if there is a better way to get it to work.

The form is at glazeannarbor .com/custom-palette-form
(For some reason, I can’t post a link here but if you copy and paste the address then delete the space before .com it should work)

Thanks!

4

@glazeannarbor It looks like it’s not Wix Forms …

You can add as many fields as you want, if the dataset can’t handle that much of data the only option left is to use wix-data to bind the data and save (submit) the form with code.

5

@ahmadnasriya Thank you again for your help! It seemed that the easiest way to make the long form work was to upgrade with an Ascend plan, which I did, but the form will still only allow me 12 inputs. I created the form in Wix and connected it to a datasheet using Corvid. Is there something else that I’m supposed to be doing?

6

@glazeannarbor I think it has nothing to do with the plan, my guess is that the dataset can’t handle all these elements connected to it, so use the insert() function instead.

let item = {
    name: $w('#nameInput').value,
    email: $w('#emailInput').value,
    / * ....
    other properties */
}

await wixData.insert('collection', item).then(() => {
    // Data was saved!
}).catch(err => {
    // Handle the case where the insertion failed
    console.error(err);
})
7

Ahmad is right, it really has nothing to do with the plan.

It took me a little while till I realized what the issue is. You got a little confused between collection fields and items…

  • An item is the same as a database collection row - that is, in your case, the data for one form.

  • A field, is a piece of data (eg. a selected color).

So, believe it or not, you don’t have a problem. Life should be so simple. All you need to do is to continue connecting all of your checkboxes with the appropriate field in the dataset.

8

Yisrael. Thank you for your explanation. That definitely makes things clearer. However, I can get my form to work if I have 12 or less active data fields. As soon as I add a 13th, it no longer works. If its not connected with the item limit, why is it doing this? There is nothing else that I’m doing to the page. I simply activate or deactivate one field and it works or stops working.

Also if there is a better place for me to be troubleshooting this function, please let me know. This seems to be the only place in the Wix help universe that I’m able to interact with an actual human.

Thanks again for your help!

9

@glazeannarbor There really are no limits to the number of fields that can be connected.

What do you mean by “stops working”? What does it do when it’s working? What doesn’t work?

10

When I have 12 or less field connected/active on my form, I can go to the PREVIEW mode, fill out those fields, hit SUBMIT and the screen goes to my ‘Thank you for your input’ page. The data that was submitted will then show up in the database that I created on Wix. When I make an additional field active then go to PREVIEW mode, fill out the fields and hit submit, it does not go to the ‘Thank you’ page and the information is not then reflected in my Wix database.

11

@ahmadnasriya Thank you for the feedback. I have not done a lot of coding myself (except for some simple Javascript). Is there a tutorial that you could refer me to or the coding of a form page that might help me understand the coding that you provided?

When I open the coding for this page, this is what I see:

3008×1848 616 KB

12

@glazeannarbor One thing I see is that you have a bunch of checkboxes marked Required .

846×912 104 KB

All of the checkboxes for the colors in an entire column, starting with: lemon, sky blue, lilac, and so on down to the bottom of the form are set to Required .

I unchecked Required for all of those checkboxes (my changes are not saved in your site), connected a few more fields (checkboxes) to the dataset and was then able to successfully save the form in Preview.

This is not a code question and it is really more of an issue with the Editor, screen elements, or the Database. If you need further details or clarification, I would recommend contacting Wix Customer Care , as they definitely know better than I do.

13

You’re right!!! Thank you! I think that solves my problem.
Best, Tobi

14

I have the same problem. Has anyone found a solution?

15

@secretary57610 If you have the “same problem”, then yes - a number of solutions were provided in this thread.

If you have another or similar problem, then please explain what you are doing, what works, and what doesn’t. Share your code in a code block so that we can see what you are doing.