How to show Data Collection Items as pre-filed Field in WixForm ???

How to show Data Collection Items as pre-filed Field in WixForm ???

-How do look like your → “wix-form” ? (custom-form) ?
-How do look like your → DATABASE-Structure?

You will have 2x ways, how to solve it.

  1. Going the DATASET-WAY…
  2. Going the Wix-Data-Way…

Hi Thank you for replying
Let me explain the Issue first
This website is about the Car dealer, www.exoticwheelsindia.com
I have Created a single collection converting into Dynamic pages and with the help of repeaters i am able to display the cars as item and individual since Wix Store was not meeting my design format which also eliminate my Cart and store booking system as well the Wix Booking featured is not meeting the expectation
So with this I end up to creating another Dynamic Page for the Collection named booking where the Customer is able to see which car he is booking but that doesn’t reflect in my Form due to It cannot be Connected to my data collection

I don’t know any thing about Coding don’t even understand language however If steps are given i am sure i can follow it properly

Check the Website and open Exotic Collection (Item Page) select any car and open it you will see the car details page (Item’s Dynamic Page) there you will find the book now button
so now what i want here is if customer click that button i want him to lead the form by entitling the car (Item’s Dynamic Page has to be preselect in the form

Now i need a help here either its Data Set way or Wix data set way whatever you think that might help me
or if you think i need to know more and anything which can resolve my very minor issue which might be easy for you but it is very important feature of my website which connects me to the customer
thank you

@adcmediaa
I see the → “Book-Now” button, which do not work at all and do not open any FORM…

-Which → FORM ← should be opened and prefilled?
-How is setted-up your database/database-structure?
a) Database-name
b) Database-ID
c) Database-Fields
…and so on

How do look like your form ?
Is it a custom-form ?
Is it another type of form ? (Wix-Form)
It is a form from an → APP?

You should give some more details.

@russian-dima Thank you so much for replaying i really appreciate

I dont know what exactly this are called my database-Exotic Collection, and
Database ID, Database field no idea how to know that or how to find them ?

FORM
There is no form currently link to it as I want to know which form can be used which can give my customer option to book the car or any car which customer open and Book it by clicking on book now button

I have created this booking page by adding another dynamic Page from Items
now here i have Form where the Drop down option is provided in the form i wish to have the selected car by the customer which should be in the form automatically or as i said should be preselected while submitting the form

In simple word i want to make a booking feature of my own not the Wix Booking feature

@adcmediaa
Ok, i already understood that you want to create your own “booking-system”.
But one more time → first you should be clear about, how will be structured your database. Which datafields will be existing in the database?

Will this database be a SINGLE-DATABASE, or will it be devided in several ones.
(will it have multi-references and so on).

  1. Where to find my database-name & database-ID?

Let’s say you have a DATABASE → called → " Exotic-Cars "


The ID can be found when opening the options-panel of your current database…


…clicking on the 3-dot-menu. Normaly the DATABASE-ID is the same like the DATABASE-NAME, if you did not change it on first time-creation.

  1. Where to find my databasefields?
    You will find all the DATABASE-FIELDS inside your DATABASE. In this example you can see the following database-fields…
  2. Title
  3. Car-Type
  4. Car-Price
  5. Car-Model
    …and so on…

To get all the IDs of these DATAFIELDS -->…left-click on…


Corresponding IDs would be…

  1. title

  2. carType

  3. carPrice

  4. carModel
    …and so on…

  5. How should look like my database-structure?
    On my opinion, you should have 2x-DATABASES…

  6. Exotic-Cars → Here you can store all DATA about all cars.

  7. Bookings → Into this collection, you will add just the related car-data (ID) and needed customer-data + date and time of booking.

  8. Which data should be included in my BOOKINGS-database? You already predefined your form, which will collect the needed data for bookings…

Ok, here the flow of your PROJECT.

  1. User logs-in or how ever.
  2. User navigates to → “Exotic-Collection-Page”.


3) User make choice and selects an exotic-car.


4) User clicks onto the Book-Button and navigates to dynamic booking- page…


5) Here the user will see a prefilled FORM, where he can input his private/personal-data, to make a request/booking.

Till here i understood the flow of your project the right way?
What about your database-structure? Do you have a DB-structure similar to this example?

@russian-dima Yes i Have 2 collection

I have show their IDs to you in the video also what i wish to that the drop down should already have the car selected to which customer is booking by clicking on book now button he should not reselect it by dropping down should be automatically selected as the customer click on the Book now button

This website is created on Wix Editor not on ADI or X editor

I have Reference Field in Booking Collection of Exotic Collection Title field the only reference i have Mentioned in the data base

@adcmediaa
Ok, this post here will help you to solve your problem.

