Import from multiple datasets to one dataset

Ask the community
,
1

Hi!

I have multiple dropdowns which are connected to datasets. I have connected every dropdown to specific dataset. I need to import user selection from every dropdown to one other database which collects selections from dropdowns/users. I have managed to make it work for first dropdown, but I can not replicate it to other dropdowns.

Code:

$w.onReady( function () {
let itemObj
$w( ‘#button1’ ).onClick(()=>{
$w( ‘#dataset2’ ).onReady( () => {
itemObj = $w( ‘#dataset2’ ).getCurrentItem();
console.log(itemObj)
console.log(itemObj.title)
})

    $w( "#dataset1" ).onReady(() => { 
        $w( '#dataset1' ).setFieldValue( 'tema1' , itemObj.title) 
        $w( '#dataset1' ).save() 
    }) 
})

});

Thank you in advance!

2

Surely not the best solution, but could fit to your issue…

$w.onReady(function () {
 let itemObj0, itemObj1, itemObj2
    $w('#button1').onClick(()=>{
        $w('#dataset2').onReady( () => {
            itemObj0 = $w('#dataset2').getCurrentItem();
            console.log(itemObj0)
            console.log(itemObj0.title)
        })

         $w('#dataset3').onReady( () => {
            itemObj1 = $w('#dataset3').getCurrentItem();
            console.log(itemObj1)
            console.log(itemObj1.title)
        })

         $w('#dataset4').onReady( () => {
            itemObj2 = $w('#dataset4').getCurrentItem();
            console.log(itemObj2)
            console.log(itemObj2.title)
        })

        $w("#dataset1").onReady(() => {
            $w("#dataset1").setFieldValues( {
             "tema1": itemObj0.title,
             "tema2": itemObj1.title,
             "tema3": itemObj2.title,
            });
            $w('#dataset1').save()
        })
    })
});

Instead of using a normal → setFieldValue
Use a → setFieldValues

3

Thank you very much!

Just now before I saw you answer come to solution. I´ll post it here in the answer to original question. Tomorrow I will try yours and see which is more suitable.

Thank you again!

4

Seems this is working:
$w.onReady( function () {
let itemObj
$w( ‘#button1’ ).onClick(()=>{
$w( ‘#dataset2’ ).onReady( () => {
itemObj = $w( ‘#dataset2’ ).getCurrentItem();
console.log(itemObj)
console.log(itemObj.title)
})

    $w( "#dataset1" ).onReady(() => { 
        $w( '#dataset1' ).setFieldValue( 'tema1' , itemObj.title) 

    }) 

}) 
$w.onReady( **function**  () {

let itemObj2
$w( ‘#button1’ ).onClick(()=>{
$w( ‘#dataset4’ ).onReady( () => {
itemObj2 = $w( ‘#dataset4’ ).getCurrentItem();
console.log(itemObj2)
console.log(itemObj2.title)
})

    $w( "#dataset1" ).onReady(() => { 
        $w( '#dataset1' ).setFieldValue( 'tema2' , itemObj2.title) 
    }) 
})

$w.onReady( function () {
let itemObj3
$w( ‘#button1’ ).onClick(()=>{
$w( ‘#dataset5’ ).onReady( () => {
itemObj3 = $w( ‘#dataset5’ ).getCurrentItem();
console.log(itemObj3)
console.log(itemObj3.title)
})

    $w( "#dataset1" ).onReady(() => { 
        $w( '#dataset1' ).setFieldValue( 'tema3' , itemObj3.title)

})
})
$w.onReady( function () {
let itemObj4
$w( ‘#button1’ ).onClick(()=>{
$w( ‘#dataset6’ ).onReady( () => {
itemObj4 = $w( ‘#dataset6’ ).getCurrentItem();
console.log(itemObj4)
console.log(itemObj4.title)
})

    $w( "#dataset1" ).onReady(() => { 
        $w( '#dataset1' ).setFieldValue( 'tema4' , itemObj4.title) 

}) 
})

})
})
})
})