Sync a dataset with a dataset

Ask the community
,
1

Hi everyone, I want to sync one dataset with another dataset … let me explain, I want for example: when I add something in dataset1, dataset2 automatically has the same as dataset1
If somebody can help me please

2

Do you already use some code?
Or do you have done all your connections in the wix property-panel with the help of datasets? I assume you have done it without code and your problem now will be, that you can not connect 2 different datasets to one button-action?

Your first DATABASE is already working? Does it already save data in your first DB? Surely you have connected your SUBMIT-BUTTON with your dataset and setted it up as → SUBMISSION-PROCESS, which writes all your data into DB1.

Now you want to get a second DB → DB2 also filled with the same values? Creating a dublicate-DB? If so, your problem will be (like already mentioned) that you can not connect a second dataset to the already connected button, right?

So in this case you will need code, whcih will do the work.

$w.onReady(()=> {
  $w("#myDataset").onReady(()=> {
    $w("#myDataset").save();
    $w('#mySubmitButtonIDhere').onClick(()=>{
       $w("#myDataset").setFieldValues( {
         "title":  "New Title",
         "name":   "New Name"
       });
    });    
  }); 
});

The orange marked VALUES, you then can replace with your input-values…

$w('#myInputElementID1here').value
$w('#myInputElementID2here').value

Modify and expand this example for your own usecase.

3

Thanks my friends i’ll test it now!!

4

well…that doesn’t seem to work, maybe i didn’t explain myself correctly so

2656×1286 194 KB

I connected my database1 to a repeater

2656×914 141 KB

And i connected my database2 to a another repeater

2656×914 176 KB

and i connected my database2 to a form and i want to sync my database2 with my database1 for the database1 show what i’ve type in the form like the first screenshot

I hope you understand what i mean and you can help me🙏🏾!

5

@ticho-lama1
You are talking about 2x databases, can i see the 2x databases?
Please make a screenshot of both databases.

6

708×1248 54.2 KB

7

Sorry, but this is not exactly what i was asking for.
I need to see the sctructure of the 2 involved DBs.

Open your DBs and make a screenshot of the INSIDE of the DBs, especialy the involved DB-Fields.

8

ohh i got you

9

this is the Db 1

2808×1494 330 KB

2808×1494 275 KB

2808×1494 242 KB

And this is the Db 2

2808×1494 242 KB

2808×1494 270 KB

2808×1494 252 KB

2808×1494 246 KB

10

It still not really clear for me what you want to achieve.
Why you separate the data into 2x Databases`?

However, i think you are looking either for a REFERENCE-FIELD or INCLUDE…
https://www.wix.com/velo/reference/wix-data/wixdataquery/include

https://www.wix.com/velo/reference/wix-data/queryreferenced

You normaly also should be able to do it with a help of dataset.

11

Cause i want 1 Database to show what people submit from the form and an another database to allow the editing… i don’t know if you understand what im saying tell me if not