Classic Car Club:
A database currently allows people to join as members taking in their personal information.
But we would like to create a database for each user that tracks the make, model, year, number of years owned, modifications and number of awards for each car that each owner owns.
Specifically, Jim has 2 cars, Kyle has 7, and Mark has none so this database needs to generate new line items based on the member adding them. Each member will keep their car database PRIVATE from the rest of the club until a later date.
How in the world is this accomplished?
Another way to describe this is to take a Business Profile Database fully loaded with information and then to allow each business to add their employees’ info of which is attached to their Business Profile. Where the Names, addresses, phone numbers, etc are gathered. The number of employees per business would be different. And the employees information would be privately kept for only the Admin and the Business to see.
1 Like
Hey
Create a Data Collection called UserData and in that Collection you store stuff about the registered users that you can’t in wixCRM. Remember to store the userId in a field here so you can filter out information on Member Account Pages easily using a Dataset and the filter _owner = Logged in User.
Then create a new Data Collection called Cars or Items. In this Data Collection create the fields you want, make, model, year, nrofyearsowned and so on…
Then create a page with a form where the logged in users can add a car. Add Dataset Write Only to the Cars Data Collection. All added records through this form will automatically get _owner = their user id because they are logged in when submitting the form.
Then you can easily make a table with all their cars, click one row and end up on their own car page to edit and make modifications. Just make sure when you add Dynamic Pages to the Cars Collection that you set the filter to _owner = Logged in User to prevent other users to see my cars but only their own added cars.
Then you can hook up Awards, Modifications and so on as separate Data Collection connecting this two Data Collection to the Cars Data Collection by using a reference field. Then on the Dynamic Page for the Car you can add a new Dataset Write Only to the Awards Data Collection, add form elements and a Button with text SAVE and connect it’s action to the Submit Action of that Dataset. And Voila, now they add awards to their cars.
Hope that helps a bit!
Also, here is a great article for you to read.
Wow, thanks bud!
One question: _owner = Logged in User
where do I, how do I…
1: Create UserData Database (name, address, etc)
2: Create Cars Database (make, model, etc)
3: Create New Page titled “Add Your Cars” with:
* add/user input/text/input box
* add/database/dataset
* @ dataset: Manage dataset
* Set settings as “Connect a collection=Cars”, “Mode=Write-Only”
*attach each input box:
* @ Input: Connected to data
*Set settings as “Connect a dataset=Cars”, “Value connects to (make, model, etc)”
…where to from here? and did I miss a step for the _owner Logged in User
Thanks in advance!!
Thats a project for a Wix Coder, not a question man 
My apologies for the presentation of info. I was just laying out the process in a lineal format. Basically, a step by step that I took to get to what you were talking about.
In short, where and how do I add the _owner = Logged in User?
Filter of the Dataset. Take a day and read articles up here in the menu.