Hi Guys! need some help regarding this code, I want to save the current items from the dynamic data set when the page loads with the new input values in a new row on my database to display on a table, It happens that when I click submit it only updates the items but not adding or duplicate the current items I get to a new row for my database collection. Please help me, Here is the code, Thank you
import wixLocation from ‘wix-location’ ;
import wixData from ‘wix-data’ ;
$w . onReady ( function () {
});
//Request Deploy Button
export function button4_click ( event ) {
$w ( ‘#button4’ ). label = “Requesting . . .”
// Get Current Product Item
const productDetailsDataSet = $w ( “#dynamicDataset” ). getCurrentItem ();
const newJobOrder = $w ( ‘#newJobOrder’ ). value
const requestBy = $w ( ‘#requestBy’ ). value
const deployment = $w ( ‘#deployment’ ). value
const dateRequested = $w ( ‘#dateRequested’ ). value
const deliveryAddress = $w ( ‘#deliveryAddress’ ). value
const deployedPieces = $w ( ‘#deployedPieces’ ). value
const deployedCases = $w ( ‘#deployedCases’ ). value
const deployedBy = $w ( ‘#deployedBy’ ). value
let remainingPieces = 0
let remainingCases = 0
// Check if caseshas a value
if ( deployedPieces != ‘’ ){
if ( productDetailsDataSet . pieces < parseInt ( deployedPieces )){
console . log ( ‘Insufficient Quantity’ )
}
remainingPieces = productDetailsDataSet . pieces - parseInt ( deployedPieces )
}
// Check if caseshas a value
if ( deployedCases . toLowerCase () != ‘’ || deployedCases . toLowerCase () != ‘none’ ){
if ( productDetailsDataSet . cases < parseInt ( deployedCases )){
console . log ( ‘Insufficient Quantity’ )
}
remainingCases = productDetailsDataSet . cases - parseInt ( deployedCases )
}
// Mapping into DB
$w ( “#deployedDataSet” ). setFieldValues ({
… productDetailsDataSet ,
deployedPieces : parseInt ( deployedPieces ),
deployCases : parseInt ( deployedCases ),
newJobOrder ,
requestBy ,
deployment ,
dateRequest : new Date ( dateRequested ),
deployedBy ,
deliveryAddress
});
// Save to DB
$w ( “#deployedDataSet” ). save (). then (
res =>{
console . log ( “Success!!” )
}
). catch ( err =>{
console . log ( err )
})
// Insert to Ending Inventory
$w ( ‘#endingInventoryDataSet’ ). setFieldValues ({
… productDetailsDataSet ,
endingPieces : remainingPieces ,
endingCases : remainingCases
})
// Save to DB
$w ( “#endingInventoryDataSet” ). save (). then (
res =>{
console . log ( “Success!!” )
}
). catch ( err =>{
console . log ( err )
})
. then (()=>{
wixLocation . to ( ‘/test-summary’ );
})
}