Create a new blank dataset for each new customer

Ask the community
,
1

Hi,

I’m trying to create a stock tracking website, is it possible to have a dataset that customers input data into and it save (I’ve done this part) but i want each customer to have the same database but there own version. so only they can edit and view there own dataset in a repeater

so I would like to have a data set with say 4 column’s to be create and linked in the input fields like the original i have created, but blank ready for them to input into.

is this possible?

many thanks
Adam

2

I do believe that this is possible, but I don’t think that’s practical. If you have a thousand clients you’d have 1000 datasets and I do believe that’s a bad idea.

What you can have though is a single dataset with multiple data on the same cell using arrays, for example:

image
image612×636 47.9 KB

There a single cell has info about product weight, name, quantity, sku, etc.

About the client beign the only one allowable to edit and see the information, you could have the first column having the client ID and compare the logged user with the dataset ID, so he couldn’t change someone else’s data.

3

Thank you! This sounds like a much better plan!!

Is this possible to auto fill when someone is login in anytime they enter so content it adds there ID number?

4

Yes, by code everything is possible.

5

Hi, I’m very new to code, I’ve managed to do the very basics, are you able to help me get started with this?

Any help would be greatly apricated

6

First of all make clear how you want to define and sctructure your database.
At first moment forget about the DATASETS (DDATASETS) are only connections to the DATABASES in the background.

So the most important is the structure of your databse (collection).
The structure will depend on what you want to achieve on your website and what kind of data you want to store inside your databse.

Like ‘Clube_Taberneiros’ already mentioned, you can use different types of fields, which also would change the structure and behaviour of your database and its corresponding elements on your page.

On other hand you also can first setup your page and place all elements you need first and then modify your database corresponding to the elements given on your page.

You have these 2 options where you can start with.

So let us first collect all information about your wishes…

  1. —> autofill ID number when login (where to autofill) ??? —> Make sure that your description is always complete and detailed.

This part is a separate code-part, since here you will have to determine and define a function which will be able to catch ID’S of logged-in members on your site…

SEE HERE: …

Once you have defined the current member and his ID, you can store (save) it inside your database, whereever you want.

  1. I’m trying to create a stock tracking website —> OK! What DB-Fields would you need to be found inside your database?

a) OWNER-ID
b) ITEM-ID
c) TITLE
d) NAME
e) WHATEVER

Create first the fields you already know, that they will be included inside your database.

Then define of which kind of type these fields would be…
a) STRING-DATA
b) ARRAY-DATA
c) OBJECT-DATA
d) IMAGE
e) and so on…

  1. There are many ways of how to structure your project’s database having all of them at the end the same result.

You can use either DATASETS like mentioned by you, or doing it by using wix-data and queries…

Take a look here…

…or for datasets here…
https://www.wix.com/velo/reference/wix-dataset/dataset

What you need is more then just a simple DATABASE + DATASET -SETUP