User Input Creates Data Collection Columns

Discussion Ask a question
,
1

Hi,

I was wondering if there was any way that I could have a user form dynamically add columns to a data collection based on the input that they provide.

For instance, I would like to assign judges to rate specific items on a site, but I would like a user to assign the judges. I won’t know how many judges will be required for each item. Could the user continue to add new judges to an item, and then each judge will be added as a new column in the data collection (ideally with a generic tag e.g. Judge 1, 2, 3…).

If this needs to be done in js, that’s fine, I just haven’t found anything in the API about adding columns to a data collection.

Thanks in advance for any help.

2

You have to add the fields to the dataset yourself.
https://support.wix.com/en/article/adding-and-setting-up-a-dataset

You can also give members different roles too so that certain members can access a page and do something on it. This will be your best option for Judges to rate something so that each Judges inputs can go into a specific field of your dataset collection.
https://support.wix.com/en/article/creating-member-roles-6943237
https://support.wix.com/en/article/managing-your-member-roles
https://support.wix.com/en/article/changing-the-permissions-of-a-member-role
https://support.wix.com/en/article/creating-members-only-pages-596999

Plus, you can also add site contributors to your website, however note that they will have access to the website itself.
https://support.wix.com/en/article/about-roles-permissions-contributors
https://support.wix.com/en/article/inviting-site-contributors
https://support.wix.com/en/article/contributor-roles

3

Thanks givemeawhisky,

This is the answer I expected, but not what I was hoping for. I knew I could add data columns by myself for potential future expected data, but I’m guessing there is currently no way to have a user submit data that adds columns to a collection based on content.

In the simple example I gave above, if I had 3 judge columns in my collection, but a user wanted 4 judges, they would be unable to add a 4th judge. I could, of course, create 9 judge columns, but then I would have superfluous empty columns. Does that make sense?