Read it carefully and try to understand as much as you can.

Than you can use it on your own dynamic-page… to populate your DROPDOWN.


@russian-dima I have paste the code and entered where you have asked to mention Database
now next step is ? i am unable to get from that post

As i can see, you even did not read the whole post. This will not work like that.
I just can help you to help yourself. Please read the whole given post, then you will be able to achieve your aim and to solve your issue.

This will not work trough a simple COPY&PASTE!

If (you need a --> SERVICE) {you can find my e-mail on my profile}
Else {you will have to do it on your own}  

Hey @adcmediaa

This forum has a great community that is willing to help you solve your problems or give you ideas on how to do it yourself, and what it isn’t though, a source or place where you expect to find full solutions or complete code for your needs, it’s all included in the community guidelines .

@russian-dima i am So sorry i didn’t meant that and you been so kind
I will be doing it by myself i wasn’t sure or confirm what is the next step so asked you as was unable to understand from the post
anyways let me follow the steps

THANK YOU VERY MUCH SIR

@adcmediaa You will need some days to understand the mentioned post, but at the end you will be able to solve it. I am almost sure. Everything you have to know, you will find in the post.

Good luck.

@russian-dima yes so far i m stuck here

@russian-dima Total confused as it going over my head i m really confused as to where to start since i do not need dropdown option it was just i couldnt find any other way to apart from dropdown option to dispay my collection field all i want is to display the car title when someone book that car from the from

I hope i get it and solve this problem with that post

@adcmediaa
DB-Field-IDs and Database-ID do not need a hashtag as first char.

But all element-IDs do.

@russian-dima Thank you brother however i really don’t know why i am not able to relate the post you are referring with my issue as i do not wish to have dropdown at all

So i have one single database for all my cars Exotic Collection (DB id is ExoticCollection
Now i have Created a Form Dataset name CarBooking where i want the visitor information to get stored
all i want is that customer get to this page by clicking on Book now button which leads them to the below page (dynamic item page) where the visitor fill in there details

after the submit


like all the other fields title Field should be the title of the car “Aston Martin” as per the current page image example or any car visitor had open should also be captured automatically with the information of the Car title along with customer information filled in once he submit the form

I hope i am able to explain it what i looking for with this above details

@adcmediaa
Ok, i think i missunderstood the issue.

How ever, what you want is the navigation between 2-dynamic pages with all it’s inter-functions.

The most can be done without any code → by using DATASET! (dynamic).
But as you can see, you have reached a point, where it is not possible to continue without using → CODE.

So, what do we know?
What do we have?
What do we want to achieve?

You will have 3x dynamic pages in your Project.

  1. Exotic-Car-Collection (ALL) → Here you will have your REPEATER filled with all items of your EXOTIC-CAR-COLLECTION.

  1. Exotic-Car-Collection (ITEM) → This is the page of each item, stored in your EXOTIC-CAR-COLLECTION.

  1. And at least you will have a bookings-page (also dynamic?) → YES!
    Here you also get all the data of each CAR (ITEM) to show on the current BOOKING-page.

Now! → What to do on the → (3)-Booking-page?

You surely have connected all the elements with the dynamic-dataset. This allows you to show all CAR-DATA on this last page. That means you also would not have any problem to save all connected CAR-DATA into a DATABASE.

But how to get the second data (USER-ENTERED-DATA)?
Here you can’t connect it the same way you did with CAR-DATA, right?

At this point some CODE is needed (and do not forget → you are working with a dynamic dataset → SINGLE-ITEM-LOADING).

Give your SUBMIT-BUTTON the shown ID in this example and click on it.
Navigate to → CONSOLE and see what happens.

let itemIndex, itemData

$w.onReady(function () {
 $w('#dynamicDataset').onReady(()=>{
 itemIndex = $w('#dynamicDataset').getCurrentItemIndex(); //console.log("Item-Index: ", itemIndex)
 itemData = $w('#dynamicDataset').getCurrentItem(); //console.log("Item-Data: ", itemData)
 });

 $w('#btnSubmit').onClick(()=>{console.log("Button --> [SUBMIT] clicked")
 console.log("Item-Index: ", itemIndex)
 console.log("Item-Data: ", itemData)
 console.log("First-Name: ", $w('#inpFirstname').value);
 console.log("Last-Name: ", $w('#inpLastname').value);
 console.log("Email: ", $w('#inpEmail').value);
 });
});

This should give you some more understandment, of what you are doing (or try to do).

Then you will have to add more code, to be able to SAVE DATA into another DATABASE.

Take a look into the VELO-API-DOCUMENTATIONS and you will find all needed examples of how to do the rest of code.

Good luck! :wink: (Do not forget to replace all ELEMENT-IDs with your own ones) !