CMS referenced field to dropdown value option

Hi, im new to the Wix/EditorX system and now designing a new site . I’ve successfully setup 2 databases and a dynamic pages to display the content. I’m want to add to a Referenced Field within the Testimonials database to allow site visitors to add Reviews and then display them.
Can this be done?

Any help would be greatly appreciated.

2 Databases.

  • Products
  • Testimonials

Products - Read permissions

  • Products Title - title
  • mainImage - mainImage
    etc.

Testimonials - Write permissions

  • Name - title
  • Testimonial - testimonials
  • Product - product (Referenced field with Products Title (title)

Page has #productView, #testimonialView, and #addTestimonial section on page

On #addTestimonial section

  • #nameInput (Text)
  • #productSelector (Dropdown)
  • #testInput (Text)
  • #submit (button)

Yes, it’s possible, but I don’t think you can do it exactly the way you’re doing it now. You will need to use some Velo code.

I would use the datasets to display the info, then insert and insertReference to insert new feedback

Hi Simen,
Thanks for steering me in the right direction. I think you’re right, it’ll need to be coded in. I had a look at those links you’ve provided and will have a go at coding that in

I have seen a post that may work but that uses the save () instead of insert () function. Not sure the exact differences between those.

This save function?

The difference is that save will update the item if it already exists in the collection (based on if the _id already exists). In this case I’m guessing the user will only inserting new items, not updating any.